A fix is available
APAR status
Closed as program error.
Error description
To be advised, working title "Utilities - Support remaining new and change utility options" DSNU049I DSNUGPRS - INVALID OPERAND 'LIMIT' FOR KEYWORD 'SHRLEVEL' DSNU012I DSNUGBAC - UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8
Local fix
New function
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Administration Tool for z/OS * * and DB2 V9. Users that would like to use * * DEFER YES to create indexes but do not wish * * to supply a mask. * **************************************************************** * PROBLEM DESCRIPTION: This APAR describes a number of issues: * * * * 1) The online function did not support * * (CURRENT) SCHEMA. * * * * 2) Users were forced to provide a mask * * to utilize the DEFER overwrite. * * * * 3) Users find it difficult to switch * * to another SSID. Today they have * * to exit Admin, start the launch pad * * and select the subsystem they want * * to go to. * * * * 4) The customization steps for Admin * * require that ADB2ATH and ADB2UTIL * * in SADBLINK be copied to an * * authorized library in the link list. * * This is a problem in some * * installations. * * * * 5) If the SYSCOLUMNS.PARTKEY_COLSEQ * * field was not specified explicitly * * in the IGNORE file along with * * generic field PARTITION, * * * * SYSINDEXPART PARTITION * * SYSTABLEPART PARTITION * * SYSTABLESPACE PARTITIONS * * * * the column names in the PARTITION * * BY clause within the CREATE TABLE * * statement were generated * * incorrectly. * * 6) Additional support to the product's * * Utilities to support utility * * options. * * * * The following Utility options were * * added: * * * * Check data utility: * * -FOR EXCEPTION IN,USE * * -DELETE * * -DRAIN WAIT * * -RETRY * * * * Copy utility: * * -PARALLEL * * -SYSTEMPAGES * * * * Modify recovery utility: * * -CLONE * * -RETAIN * * * * Repair utility: * * -Reset AUXILARY-warning status * * -Reset AUXILARY-CHECK-pending status * * -Reset Advisory REORG-pending status * * * * Runstats utility: * * -NUMQUANTILES * * * * Recover utility: * * -TAPEUNITS * * -LOGRANGES * * * * Unload utility: * * -SKIP LOCKED DATA * * -DECFLOAT ROUNDING * * * * Load utility: * * -DECFLOAT ROUNDING * * * * Repair Index utility: * * -Repair Reset REORG Advisory * * pending status * * * * Runstats Index utility: * * -NUMCOLS * * -NUMQUANTILES * * * * Recover Index: * * -TOVOLUME, TOSEQNO * * -LOGRANGES * * -CLONE * * -RESTOREBEFORE * * -FROMDUMP * **************************************************************** * RECOMMENDATION: Apply The PTF. * **************************************************************** 1) There is no support for CURRENT SCHEMA in Admin 7.2. 2) Allow users to provide a generic DEFER overwrite without having to provide a mask file designation. 3) The primary command "SSID <subsystem>" has been added. This command will exit the current Admin session and attempt to restart a new session connected to the provided subsystem. 4) An alternate customization method may be used. Steps in the User's Guide have been updated to describe the new installation process. 5) The IGNORE function did not work. 6) Additional support to the product's Utilities to support utility options has been added.
Problem conclusion
1) Support for SCHEMA has been added. The SCHEMA will now be shown on the main panel (ADB2) and a new SCHEMA command can be used to change the DB2 SCHEMA special register. 2) A panel field has been added that will allow the user to choose to build applicable indexes with DEFER YES without requiring the user to provide a mask file. 3) A new primary command is also available. The requirement to have certain modules in the LINKLIST has been lifted. 5) The problem has been corrected. 6) New function/support for Utility options have been added.
Temporary fix
Comments
ž**** PE09/12/08 PTF IN ERROR. SEE APAR PK84527 FOR DESCRIPTION
APAR Information
APAR number
PK84534
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
2009-11-16
Last modified date
2009-12-18
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK52000
Modules/Macros
ADB ADBBIND ADBCDTS ADBCHANG ADBCHAN7 ADBCHU09 ADBCRCA ADBCX ADBC09 ADBHCUS9 ADBHC11A ADBHUSC ADBHUSK ADBHUSM ADBHUSN ADBHUSO ADBHUSR ADBHUSU ADBHUSV ADBHUTC ADBHUXN ADBHUXR ADBHUXV ADBH014 ADBH5TD ADBH7A ADBJCLIP ADBL ADBMAIN ADBR ADBRPGM ADBRTAB ADBTEP2 ADBV99 ADB2 ADB2ATH ADB2C ADB2CEX1 ADB2CJAB ADB2CJDB ADB2CUST ADB2C11A ADB2C4O ADB2DID ADB2DIP ADB2DSNR ADB2GEN ADB2GEN2 ADB2GET ADB2INC ADB2INCV ADB2LINE ADB2M ADB2MSK ADB2PARM ADB2PSQL ADB2REG ADB2RIP ADB2STAT ADB2TEP ADB2U ADB2UOPS ADB2US ADB2USC ADB2USCO ADB2USK ADB2USKO ADB2USM ADB2USN ADB2USO ADB2USOP ADB2USR ADB2USRO ADB2USU ADB2USV ADB2USVO ADB2UTC ADB2UTCO ADB2UTIL ADB2UTLV ADB2UUOP ADB2UX ADB2UXN ADB2UXO ADB2UXO1 ADB2UXO2 ADB2UXR ADB2UXV ADB2UXVO ADB2WL ADB2WL4 ADB2WVL ADB2W1 ADB2W1Q ADB21K ADB21S ADB21SAD ADB21SAR ADB21SAY ADB21TR ADB223 ADB23 ADB231X ADB2311X ADB2312 ADB2312X ADB2314 ADB2314I ADB2314T ADB2314X ADB233 ADB236 ADB237 ADB238 ADB239 ADB25TD ADB26CA ADB26CE ADB26CF ADB26CJ ADB26CL ADB26CNA ADB26CO ADB26CQ ADB26CT ADB26CV ADB26CX ADB26CY ADB27A ADB27AC ADB27ACM ADB27AD ADB27C ADB27CA ADB27CU ADB27CV ADB27C0 ADB27DC1 ADB27DUP ADB27M ADB27PC ADB27RPP ADB27SPC ADB27SQ1 ADB28CR ADB28HPU ADB28UL1 ADB28USK ADB28UT ADB71 ADB72 ADB9000 H0IH720J
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
R720 PSY UK52000
UP09/11/21 P F911
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:
18 December 2009