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

[Justin Taylor <jtaylor.0ab@xxxxxxxxx>]

1. When it works correctly, no there's no DDM in NETSTAT.
2. It shows *LOCAL.
3. Except for one entirely blank row, they all show *DEFAULT.




> 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