A fix is available
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 number
PM77906
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A20
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-11-27
Closed date
2013-02-05
Last modified date
2013-03-04
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
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.2.0"}]
Document Information
Modified date:
31 March 2021