A fix is available
APAR status
Closed as program error.
Error description
DB2 Object Compare Tool for z/OS does not always use TEMPLATE definitions from ADB25TU3 even though ADBH5TU says: "SPECIFY WHICH TEMPLATE WILL BE USED" . Problem persists even after apar pm25830 / ptf uk69177 is applied to ra10 level of Object Compare Tool. Problem can lead to duplicate dataset names generated in jobstream.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: This APAR enables, consolidates and * * cleans up template options and usage * * across the change functions. Note * * that generally speaking this * * functionality is only being * * implemented for the change flows (i.e. * * ALT, Compare and Change Management * * (CM), but not CM Batch). The summary * * of changes are as follows: * * * * - Eliminate the Object Compare, * * Redefine Table Space (RDEF) and * * Restore (RES) template types on * * panel ADB25TU3 'Specify UTILITY * * TEMPLATE Usage'. * * * * - Change the ALT template type to * * CHG * * * * - Add three new symbolics for use in * * template DSN names. These new * * symbolics are &PREFIX, &LEVEL and * * &TNAME. Note that these symbolics * * are only valid in the context of * * change flows (i.e. &PREFIX is only * * valid for the change flows ALT, OC * * and CM). If a particular symbolic * * is not relevant, it will resolve * * as a literal (e.g. &PREFIX will * * resolve PREFIX). These symbolics * * will resolve to the following * * values when used in the change * * flows: * * * * &PREFIX will resolve to the data * * set prefix entered * * &LEVEL will resolve to the * * worklist name (or middle * * qualifier) * * &TNAME will resolve to our * * internally generated table * * numbering system (e.g. T0001) * * * * - Enable subscripting fully in * * template DSN names (e.g. * * &TS(3,3) will produce a value * * starting in the 3rd position * * for a length of 3 bytes). Note * * that you can use subscripting * * even on the new symbolics. * * * * - Propagate template metrics (i.e. * * space, DSN and all user-specified * * options) to the DD or template as * * applicable. Note that DISP and * * MODELDCB are not propagated as * * we need to maintain control of * * these options. * * * * - Template options will be put onto * * both DD and/or template statements * * as applicable. * * * * For full documentation refer to * * Chapter 11 of the DB2 Administration * * Tool User's Guide and Reference. * * * * Note that if you encounter problems * * with the new template functionality * * you can turn off this function by * * indicating 'Generate Templates NO'. * * This will turn off this functionality * * and revert to normal product generated * * and ADB2UCUS names. * **************************************************************** * RECOMMENDATION: * **************************************************************** This APAR enables, consolidates and cleans up template options and usage across the change functions. Note that generally speaking this functionality is only being implemented for the change flows (i.e. ALT, Compare and Change Management (CM), but not CM Batch). The summary of changes are as follows: - Eliminate the Object Compare, Redefine Table Space (RDEF) and Restore (RES) template types on panel ADB25TU3 'Specify UTILITY TEMPLATE Usage'. - Change the ALT template type to CHG - Add three new symbolics for use in template DSN names. These new symbolics are &PREFIX, &LEVEL and &TNAME. Note that these symbolics are only valid in the context of change flows (i.e. &PREFIX is only valid for the change flows ALT, OC and CM). If a particular symbolic is not relevant, it will resolve as a literal (e.g. &PREFIX will resolve PREFIX). These symbolics will resolve to the following values when used in the change flows: &PREFIX will resolve to the data set prefix entered &LEVEL will resolve to the worklist name (or middle qualifier) &TNAME will resolve to our internally generated table numbering system (e.g. T0001) - Enable subscripting fully in template DSN names (e.g. &TS(3,3) will produce a value starting in the 3rd position for a length of 3 bytes). Note that you can use subscripting even on the new symbolics. - Propagate template metrics (i.e. space, DSN and all user-specified options) to the DD or template as applicable. Note that DISP and MODELDCB are not propagated as we need to maintain control of these options. - Template options will be put onto both DD and/or template statements as applicable. For full documentation refer to Chapter 11 of the DB2 Administration Tool User's Guide and Reference. Note that if you encounter problems with the new template functionality you can turn off this function by indicating 'Generate Templates NO'. This will turn off this functionality and revert to normal product generated and ADB2UCUS names.
Problem conclusion
The new functionality has been implemented.
Temporary fix
Comments
APAR Information
APAR number
PM51774
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2011-11-07
Closed date
2012-07-15
Last modified date
2012-08-09
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK80305
Modules/Macros
ADBEALT ADBEDDL ADBGAJOB ADBHALTD ADBH5TD ADBH5TU ADBH5TUA ADBH5TUE ADBH5TU1 ADBPALTD ADBSALT ADBS27AC ADBTCHK ADBTHPU ADBTIMC ADBTREL ADBTREO ADBTRUN ADBTUNL ADB2DSN ADB2DSN2 ADB2PTPL ADB2USOP ADB2W1 ADB25T ADB25TD ADB25TE ADB25TL1 ADB25TL3 ADB25TT ADB25TU ADB25TU3 ADB25TU4 ADB27AC ADB28JCL ADB28M ADB28TPL ADB28UL1 ADB28USK
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA10 PSY UK80305
UP12/07/18 P F207
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
09 August 2012