PM78510: DB2 ADMINISTRATION TOOL FOR Z/OS V10.2.0 CUSTOMIZATION PROCESS DOES NOTCREATE JOB FOR USER DEFINED INDEXES ON CATALOG FOR DB2

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS V10.2.0 customization process
  does not
  create job for user defined indexes on catalog for DB2 V9
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool and     *
  *                 IBM Tools Customizer (TCz) for z/OS who use  *
  *                 user-defined indexes on a DB2 9 catalog.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following separate issues will be   *
  *                      addressed:                              *
  *                                                              *
  *                      1 - When using user defined indexes on  *
  *                      a DB2 9 catalog, TCz does not generate  *
  *                      the member ADBCX in the JOBLIST.        *
  *                                                              *
  *                      2 - The TCz DISCOVER process issued     *
  *                      the following 'NOVALUE' error in        *
  *                      ADB2CUST when DEBUG=YES:                *
  *                                                              *
  *                      NOVALUE condition raised in ADB2CUST    *
  *                      SYSEXEC.                                *
  *                      Line 2865: Say ' server '               *
  *                      LENGTH(server) server                   *
  *                                                              *
  *                      3 - TCz Usability issue where order     *
  *                      of Checkpoint parms are inconsistent    *
  *                      with Catalog copy and Autostats.        *
  *                                                              *
  *                      4- SAMP lib jobs ADBGC and ADBGC10      *
  *                      used to GRANT privilege on DB2 Catalog  *
  *                      tables were not generated in TCz        *
  *                      JOBLIST.                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following separate issues will be addressed:
  
  1 - When using user defined indexes on a DB2 9 catalog, TCz
  does not generate the member ADBCX in the JOBLIST.
  
  2 - The TCz DISCOVER process issued the following 'NOVALUE'
  error in ADB2CUST when DEBUG=YES:
  
  NOVALUE condition raised in ADB2CUST
  SYSEXEC.
  Line 2865: Say ' server  ' LENGTH(server)
  server
  
  3 - TCz Usability issue where order of Checkpoint
  parms are inconsistent with Catalog copy and Autostats.
  
  4- SAMP lib jobs ADBGC and ADBGC10 used to GRANT privilege
  on DB2 Catalog tables were not generated in TCz JOBLIST.
  

Problem conclusion

• Problems has been resolved.
  
  Two new SAMP lib members have been added to SADBDENU:
  1. ADBGC   :  GRANT privilege on DB2 R810/9 Catalog tables
  2. ADBGC10 :  GRANT privilege on DB2 10 Catalog tables
  

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:

Modules/Macros

•    ADB$$PRM ADB$$SEQ ADBCATVT ADBCHKPT ADBCX
  ADBGC    ADBGC10  ADBPRHIS ADB2CUST
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK90399

     UP12/12/29 P F212

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.