PQ62571: JCL ERRORS CAN OCCUR IN VARIOUS UTILITY JOBS WHEN MORE THAN 99 JOBSTEPS CAUSE GENERATED STEPNAME TO EXCEED 8 CHARACTERS.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• JCL errors can occur in various utility jobs when more than 99
  jobsteps cause generated stepname to exceed 8 characters.
  .
  The following JCL skeletons illustrate reported problems:
    Member: ADB2UTU
      //DELETE&UNLSN   EXEC PGM=IEFBR14
      //UNLOAD&UNLSN  EXEC PGM=IKJEFT01,DYNAMNBR=100
    Member: ADB2UTUL
      //DELETE&UNLSN  EXEC PGM=IEFBR14
      //UNLOAD&UNLSN EXEC DSNUPROC,SYSTEM=&DB2SYS,
    Member: ADB2USU1
      //DELETE&V     EXEC PGM=IEFBR14
      //UNLD&V EXEC DSNUPROC,SYSTEM=&DB2SYS,
  .
  The last line, above, will NOT generate an invalid stepname.  It
  is included to illustrate how these user-modified JCL skeleton
  files can be changed to avoid a generated stepname that exceeds
  8 characters when more than 99 jobsteps are generated by the DB2
  Admin Tool.
  

Local fix

• Edit / Modify JCL skeletons as needed.  Use the following
  example, as noted in the apar description:
      //UNLD&V EXEC DSNUPROC,SYSTEM=&DB2SYS,
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 ADMIN TOOL who generate more    *
  *                 than 99 jobsteps in various utility jobs are *
  *                 affected                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: JCL errors occur in various utility     *
  *                      jobs when more than 99 jobsteps         *
  *                      cause generated stepname to exceed 8    *
  *                      characters.                             *
  ****************************************************************
  * RECOMMENDATION: INSTALL CORRECTIVE SERVICE FOR APAR/PTF      *
  ****************************************************************
  The errors occur in various utility jobs when more than 99
  jobsteps cause generated stepname to exceed 8 characters.
  Members ADB2UTU, ADB2UTUL and ADB2USU1 in the skeleton library
  are reported to show this problem.
  

Problem conclusion

• The problem of generated stepnames being too long when more than
  99 jobsteps have been exceeded is currently fixed in skeleton
  members ADB2UTU, ADB2UTUL and ADB2USU1 by eliminating one
  character from the constant part of the stepname to allow one
  more digit. The new limit for the digit part of the stepname is
  999.
  

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:

  UQ71054 UQ71055

Modules/Macros

•    ADB2USU1 ADB2UTU  ADB2UTUL
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• R310 PSY UQ71054

     UP02/10/23 P F210

• R410 PSY UQ71055

     UP02/10/23 P F210

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.