A fix is available
APAR status
Closed as new function.
Error description
DB2 ADMINISTRATION TOOL FOR Z/OS. Support added to use the DB2 extended optimization feature.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool for * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: The following enhancements are * * delivered: * * * * 1 - Add the capability to copy * * selected rows from one PLAN_TABLE * * table to another PLAN_TABLE. * * * * 2 - Add the ability to create and * * upgrade the DSN_PREDICAT_TABLE, * * DSN_USERQUERY_TABLE and * * DSN_PREDICATE_SELECTIVITY tables * * in the DB2 Administration Tool's * * Explain feature to support DB2 11. * * * * 3 - The 'UT - Upgrade a table to * * current DB2 version' option on panel * * ADB2E 'Explain' will check for and * * add new columns as needed to the * * DSN_USERQUERY_TABLE table. The * * columns potentially added are: * * * * SELECTVTY_OVERRIDE * * ACCESSPATH_HINT * * OPTION_OVERRIDE * * * * 4- Add the ability to view information * * in the SYSIBM.SYSQUERYSEL and the * * SYSIBM.SYSQUERYPREDICATE tables. * * * * 5 - Add the 'I - Interpret' line * * command panel ADB2EQ 'Rows from * * SYSQUERY, SYSQUERYPLAN' to list * * SYSQUERY explain information. * * * * 6 - Add the DB2 BIND QUERY command * * to DB2 Administration Tool's Explain * * feature. * * * * 7 - Add the REORG INDEX utility to * * panel ADB2UOPS 'Change Utilities * * Options' so that the options can be * * set. * * * * 8 - Add support for options, * * BUSINESS_TIME SENSITIVE * * and SYSTEM_TIME SENSITIVE, in * * the 'AL - Alter Function/Procedure' * * and ALT 'Redefine function/procedure' * * dialogs for functions and procedures. * * * * 9 - Add support for creating a stored * * procedure with new array data type. * * * * 10 - The archive accelerator table * * command, 'AR - Archive', is updated * * on panel ADBPZAT 'Display Accelerated * * Tables' to not show any messages if * * the user ends the dialog with a PF3 * * or any other way. * * * * 11 - An enhancement to always use * * the SPANNED YES Unload option during * * Catalog Copy in order to unload * * LOB/XML data. * * * * 12 - Add BUSTIMESENSITIVE and * * SYSTIMESENSITIVE options to panels * * ADB21KB 'Bind Package' and ADB21KR * * 'Rebind Package'. * * * * 13 - Add support for AUTONOMOUS * * keyword in ALT 'Redefine procedure' * * dialog ADBP7O. * * * * The following has been removed: * * * * 1- The IBMREQD field from panels * * ADBPAGVI 'Interpretation of Object * * in SYSVARIABLEAUTH' and ADBP1GVI * * 'Interpretation of an Object in * * SYSVARIABLES'. * **************************************************************** * RECOMMENDATION: * **************************************************************** The following enhancements are delivered: 1 - Add the capability to copy selected rows from one PLAN_TABLE table to another PLAN_TABLE. 2 - Add the ability to create and upgrade the DSN_PREDICAT_TABLE, DSN_USERQUERY_TABLE and DSN_PREDICATE_SELECTIVITY tables to support DB2 11. 3 - The 'UT - Upgrade a table to current DB2 version' option on panel ADB2E 'Explain' will check for and add new columns as needed to the DSN_USERQUERY_TABLE table. The columns potentially added are: SELECTVTY_OVERRIDE ACCESSPATH_HINT OPTION_OVERRIDE 4- Add the ability to view information in the SYSIBM.SYSQUERYSEL and the SYSIBM.SYSQUERYPREDICATE tables. 5 - Add the 'I - Interpret' line command to panel ADB2EQ 'Rows from SYSQUERY, SYSQUERYPLAN' to list SYSQUERY explain information. 6 - Add the DB2 BIND QUERY command to DB2 Administration Tool's Explain feature. 7 - Add the REORG INDEX utility to panel ADB2UOPS 'Change Utilities Options' so that the options can be set. 8 - Add support for options, BUSINESS_TIME SENSITIVE and SYSTEM_TIME SENSITIVE, in the 'AL - Alter Function/Procedure' and ALT 'Redefine function/procedure' dialogs for functions and procedures. 9 - Add support for creating a stored procedure with new array data type. 10 - The archive accelerator table command, 'AR - Archive', is updated on panel ADBPZAT 'Display Accelerated Tables' to not show any messages if the user ends the dialog with a PF3 or any other way. 11 - An enhancement to always use the SPANNED YES Unload option during Catalog Copy in order to unload LOB/XML data. 12 - Add BUSTIMESENSITIVE and SYSTIMESENSITIVE options to panels ADB21KB 'Bind Package' and ADB21KR 'Rebind Package'. 13 - Add support for AUTONOMOUS keyword in ALT 'Redefine procedure' dialog ADBP7O. The following has been removed: 1- The IBMREQD field from panels ADBPAGVI 'Interpretation of Object in SYSVARIABLEAUTH' and ADBP1GVI 'Interpretation of an Object in SYSVARIABLES'.
Problem conclusion
Temporary fix
Comments
Enhancements delivered.
APAR Information
APAR number
PI06612
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
B10
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-11-20
Closed date
2014-02-24
Last modified date
2014-03-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI15413
Modules/Macros
ADBCCMM ADBCDTS ADBD ADBDK ADBEE ADBE00 ADBE1XC1 ADBE7CTP ADBHC911 ADBHD0 ADBHEL ADBHELC ADBHEQ ADBHEQP ADBHEQS ADBH1O ADBH1XCU ADBH1XC1 ADBH1XC2 ADBH6CFR ADBH6COV ADBH7CTP ADBH7O ADBH9000 ADBPAGVI ADBPEC ADBPELC ADBPELC0 ADBPEQB ADBPEQI ADBPEQP ADBPEQS ADBPZAT ADBP1ARC ADBP1GV ADBP1GVI ADBP1RTS ADBP1XCU ADBP1XC1 ADBP1XC2 ADBP6CAT ADBP6CFN ADBP7CON ADBP7CTP ADBP7GV ADBP7HA ADBP7O ADBP9000 ADBTEPU ADBTEP2 ADB0 ADB0001 ADB2CMF ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2E ADB2EC ADB2EL ADB2ELIH ADB2EQ ADB2MSK ADB2PA ADB2REM ADB2REP ADB2UOPS ADB2UXO ADB2UXO1 ADB2UXO2 ADB20 ADB21F ADB21II1 ADB21KB ADB21KR ADB21O ADB21S ADB21SP ADB21T ADB21TA ADB21XAR ADB26CFR ADB26CFS ADB26CO ADB26COU ADB26COV ADB27C ADB27C0 ADB27DUP ADB27PC ADB58 ADB7000 ADB80
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RB10 PSY UI15413
UP14/02/26 P F402
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":"11.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 March 2014