PH25220: DB2 ADMIN TOOL CHANGE MANAGEMENT - ADB5036E A TRAILING PAREN HAS BEEN OMITTED OR NO VALUE WAS PROVIDED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Admin Tool Change Management - ADB5036E A trailing paren has
  been omitted or no value was provided.
  
  The error can occur when the following is true.
  
   #  CM batch
  
  
   # Using chgtag_type parameter of not ?ID? ( which is the
  default)  or using worklist_name parameter
  
  
   # Change tag or worklist name has to be 6 characters long.
  

Local fix

• # Use chgtag_type = ?ID? for any changes with change tag of
  6 characters
  
  # Use change tags that are not 6 characters long
  
  # Use panels to run changes that have 6 character names.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for         *
  *                 z/OS or Object Comparison Tool for z/OS      *
  *                 that use CM batch.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: A Db2 Admin Tool Change Management      *
  *                      Batch job fails in the Run phase of     *
  *                      ALTER TABLE. Error Messages:            *
  *                      ADB5036E A trailing paren has been      *
  *                      omitted or no value was provided.       *
  *                      ADB5185E The run is ending due to       *
  *                      errors. The error happens only with     *
  *                      CM batch and using CHGTAG_TYPE =        *
  *                      'NAME' and a CHANGE_NAME value of       *
  *                      6 characters or using a WORKLIST_NAME   *
  *                      value of 6 characters.                  *
  ****************************************************************
  CM Batch fails with error message ADB5036E when running
  the Run phase of the job. The failure is caused by the following
  conditions:
  
  1. Using the chgtag_type parameter and setting it to a value
  that is not 'ID' (ID is the default value) or using the
  worklist_name parameter.
  2. The change tag or worklist name is 6 characters long.
  

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:

  UI69676

Modules/Macros

• ADB2UTCO ADB2W1   ADBCCM   ADBGAJOB ADBTEP2  ADBTTP   ADBTUNL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI69676

     UP20/05/28 P F005 {

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.