Re: What causes "Database connection started" (CPF9160) -- MIDRANGE-L

a few suggestions to look at if you have not already done so

1. Do you actually use DDM? If not sure, this will indicate if listener
running
NETSTAT , opt 3

Remote Remote Local
Opt Address Port Port Idle Time State
* * ddm 840:19:14 Listen
* * ddm-ssl 840:18:52 Listen
after the error occurs, check this job log (may need to increase log level
of its jobd QDFTSVR ..) from here or wrkactjob

Opt Name User Number Type User
QRWTLSTN QUSER 681176 *BCH QUSER

2. dsppgm your sqlrpgle and is *LOCAL your database
Program . . . . . . . : NTOSQL1 Library . . . . . . . : XXXPGM

DB2 for IBM i module attributes:
Number of SQL statements . . . . . . . . . . . : 8
Commitment control . . . . . . . . . . . . . . : *CHG
*Relational database . . . . . . . . . . . . . : *LOCAL *

Naming convention . . . . . . . . . . . . . . : *SYS
Allow copy of data . . . . . . . . . . . . . . : *OPTIMIZE
Allow blocking . . . . . . . . . . . . . . . . : *ALLREAD
Delay PREPARE . . . . . . . . . . . . . . . . : *NO

3. have you updated QSYS/QAQQINI file beyond IBM defaults ?
select * from qsys/qaqqini to display
(or have libl with a QAQQINI file higher than QSYS
or multiple pgms calling the sqlrpgle that are in some way altering the
environment depending upon where called from, like external calls from
outside the system, web programs, )?

and finally - i've imbedded PRTSQLINF (to unused outq) in job streams
before to capture events that seem random

Jim Franz

On Fri, Nov 8, 2024 at 4:31 PM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

Good. That pretty much leaves out "DDM" or any remote connections.
I cannot figure out why it would have trouble connecting locally.
My mind is on a game tonight though.

On Fri, Nov 8, 2024 at 4:24 PM Justin Taylor <jtaylor.0ab@xxxxxxxxx>
wrote:

The hostname and IP mentioned in the job log are for the local server.

date: Fri, 8 Nov 2024 15:41:45 -0500
from: Rob Berendt <robertowenberendt@xxxxxxxxx>
subject: Re: What causes "Database connection started" (CPF9160)

Does it actually mention a remote system?
Perhaps it is doing a connection even if you are using the local entry
shown in WRKRDBDIRE

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.