PM86746: NO CM TABLE,-805 ADBPARM BIND, -204 ADBPROFILE_DATA ON ADB TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 ADMINISTRATION TOOL FOR Z/OS.
  NO CM TABLE,-805 ADBPARM BIND, -204 ADBPROFILE_DATA on ADB TABLE
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use Batch Restart program ADBTEP2.  *
  ****************************************************************
  * PROBLEM DESCRIPTION: Users of DB2 Administration Tool for    *
  *                      z/OS trying to use Batch Restart        *
  *                      program ADBTEP2 to execute the          *
  *                      CHECK DATA utility will get a           *
  *                      SQLCODE=-805 / SQLCODEN805 error on     *
  *                      package ADBPARM when Change             *
  *                      Management is not installed:            *
  *                                                              *
  *                      ADB5146E Unexpected SQLCODE             *
  *                               in :ADBPARM                    *
  *                      DSNT408I SQLCODE = -805, ERROR:         *
  *                      DBRM OR PACKAGE NAME                    *
  *                      STLEC1..ADBPARM.19402874-               *
  *                      121CCFB6 NOT FOUND IN                   *
  *                      PLAN ADBTEP2. REASON 03                 *
  *                      DSNT418I SQLSTATE = 51002 SQLSTATE      *
  *                      RETURN CODE                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Users of the DB2 Administration Tool for z/OS trying to use the
  Batch Restart program ADBTEP2 to execute the CHECK DATA utility
  will get a SQLCODE=-805 / SQLCODEN805 error on package ADBPARM
  when Change Management is not installed.
  

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:

  UK97291

Modules/Macros

• ADBTEP2
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK97291

     UP13/09/18 P F309

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.