Re: What causes "Database connection started" (CPF9160)

date: Sat, 9 Nov 2024 14:14:02 -0500
from: Jim Franz <franz9000@xxxxxxxxx>
subject: Re: What causes "Database connection started" (CPF9160)

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