PI48724: CC - DB2 CATALOG COPY VERSION MAINTENANCE SQLCODEN204 HOW TO HIDE OPTION FROM PANEL ADB2

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS' install process does not
  provide an option to remove the 'CC - DB2 catalog copy version
  maintenance' from the panel ADB2
  'DB2 Administration Menu 11.2.0'.
  If the Catalog Copy function is not enables users will see a
  SQLCODEN204 / SQLCODE -204 error.
  

Local fix

• None.
  ADDITIONAL INFORMATION:
  ALSO CONTAINS FIX FOR SQLCODEN4743 IN AOC 11.2
  THAT WAS FIXED  BY PI43628.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS and IBM Tools Customizer for z/OS.      *
  ****************************************************************
  * PROBLEM DESCRIPTION: When the following parameter on panel   *
  *                      CCQPPRD 'Product Parameters' is         *
  *                      disabled, the 'CC - Catalog copy'       *
  *                      option on panel ADB2 'DB2               *
  *                      Administration Menu' is not hidden      *
  *                      nor disabled:                           *
  *                                                              *
  *                      Catalog Copy database  . .NO            *
  *                      (YES, NO)                               *
  *                                                              *
  *                      and results in a SQLCODE=-204 /         *
  *                      SQLCODEN204 error:                      *
  *                                                              *
  *                      DSNT408I SQLCODE = -204,                *
  *                      ERROR: >HLQ<.>table_name< IS            *
  *                      AN UNDEFINED NAME                       *
  *                      DSNT418I SQLSTATE = 42704               *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When the following parameter on panel CCQPPRD 'Product
  Parameters' is disabled, the 'CC - Catalog Copy' option on
  panel ADB2 'DB2 Administration Menu' is not hidden nor
  disabled:
  
  Catalog Copy database  ....... NO  (YES, NO)
  

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:

  UI32238 UI32239

Modules/Macros

•    ADB$$DSC ADB$$PRM ADB$$SEQ ADBBIND  ADBCFGBD
  ADBCUST  ADBR     ADBSETUP
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RB10 PSY UI32238

     UP15/10/23 P F510

• RB20 PSY UI32239

     UP15/10/23 P F510

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.