PI82940: LIBDEF STILL OCCURS WITH LIBDEF(NO), CM OPTION ON MAIN MENU MAY RESULT IN SQLCODE 204

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This APAR addresses the following issues:
  1.  For Version 11, Release 1, Version 11, Release 2, and
  Version 12, Release 1:
  When the product libraries are pre-allocated via a logon
  procedure, and the product is invoked with the
  LIBDEF(NO) option, the LIBDEFs still occur.
  2.  For Version 12 Release 1 only:
  When setting parameter 'Change Management database'
  to 'NO' and 'Enable CM on DB2 Admin Tool primary menu'
  to 'YES' during the customization process, the option
  'CM' appears on panel ADB2 'DB2 Administration
  Menu', which will result in SQLCODE = -204 /
  SQLCODEN204, because the CM objects do not exist:
  DSNT408I SQLCODE = -204, ERROR: >schema<.ADBCHG
   IS AN UNDEFINED NAME
   DSNT418I SQLSTATE = 42704
   SQLSTATE RETURN CODE
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Administration Tool for         *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: For DB2 Administration Tool             *
  *                      for z/OS, Version 11, Release           *
  *                      1, Version 11, Release 2,               *
  *                      and Version 12, Release 1:              *
  *                                                              *
  *                      1 - Option LIBDEF(NO) still             *
  *                      produces LIBDEFs.                       *
  *                                                              *
  *                      For DB2 Administration Tool             *
  *                      for z/OS, Version 12, Release           *
  *                      1 ONLY:                                 *
  *                                                              *
  *                      2 - The option  'CM' appears on         *
  *                      panel ADB2 'DB2 Administration          *
  *                      Menu' which will result in              *
  *                      SQLCODE = -204 / SQLCODEN204            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  1 - When the product libraries are pre-allocated via a logon
  procedure and the product is invoked with the
  LIBDEF(NO) option, the LIBDEFs still occur.
  
  2 - When setting parameter 'Change Management database'
   to 'NO' and 'Enable CM on DB2 Admin Tool primary menu'
   to 'YES' during the customization process, the option
   'CM' appears on panel ADB2 'DB2 Administration
   Menu' which will result in SQLCODE = -204 /
   SQLCODEN204 because the CM objects do not exist:
  
  DSNT408I SQLCODE = -204, ERROR: >schema<.ADBCHG
   IS AN UNDEFINED NAME
   DSNT418I SQLSTATE = 42704
   SQLSTATE RETURN CODE
  

Problem conclusion

• Problems have 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:

  UI48282 UI48283 UI48284

Modules/Macros

•    ADB      ADBASP   ADBASPR  ADBCCM   ADBCP
  ADBCUPC  ADBCUST  ADBCVCP  ADBDAT   ADBDCAC  ADBDMT   ADBH1K
  ADBL     ADBMAIN  ADBPARM  ADBP7O   ADBR     ADBRIP9  ADBRI00
  ADBTEP2  ADBXCAC  ADBXGTI  ADB0     ADB2     ADB2AUH  ADB2AUS2
  ADB2AZ   ADB2AZI1 ADB2CDC  ADB2CIMP ADB2CME  ADB2CMF  ADB2CMO
  ADB2CMP  ADB2CMR  ADB2CMS  ADB2CMT  ADB2CMU  ADB2CM1  ADB2CM2
  ADB2CM3  ADB2DEP  ADB2EL   ADB2EQ   ADB2GEN  ADB2MSK  ADB2PA
  ADB2PRP  ADB2PSTM ADB2RALL ADB2RE   ADB2REE  ADB2REG  ADB2REH
  ADB2REM  ADB2REP  ADB2RER  ADB2RES  ADB2RET  ADB2REU  ADB2REX
  ADB2REY  ADB2REZ  ADB2RGC  ADB2RIP  ADB2WCL  ADB2ZZMN ADB2ZZSP
  ADB21    ADB21P   ADB21SA  ADB25TU  ADB27AC  ADB27SP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI48282

     UP17/06/28 P F706

• RB20 PSY UI48283

     UP17/06/28 P F706

• RC10 PSY UI48284

     UP17/06/28 P F706

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.