PI88904: 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

• N/A
  

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.
  This APAR does not deliver an additional fix, this APAR is a
  DOC APAR to include the missing ++HOLD information.
  

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:

  UI51238 UI51239 UI51240

Modules/Macros

•    ADBFBVB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI51238

     UP17/10/20 P F710 Ø

• RB20 PSY UI51239

     UP17/10/20 P F710 Ø

• RC10 PSY UI51240

     UP17/10/20 P F710 Ø

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.