PM90883: DB2 ADMINISTRATION TOOL FOR Z/OS DOES NOT USE THE SAME DATASET NAME IN THE LOAD STEP AS IT GENERATED IN UNLOAD JCL DURING ALTER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DB2 Administration Tool for z/OS does not use the same dataset
  name
  in the LOAD step as it generated in UNLOAD JCL during ALTER
  TABLE
  

Local fix

• Manual correction of the generated JCL
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool         *
  *                 for z/OS who use the 'ALT Alter Table'       *
  *                 (ALT) function to alter a table.             *
  ****************************************************************
  * PROBLEM DESCRIPTION: When altering a table and using a       *
  *                      template with the data set name that    *
  *                      has Symbolic Variable TIME, the data    *
  *                      set in the LOAD Step is different from  *
  *                      the data set in the UNLOAD step. The    *
  *                      SYSPUNCH data set in the LOAD step is   *
  *                      different from the data set in other    *
  *                      steps. The generated job ends with a    *
  *                      JCL ERROR at the LOAD step LOAD001:     *
  *                                                              *
  *                      IEF212I CIDB2FMD DSNUPROC LOAD0001      *
  *                      SYSREC - DATA SET NOT FOUND             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When altering a table and using a template with the data set
  name that has Symbolic Variable TIME, the data set in the
  LOAD Step is different from the data set in the UNLOAD step.
  The SYSPUNCH data set in the LOAD step is different from the
  data set in other steps. The generated job ends with a JCL
  ERROR at the LOAD step LOAD001:
  
  IEF212I CIDB2FMD DSNUPROC LOAD0001
  SYSREC - DATA SET NOT FOUND
  

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:

  UK97945 UK97946

Modules/Macros

• ADBGAJOB
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK97945

     UP13/09/28 P F309

• RA20 PSY UK97946

     UP13/09/28 P F309

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.