PH44604: SQLCODE = -923, ERROR:CONNECTION NOT ESTABLISHED: DB2 RESTRICTEDSYSTEM, REASON , TYPE , NAME USING CONNECTION POOLING (DSNMIN20)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• IMS MPP regions with IMS connection pooling (DSNMIN20) get Db2
  connection problems:
  .
  DSNT408I SQLCODE = -923, ERROR:  CONNECTION NOT ESTABLISHED: DB2
           RESTRICTED
           SYSTEM, REASON , TYPE , NAME
  DSNT418I SQLSTATE   = 57015 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    = DSNAET03 SQL PROCEDURE DETECTING ERROR
  .
  00C10002 is received. The IMS MPP regions terminate with U0444
  after this connection problem.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 for z/OS users of the Db2 for z/OS                   *
  * IMS attachment facility that use the Db2                     *
  * for z/OS initialization module DSNMIN20.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Applications using the Db2 for z/OS                          *
  * IMS attachment facility that use the                         *
  * Db2 for z/OS initialization module                           *
  * DSNMIN20 may encounter various                               *
  * errors when processing                                       *
  * SQL statements.                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  Applications using the Db2 for z/OS IMS attachment facility
  that use the Db2 for z/OS initialization module DSNMIN20
  may encounter errors when processing SQL statements
  including but not limited to SQLCODE -923 and
  ABENDS04E RSN00E50063.
  

Problem conclusion

• The Db2 for z/OS IMS attachment facility is updated to avoid
  the errors and allow SQL statements to be processed correctly.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI79843

Modules/Macros

• DSNMDR00 DSNMINIT DSNMSSAT DSNMTV06 DSNMDR10 DSNMID00 DSNMRI00
  DSNMSNO0 DSNMIN10 DSNMCMD0 DSNMIN20
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RC10 PSY UI79843

     UP22/03/31 P F203

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.