A fix is available
APAR status
Closed as program error.
Error description
The DB2 Administration Tool for z/OS ALC functions CNVRT50 step fails with a dataset not found message as the TEMPLATE used for the ALTDDL dataset does not resolve to the same dataset name specified in the earlier steps as the name contains DATE and TIME variables e.g.: e.g ALDDL.D&DT..W1&TI.
Local fix
Do not use DATE and TIME in TEMPLATE name
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool * * for z/OS who use the variable &TIME * * to construct the data set name pattern * * for the ALDDL template when * * performing an ALC command on a * * table. * **************************************************************** * PROBLEM DESCRIPTION: The DB2 Administration Tool for * * z/OS ALC function fails with a * * data set not found message when * * the TEMPLATE used for the * * ALTDDL data set does not resolve * * to the same data set name * * specified in the earlier steps if the * * name contains the DATE and TIME * * variables. * **************************************************************** * RECOMMENDATION: Apply The PTF. * **************************************************************** When using the ALDDL template variable &TIME to construct the data set, the ALTDDL data set does not resolve to the same data set name specified in the earlier steps if the name contains the DATE and TIME variables.
Problem conclusion
The programs were modified to keep the same data set name.
Temporary fix
Comments
APAR Information
APAR number
PM22612
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
720
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2010-09-15
Closed date
2010-12-07
Last modified date
2011-02-06
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK62880
Modules/Macros
ADB2PTPL ADB27A
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
R720 PSY UK62880
UP10/12/10 P F012
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":"720"}]
Document Information
Modified date:
30 March 2021