PM77906: ALT CHECK DATA STEP DSNU047I DSNUKDIN - A REQUIRED DD CARD OR TEMPLATE IS MISSING. NAME=UTLOUT RC8

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DB2 Administration Tool for z/OS ALT function created JCL
  which failed in a CHECK DATA step with a message:
  .
  DSNU047I    nnn nn:nn:nn.nn DSNUKDIN - A REQUIRED DD CARD OR
  TEMPLATE IS MISSING. NAME=UTLOUT
  

Local fix

• Manually define templates for WORKDDN 1 and WORKDDN 2
  keywords on panel ADB25TU3 'Specify UTILITY TEMPLATE
  Usage' and set 'Generate templates' to 'YES'.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the 'Alter Table ALT' (ALT)     *
  *                 function and run the CHECK DATA utility.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DB2 Administration Tool for z/OS    *
  *                      ALT function created a Work Statement   *
  *                      List (WSL) or APPLY JCL which fails     *
  *                      on the CHECK DATA utility statement     *
  *                      with a return code 8 / RC8 and          *
  *                      message:                                *
  *                                                              *
  *                      'DSNU047I                               *
  *                      nnn nn:nn:nn.nn DSNUKDIN - A            *
  *                      REQUIRED DD CARD OR TEMPLATE IS         *
  *                      MISSING.                                *
  *                      NAME=UTLOUT'                            *
  *                                                              *
  *                      if the user only defined template       *
  *                      for WORKDDN1 and set 'Generate          *
  *                      templates' to 'YES'.                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  If the user only defined template for WORKDDN1 and set
  'Generate templates' to 'YES' to run CHECK DATA during
  the ALT process, the CHECK DATA utility failed with a
  return code 8 / RC8 and message:
  
  'DSNU047I nnn nn:nn:nn.nn
  DSNUKDIN - A REQUIRED DD CARD OR TEMPLATE IS
  MISSING. NAME=UTLOUT'
  
  since the template SORTOUT is finally generated but UTLOUT is
  specified for WORKDDN2.
  

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:

  UK91414 UK91415

Modules/Macros

•    ADBTCHK
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK91414

     UP13/02/08 P F302

• RA20 PSY UK91415

     UP13/02/08 P F302

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.