A fix is available
APAR status
Closed as program error.
Error description
Support cloned tables for: OC, RENDB, MIG RDEF TS GEN CM Register Alter Table
Local fix
New function
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Administration Tool * * Version 7.2 for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: Changes to objects involved in a * * clone relationship in DB2 * * Version 9 were previously * * restricted or had limited * * capability. * * * * This APAR adds the following * * capabilities in support of * * DB2 Version 9 Clone Tables: * * * * - Allow changes to base table by * * recreating clone. * * - Allow changes to table space * * for base table with clone * * relationship. * * - Allow rename on data base * * containing base table with * * clone. * * - Allow migrate of objects * * involved with clone tables. * * - Update Utility Template * * panel with CLONE option. * * - Update dialog panels where * * CLONE option applies. * * - GEN and DDL support on a * * CLONE table. * * - Allow Change Mangement to * * register ALTER TABLE...ADD * * CLONE statement. * * * * Note: * * * * This maintenance includes the * * ability to perform utilities against * * objects with clones and on clone * * objects directly. New default * * data sets are needed for use by * * utilities when operating against * * a clone table. The default data * * sets have been added to SAMP * * ADB2UCU1. This sample must * * be added to the existing * * ADB2UCUS member in the * * ISPF skeleton data set * * (ISPSLIB). Installations may * * wish to modify the provided * * default data set names * * provided in the sample. * * * * Installations which have used * * the default member and have not * * maintained their own copy of * * ADB2UCUS must modify * * ADB2UCUS to establish the * * default template data set names. * * * * While running Image copy * * without modifying this member * * an error may occur: * * * * DSNU005I DSNUGPRS - * * TEMPLATE SYSCOPY DSN * * UNIT SYSDA * * * * While running CHECK DATA * * without modifying this member * * an error may occur: * * * * DSNU005I DSNUGPRS - * * TEMPLATE CTLUT1 DSN * * DSNU005I DSNUGPRS - * * TEMPLATE SYSCOPY DSN * * UNIT SYSDA * * * * While running CHECK DATA * * without modifying this member * * an error may occur: * * * * DSNU005I DSNUGPRS - * * TEMPLATE CTLUT1 DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE CSRTOUT DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE CTLERR DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE CTLPUNCH DSN * * UNIT SYSDA * * * * While running REORG without * * modifying this member an * * error may occur: * * * * DSNU005I DSNUGPRS - * * TEMPLATE CSYSCOPY DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE CTLPUNCH DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE CTLREC DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE CTLUT1 DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE CSRTOUT DSN * * UNIT SYSDA * * * * While running UNLOAD without * * modifying this member an * * error may occur: * * * * DSNU005I DSNUGPRS - * * TEMPLATE CTLPUNCH DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE CTLREC DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE ADBL1 DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE ADBX1 DSN * * UNIT SYSDA * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE CSRTOUT DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE CTLERR DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE CTLPUNCH DSN * * UNIT SYSDA * * * * While running REORG without * * modifying this member an * * error may occur: * * * * DSNU005I DSNUGPRS - * * TEMPLATE CSYSCOPY DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE CTLPUNCH DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE CTLREC DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE CTLUT1 DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE CSRTOUT DSN * * UNIT SYSDA * * * * While running UNLOAD without * * modifying this member an * * error may occur: * * * * DSNU005I DSNUGPRS - * * TEMPLATE CTLPUNCH DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE CTLREC DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE ADBL1 DSN * * UNIT SYSDA * * * * DSNU005I DSNUGPRS - * * TEMPLATE ADBX1 DSN * * UNIT SYSDA * **************************************************************** * RECOMMENDATION: Apply The PTF. * **************************************************************** Changes to objects involved in a clone relationship in DB2 Version 9 were previously restricted or had limited capability. This APAR adds the following capabilities in support of DB2 Version 9 Clone Tables: - Allow changes to base table by recreating clone. - Allow changes to table space for base table with clone relationship. - Allow rename on data base containing base table with clone. - Allow migrate of objects involved with clone tables. - Update Utility Template panel with CLONE option. - Update dialog panels where CLONE option applies. - GEN and DDL support on a CLONE table. - Allow Change Mangement to register ALTER TABLE...ADD CLONE statement. Note: This maintenance includes the ability to perform utilities against objects with clones and on clone objects directly. New default data sets are needed for use by utilities when operating against a clone table. The default data sets have been added to SAMP ADB2UCU1. This sample must be added to the existing ADB2UCUS member in the ISPF skeleton data set (ISPSLIB). Installations may wish to modify the provided default data set names provided in the sample. Installations which have used the default member and have not maintained their own copy of ADB2UCUS must modify ADB2UCUS to establish the default template data set names. While running Image copy without modifying this member an error may occur: DSNU005I DSNUGPRS - TEMPLATE SYSCOPY DSN UNIT SYSDA While running CHECK DATA without modifying this member an error may occur: DSNU005I DSNUGPRS - TEMPLATE CTLUT1 DSN UNIT SYSDA DSNU005I DSNUGPRS - TEMPLATE CSRTOUT DSN UNIT SYSDA DSNU005I DSNUGPRS - TEMPLATE CTLERR DSN UNIT SYSDA DSNU005I DSNUGPRS - TEMPLATE CTLPUNCH DSN UNIT SYSDA While running REORG without modifying this member an error may occur: DSNU005I DSNUGPRS - TEMPLATE CSYSCOPY DSN UNIT SYSDA DSNU005I DSNUGPRS - TEMPLATE CTLPUNCH DSN UNIT SYSDA DSNU005I DSNUGPRS - TEMPLATE CTLREC DSN UNIT SYSDA DSNU005I DSNUGPRS - TEMPLATE CTLUT1 DSN UNIT SYSDA DSNU005I DSNUGPRS - TEMPLATE CSRTOUT DSN UNIT SYSDA While running UNLOAD without modifying this member an error may occur: DSNU005I DSNUGPRS - TEMPLATE CTLPUNCH DSN UNIT SYSDA DSNU005I DSNUGPRS - TEMPLATE CTLREC DSN UNIT SYSDA DSNU005I DSNUGPRS - TEMPLATE ADBL1 DSN UNIT SYSDA DSNU005I DSNUGPRS - TEMPLATE ADBX1 DSN UNIT SYSDA
Problem conclusion
The enhancements have been provided.
Temporary fix
Comments
ž**** PE10/06/15 PTF IN ERROR. SEE APAR PM09403 FOR DESCRIPTION
APAR Information
APAR number
PK84529
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
720
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-04-10
Closed date
2010-02-26
Last modified date
2010-06-15
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK54756
Modules/Macros
ADBCCMM ADBCRCM ADBCRCR ADBCVOB ADBHAH ADBHUSN ADBHUSU ADBHUXN ADBHW1R ADBH1DAJ ADBH1K ADBH1TCA ADBH5TU ADBH5TUA ADBH5TUB ADBH5TUC ADBH5TUD ADBH5TUE ADBH5TU0 ADBH5TU1 ADBH7A ADBJCLIP ADBP9000 ADBTEPU ADBTEP2 ADBTTP ADB2AT ADB2CHK ADB2CR0 ADB2E1 ADB2E2 ADB2PA ADB2PA5 ADB2PA6 ADB2PA7 ADB2PROC ADB2RE ADB2REE ADB2REG ADB2REH ADB2REM ADB2REP ADB2RER ADB2RES ADB2RET ADB2REU ADB2REY ADB2REZ ADB2U ADB2UCU1 ADB2UOPS ADB2USAG ADB2USC ADB2USCO ADB2USE ADB2USK ADB2USKL ADB2USKO ADB2USM ADB2USN ADB2USO ADB2USOO ADB2USOP ADB2USQ ADB2USU ADB2USV ADB2US2 ADB2UTH1 ADB2UTLX ADB2UTUL ADB2UTUX ADB2UUOP ADB2UX ADB2UXB ADB2UXK ADB2UXKO ADB2UXN ADB2UXO ADB2WL4 ADB2W1 ADB2W1R ADB2XCG0 ADB21A ADB21C ADB21D ADB21DAJ ADB21F ADB21K ADB21S ADB21SA ADB21SAJ ADB21SAL ADB21SAR ADB21SA0 ADB21SS ADB21SSI ADB21T ADB21TA ADB21TCA ADB21XAR ADB25T ADB25TC ADB25TD ADB25TE ADB25TL1 ADB25TL2 ADB25TS ADB25TT ADB25TU ADB25TU3 ADB25TU4 ADB26DR ADB27A ADB27AC ADB27AD ADB27C ADB27CA ADB27CAA ADB27CTC ADB27CX ADB27C0 ADB27DUP ADB27TUL ADB278C1 ADB28ADD ADB28ASD ADB28ATD ADB28LT ADB28M ADB28MC ADB28MCT ADB28M2 ADB28RL1 ADB28S ADB28T ADB28UL1 ADB28USK ADB28UT ADB33 ADB35 ADB55
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
R720 PSY UK54756
UP10/03/04 P F003
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":"720","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 June 2010