PH32569: INDEX REORG JCL DOES NOT CONTAIN '//DSNUPROC.SYSIN DD *' STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When using line command 'u.o' to reorg an index, the
  '//dsnuproc.sysin dd *' statement is not generated in the JCL.
  
  The missing statement is inserted internally when the JCL is
  processed, so the job does not fail, but the statement should
  still be generated to appear before the reorg control cards.
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Administration Tool             *
  *                 for z/OS who are using Indexes panel         *
  *                 ADB21X to generate JCL to run the            *
  *                 REORG INDEX utility.                         *
  *                                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION: Line command 'u.o' from the Indexes     *
  *                      panel generates JCL to run REORG INDEX. *
  *                      The generated JCL is missing the        *
  *                      following statement before the REORG    *
  *                      INDEX utility                           *
  *                      statement:                              *
  *                      //DSNUPROC.SYSIN DD *                   *
  *                                                              *
  *                      For example:                            *
  *                                                              *
  *                      //DSNUPROC.SORTOUT DD DSN=USER.SORTOUT, *
  *                      // DISP=(MOD,DELETE,CATLG),             *
  *                      // SPACE=(TRK,(30,30),RLSE),            *
  *                      // UNIT=SYSDA                           *
  *                      REORG INDEX                             *
  *                      "SYSIBM"."DSNADX01"                     *
  *                      UNLOAD CONTINUE                         *
  *                                                              *
  *                      It should be                            *
  *                      //DSNUPROC.SORTOUT DD DSN=USER.SORTOUT, *
  *                      // DISP=(MOD,DELETE,CATLG),             *
  *                      // SPACE=(TRK,(30,30),RLSE),            *
  *                      // UNIT=SYSDA                           *
  *                      //DSNUPROC.SYSIN DD *                   *
  *                      REORG INDEX                             *
  *                      "SYSIBM"."DSNADX01"                     *
  *                      UNLOAD CONTINUE                         *
  ****************************************************************
  JCL generated by the 'u.o' line command is missing
  the //DSNUPROC.SYSIN DD * statement.
  

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:

  UI74738

Modules/Macros

• ADB2UXO
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RC10 PSY UI74738

     UP21/04/06 I 1000

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.