PM79441: THE AMPERSAND IN "&CMOWN" OF THE ADBBIND NEEDS TO BE REMOVED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Ampersand (&) removed from DENU(ADBBIND) to address TCz
  Template Error - CCQC024S.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool and     *
  *                 IBM Tools Customizer (TCz) for z/OS.         *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following incidents have been       *
  *                      fixed:                                  *
  *                                                              *
  *                      1 - Text '&CMOWN' has been removed      *
  *                      from the prolog of SADBDENU(ADBBIND)    *
  *                      to address the following TCz            *
  *                      incident:                               *
  *                                                              *
  *                      Template Error - CCQC024S               *
  *                      ISPF file tailoring failed for          *
  *                      'ADBBIND' template in the               *
  *                      'SADBDENU' metadata library.            *
  *                                                              *
  *                      2 - Specifying a STOGROUP for           *
  *                      'Change Management database             *
  *                      task' did not get used by job           *
  *                      template ADBMCMA 'Upgrade the           *
  *                      Change Management tables'.              *
  *                                                              *
  *                      3 - Specifying an alternate input       *
  *                      value for step 'Change Management       *
  *                      objects owner' did not get used by      *
  *                      job template ADBMCMA 'Upgrade           *
  *                      the Change Management tables'           *
  *                      and job template ADBCDCH 'Allow         *
  *                      change deletion'.                       *
  *                                                              *
  *                      4 - Submission of job template          *
  *                      ADBCHANG 'Create Change                 *
  *                      Management database' receives           *
  *                      the following SQLCODE=-204 /            *
  *                      SQLCODEN204 error on the DROP           *
  *                      statement:                              *
  *                                                              *
  *                      DSNT408I SQLCODE = -204,                *
  *                      ERROR: ADBDCHG  IS AN                   *
  *                      UNDEFINED NAME                          *
  *                      DSNT418I SQLSTATE   = 42704             *
  *                      SQLSTATE RETURN CODE                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The following incidents have been fixed:
  
  1 - Text '&CMOWN' has been removed from the prolog of
  SADBDENU(ADBBIND) to address the following TCz incident:
  
  Template Error - CCQC024S ISPF file tailoring failed for
  'ADBBIND' template in the 'SADBDENU' metadata library.
  
  2 - Specifying a STOGROUP for 'Change Management database
  task' did not get used by job template ADBMCMA 'Upgrade the
  Change Management tables'.
  
  3 - Specifying an alternate input value for step 'Change
  Management objects owner' did not get used by job template
  ADBMCMA 'Upgrade the Change Management tables' and job
  template ADBCDCH 'Allow change deletion'.
  
  4 - Submission of job template ADBCHANG 'Create Change
  Management database' receives the following SQLCODE=-204 /
  SQLCODEN204 error on the DROP statement:
  
  DSNT408I SQLCODE = -204, ERROR: ADBDCHG  IS AN
  UNDEFINED NAME
  DSNT418I SQLSTATE   = 42704 SQLSTATE RETURN CODE
  

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

•    ADBBIND  ADBCDCH  ADBCHANG ADBGC    ADBGC10
  ADBMCMA
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA20 PSY UK90583

     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.