PH59223: KEYWORD UNIT IS DUPLICATED IN UTILITY TEMPLATE WHEN CHANGE IS RUN USING CM BATCH

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Customer is using CM batch JCL to run a change. When the
  customer specified user defined templates in the JCL and when
  the CM batch JCL was run, it failed due to an error in a
  template that was defined with duplicate UNIT keyword. The
  customer's user defined template list did not have any duplicate
  UNIT keywords.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using Change Management (CM) batch *
  *                      to run a change, it fails due to an     *
  *                      error with a template. The error        *
  *                      reports that the template was defined   *
  *                      with a duplicate UNIT keyword.          *
  *                      After the template definitions are      *
  *                      fixed, the LOAD utility cannot load     *
  *                      the changed table due to invalid input  *
  *                      data that was converted during the CM   *
  *                      batch job.                              *
  ****************************************************************
  The user is using CM batch to run a change with templates,
  and two of those template definitions use the same template
  name. This repeated name causes duplication in the template
  definition, and the job fails with the following utility
  message:
        DSNU094I  DSNUGPTC - KEYWORD 'UNIT' IS DUPLICATED
  
  After this problem is fixed, the CM batch job runs the LOAD
  utility. However, the data is not loaded into the table,
  because the DATE column data is not converted correctly to
  TIMESTAMP column data as called for by the change.  This problem
  occurs only with ASCII data.  The following message is included
  in the output:
        DSNU310I  DSNURCON - RECORD (1) WILL BE DISCARDED DUE TO
                 CONVERSION ERROR FOR TSSCHEMA.TB1
                 ERROR CODE '14 - INPUT IS INVALID FOR DATE/TIME'
  

Problem conclusion

• The problems have been addressed.
  

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:

  UI96232 UI96233

Modules/Macros

• ADB25TL1 ADB27AC
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI96232

     UP24/03/27 P F403

• RD10 PSY UI96233

     UP24/03/27 P F403

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.