PI11319: DB2 ADMINISTRATION TOOL FOR Z/OS REBIND ADB5146E ADB0006E RC00E70082

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 ADMINISTRATION TOOL for Z/OS REBIND Function generates
  RC00370082 after 500 Rebinds.
    ADB5146E Unexpected SQLCODE in :OPEN CURSOR prtADBCHKPT
    ADB5185E The run is ending due to errors.
    ADBT010W - Rollback performed due to previous error
    ADB0006E ADBCCM - Error(s) found.  Please review output.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use Change Management Batch         *
  *                 Interface (CM Batch) to perform a change     *
  *                 that will trigger an AUTOREBIND to be        *
  *                 executed.                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the CM Batch function to     *
  *                      perform a change, AUTOREBIND            *
  *                      generated REBIND will fail with the     *
  *                      following error:                        *
  *                                                              *
  *                      DSNT408I SQLCODE = -904,                *
  *                      ERROR:  UNSUCCESSFUL                    *
  *                      EXECUTION CAUSED BY  AN                 *
  *                      UNAVAILABLE RESOURCE.                   *
  *                      REASON 00E70082, TYPE OF                *
  *                      RESOURCE 3002, AND                      *
  *                      RESOURCE NAME NUMBER                    *
  *                      OF CURSORS                              *
  *                      DSNT418I SQLSTATE   = 57011             *
  *                      SQLSTATE RETURN CODE                    *
  *                                                              *
  *                      after executing 500 REBIND              *
  *                      PACKAGE's.:                             *
  *                      FORWARD                                 *
  *                      ADB5044I *** INPUT STATEMENT:           *
  *                      REBIND PACKAGE(>collection-id<.         *
  *                        >package-id<.(>version-id<))          *
  *                      DSNA618I DSNADMCS SQL                   *
  *                      ERROR DURING SQL STATEMENT              *
  *                      OPEN, STATEMENT=OPEN C5,                *
  *                      SQLCODE= -904, SQLERRMC=                *
  *                      00E70082 3002 NUMBER OF                 *
  *                      CURSORS,                                *
  *                      SQLERRP=DSNXERT,                        *
  *                      SQLERRD=-258,0,0,-1,0,0,                *
  *                      SQLWARN= , , , , , , , , , , ,          *
  *                      SQLSTATE=57011, SQL                     *
  *                      STATEMENT                               *
  *                      WORKING ON=SELECT                       *
  *                      "ROWNUM","TEXT"                         *
  *                      FROM SYSIBM.DSN_SUBCMD_                 *
  *                      OUTPUT ORDER BY                         *
  *                      "ROWNUM"                                *
  *                                                              *
  *                      ADB5146E Unexpected SQLCODE             *
  *                      in OPEN CURSOR prtADBCHKPT              *
  *                      ADB5185E The run is ending due          *
  *                               to errors.                     *
  *                      ADBT010W - Rollback performed           *
  *                            due to previous error             *
  *                      ADB0006E ADBCCM - Error(s) found.       *
  *                            Please review output.             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the CM Batch function to perform a change using
  AUTOREBIND, the job will fail with a SQLCODE=-904 / SQLCODEN904
  error after executing 500 REBIND PACKAGE's.
  

Problem conclusion

• Problem has been resolved.
  

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:

  UI18319 UI18320

Modules/Macros

•    ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UI18319

     UP14/05/28 P F405

• RB10 PSY UI18320

     UP14/05/28 P F405

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.