PM83084: DB2 ADMINISTRATION TOOL FOR Z/OS IS MISSING LAST LINE EXPLAIN(NO) FOR PACKAGE ADBCRCP IN THE GENERATED BIND JOB

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS is missing last line
  EXPLAIN(NO)
  for package ADBCRCP in the generated BIND JOB
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool and     *
  *                 IBM Tools Customizer (TCz) for z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following problems have been        *
  *                      resolved:                               *
  *                                                              *
  *                      1.  The TCz generated bind template     *
  *                      job ADBBIND returns RC=8 / RC 8 due     *
  *                      to missing 'EXPLAIN(NO)' from BIND      *
  *                      PACKAGE(ADBL) MEMBER(ADBCRCP).          *
  *                                                              *
  *                      2.  A residual value that was not       *
  *                      properly cleared out during the         *
  *                      DISCOVER process inadvertently          *
  *                      populates the TCz input field           *
  *                      setting for 'DB2 Table Editor CLIST'    *
  *                      to all subsystem ids listed.            *
  *                                                              *
  *                      3.  The TCz input field 'SYSAFF         *
  *                      for DB2 utilities' on panels CCQPPRD    *
  *                      'Product Parameters' and CCQPDB2        *
  *                      'DB2 Parameters' allows 8 bytes         *
  *                      instead of 4 which will produce the     *
  *                      following 'invalid value' error after   *
  *                      completion of the General               *
  *                      Customization job ADBCUST:              *
  *                                                              *
  *                      subsys keyword  default  invalid value  *
  *                      --------------------------------------  *
  *                        *    JSYSAFF           STL01          *
  *                      <--- STL01 is a site-specific invalid   *
  *                      value that exceeds 4 bytes.             *
  *                      --------------------------------------  *
  *                                                              *
  *                      4.  When two input fields 'JOB class    *
  *                      for DB2 utilities' and 'SYSAFF for DB2  *
  *                      utilities' are blank on panels CCQPPRD  *
  *                      'Product Parameters' and CCQPDB2        *
  *                      'DB2 Parameters', the General           *
  *                      Customization job for template          *
  *                      ADBCUST will complete with the          *
  *                      following error:                        *
  *                                                              *
  *                      Unrecognized keywords:                  *
  *                      subsys  keyword  invalid value          *
  *                      --------------------------------------  *
  *                        *           JSYSAFF                   *
  *                        DSNA  JCLASS                          *
  *                        DSNA  JSYSAFF                         *
  *                      --------------------------------------  *
  *                                                              *
  *                      5.  When the DB2 Cloning Tool option    *
  *                      is enabled on panels CCQPPRD            *
  *                      'Product Parameters' and CCQPDB2 'DB2   *
  *                      Parameters', the DB2 Administration     *
  *                      Tool does not enable the DB2 Cloning    *
  *                      Tool line command option 'CT -          *
  *                      Migrate this table using the DB2        *
  *                      Cloning Tool' on panel ADB21T 'Tables,  *
  *                      Views, and Aliases'.  The same problem  *
  *                      occurs with the DB2 Table Editor        *
  *                      option.                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following incidents have been resolved:
  
  1.  The TCz generated bind template job ADBBIND returns RC=8 /
  RC 8 due to missing 'EXPLAIN(NO)' from BIND PACKAGE(ADBL)
  MEMBER(ADBCRCP).
  
  2.  A residual value that was not properly cleared out during
  the DISCOVER process inadvertently populates the TCz input
  field setting for 'DB2 Table Editor CLIST' to all subsystem
  ids listed.
  
  3.  The TCz input field 'SYSAFF for DB2 utilities' on panels
  CCQPPRD 'Product Parameters' and CCQPDB2 'DB2 Parameters'
  allows 8 bytes instead of 4 which will produce the following
  'invalid value' error after completion of the General
  Customization job ADBCUST:
  
  subsys keyword  default  invalid value
  ---------------------------------------------------
    *    JSYSAFF           STL01
  <--- STL01 is a site-specific invalid value
  that exceeds 4 bytes.
  ----------------------------------------------------
  
  4.  When two input fields 'JOB class for DB2 utilities' and
  'SYSAFF for DB2 utilities' are blank on panels CCQPPRD 'Product
  Parameters' and CCQPDB2 'DB2 Parameters', the General
  Customization job for template ADBCUST will complete with the
  following error:
  
  Unrecognized keywords:
  subsys  keyword  invalid value
  --------------------------------------
    *     JSYSAFF
    DSNA  JCLASS
    DSNA  JSYSAFF
  --------------------------------------
  
  5.  When the DB2 Cloning Tool option is enabled on panels
  CCQPPRD 'Product Parameters' and CCQPDB2 'DB2 Parameters',
  the DB2 Administration Tool does not enable the DB2 Cloning
  Tool line command option 'CT - Migrate this table using the
  DB2 Cloning Tool' on panel ADB21T 'Tables, Views, and Aliases'.
  The same problem occurs with the DB2 Table Editor option.
  

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:

  UK92582

Modules/Macros

•    ADB$$DSC ADB$$PRM ADBBIND  ADBCUST  ADBEDIAG
  ADBHDIAG ADBPDIAG ADBR     ADB2CUST ADB2PARM
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK92582

     UP13/03/19 P F303

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.