PM97225: AOC / TCZ NEEDS TO SETUP / PASS CM BATCH RELATED VARIABLES AS SHARE POOL VARIABLES TO AOC

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Upon generating the AOC/TCz General Customization job ADBCUST,
  the following settings are missing:
  ISREDDE2 RIVERAF.TCZ.BETA.CUST.F1.$SY4A$.ADB1110(A0CUSTA
  Command ===>
  000304
  000305 * CM BATCH JCLLIB
  000306 :ADBJLB1.//ADBLIBS JCLLIB ORDER=ADBA20.DEFAULT.PROCLIB
  After submitting the General Customization job template ADBCUST,
  the Customization table ADBTPARM will not get updated
  accordingly.
  Upon invocation of AOC v10.2, the initialization process
  will scan the Customization table ADBTPARM for ADBJLB1
  and GOCCMNM and will fail to locate them and put in
  the SHARE pool. This in turn will cause a failure in
  the CM Batch interface (skeleton ADB2UJOB) where the
  following JCLLIB statement will not get generated
  when it should be:
  //ADBLIBS JCLLIB ORDER=ADBA20.ADBTCZ.PROCLIB
  The following AOC/TCz related parts needs to be updated
  to resolve this incident:
  CLIST   : ADBR
  EXEC    : ADB2CUST
  DENU    : ADBCUST
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool and     *
  *                 IBM Tools Customizer (TCz) for z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following have been fixed:          *
  *                                                              *
  *                      1. The Change Mangement Batch           *
  *                      interface (via skeleton ADB2UJOB)       *
  *                      job does not generate the following     *
  *                      JCLLIB statement:                       *
  *                                                              *
  *                      //ADBLIBS JCLLIB ORDER=>admin_hlq<.     *
  *                      ADBTCZ.PROCLIB                          *
  *                                                              *
  *                      2. Input field 'JCL procedure library   *
  *                      (PROCLIB)' on panel CCQPPRD 'Product    *
  *                      Parameters' will produce the value      *
  *                      '//ADBLIBS JCLLIB ORDER=ADBA20.         *
  *                      DEFAULT.PROCLIB' instead of 'ADBA20.    *
  *                      DEFAULT.PROCLIB' after submitting the   *
  *                      job template ADBCUST and rerunning      *
  *                      DISCOVER.  As a result, panel CCQPPRD   *
  *                      will issue the following error message  *
  *                      upon exiting the panel:                 *
  *                                                              *
  *                      CCQV004E Enter a fully-qualified valid  *
  *                      data set name                           *
  *                                                              *
  *                      3. Column GRANTEE to table              *
  *                      ADBCVERSCOPES was missing from the      *
  *                      DB2 Administration Tool for z/OS        *
  *                      UPGRADE Change Management database      *
  *                      template job ADBMCMA.                   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following have been fixed:
  
  1. The Change Mangement Batch interface (via skeleton ADB2UJOB)
  job does not generate the following JCLLIB statement:
  
  //ADBLIBS JCLLIB ORDER=>admin_hlq<.ADBTCZ.PROCLIB
  
  2. Input field 'JCL procedure library (PROCLIB)' on panel
  CCQPPRD 'Product Parameters' will produce the value
  '//ADBLIBS JCLLIB ORDER=ADBA20.DEFAULT.PROCLIB' instead of
  'ADBA20.DEFAULT.PROCLIB' after submitting the job template
  ADBCUST and rerunning DISCOVER.  As a result, panel
  CCQPPRD will issue the following error message upon exiting
  the panel:
  
  CCQV004E Enter a fully-qualified valid data set name
  
  3. Column GRANTEE to table ADBCVERSCOPES was missing from
  the DB2 Administration Tool for z/OS UPGRADE Change
  Management database template job ADBMCMA.
  

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:

Modules/Macros

• ADBCUST  ADBMCMA  ADBR     ADB2CUST ADB21XA  ADB28M
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK98550

     UP13/10/22 P F310

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.