A fix is available
APAR status
Closed as new function.
Error description
The DB2 Administration Tool GEN, OC, and CM support of DB2 9
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Administration Tool Version 7.2 * * and DB2 Version 9. * **************************************************************** * PROBLEM DESCRIPTION: Changes to objects with DB2 Version * * 9 characteristics was previously * * restricted or had limited capability. * * * * This APAR added the following * * additional features: * * * * Change functions which limited * * or restricted the changing * * of DB2 9 attributes now have * * expanded capabilities to allow * * changing many DB2 Version 9 * * attributes. * * * * For Change Management installations, * * DB2 APAR PK72242 is required, which * * also delivers similar function for * * DB2 Object Comparison Tool. * * * * Objects with XML columns can now be * * unloaded with base table data going * * to the SYSREC data set and the XML * * column data going to the data set as * * directed by the XML TEMPLATE. This * * capability requires that the job be * * built as a work statement list. * * * * The MIGRATE function supports * * unloading XML columns either * * using a work statement list or * * using JCL, and has also been * * enhanced to exclude implicitly * * created objects from its object * * display. * * * * The masking function has been * * enhanced to support masking of * * the catalog column SCHEMA, and * * offers more granularity with the * * new TBSCHEMA, IXSCHEMA, TBOWNER * * and IXOWNER masks. The xxSCHEMA * * mask must be placed ahead of any * * xxOWNER masks if a different mask * * value is to be used for the schema * * value than for the owner value. * * * * The GEN and DDL functions have been * * enhanced to support DB2 Version 9 * * object definitions (DDL). * * * * The capabilities are described more * * fully in companion APARs to this APAR. * * * * Note: The capability to create DDL * * for Native Stored Procedures, * * Trusted Contexts, and Roles * * will be provided in a future * * APAR. * * * * Note: The value produced for the * * catalog column * * SYSTABLESPACESTATS.UNCOMPRESSEDDATASIZE * * * * when generating catalog * * statistics will be the * * value from * * SYSTABLESPACESTATS.DATASIZE. * * * * The UNCOMPRESSEDDATASIZE value * * will be provided in via APAR * * PK72446. * * * * The product's EXPLAIN dialog has been * * enhanced to support XML access path * * information and to create or update a * * PLAN_TABLE definition to support new * * DB2 Version 9 fields. * * * * The change management Register process * * has been enhanced to set or include the * * CURRENT SCHEMA ahead of the statements * * being registered. * * * * The Create Table and Alter Table * * dialogs have been enhanced to allow * * creating tables with BIGINT, BINARY, * * VARBIN, DECFLOAT or XML data types, * * or altering to add such columns. * * * * Additionally, the ALC dialog allows * * adding, removing or renaming such * * columns. * * * * Note: Changing the data types to * * or from the above data types * * within ALC will be provided * * in a future APAR. * * * * * * The RDEF dialog has been enhanced to * * allow specifying an index using the * * RANDOM keyword, and changing a table * * space format from a V8 format to a * * partitioned-by-range format. * * * * The Drop Impact dialog has been * * enhanced to report upon DB2 Version * * 9 object types and authorizations. * * * * The WSL Validate function hasbeen * * enhanced to recognize that DB2 * * Version 9 will create certain * * objects implicitly, such as a unique * * or primary key index, and thus not * * report an error. * * * * * * The Batch Restart facility (ADBTEP2) * * has been enhanced to support unloading * * ML objects, tables with hidden columns, * * and preserving the active CURRENT * * SCHEMA across restart points. * * * * To preserve data values during unload, * * tables with hidden columns shall be * * unloaded using only supported utilities * * which unload the hidden columns (DB2 * * Unload and HPU). * * * * DSNTIAUL does not unload hidden * * columns cso it cannot be used to * * unload such tables. * **************************************************************** * RECOMMENDATION: Apply The PTF. * **************************************************************** Changes to objects with DB2 Version 9 characteristics was previously restricted or had limited capability. This APAR added the following additional features: Change functions which limited or restricted the changing of DB2 9 attributes now have expanded capabilities to allow changing many DB2 Version 9 attributes. For Change Management installations, DB2 APAR PK72242 is required, which also delivers similar function for DB2 Object Comparison Tool. Objects with XML columns can now be unloaded with base table data going to the SYSREC data set and the XML column data going to the data set as directed by the XML TEMPLATE. This capability requires that the job be built as a work statement list. The MIGRATE function supports unloading XML columns either using a work statement list or using JCL, and has also been enhanced to exclude implicitly created objects from its object display. The masking function has been enhanced to support masking of the catalog column SCHEMA, and offers more granularity with the new TBSCHEMA, IXSCHEMA, TBOWNER and IXOWNER masks. The xxSCHEMA mask must be placed ahead of any xxOWNER masks if a different mask value is to be used for the schema value than for the owner value. The GEN and DDL functions have been enhanced to support DB2 Version 9 object definitions (DDL). The capabilities are described more fully in companion APARs to this APAR. Note: The capability to create DDL for Native Stored Procedures, Trusted Contexts, and Roles will be provided in a future APAR. Note: The value produced for the catalog column SYSTABLESPACESTATS.UNCOMPRESSEDDATASIZE when generating catalog statistics will be the value from SYSTABLESPACESTATS.DATASIZE. The UNCOMPRESSEDDATASIZE value will be provided in via APAR PK72446. The product's EXPLAIN dialog has been enhanced to support XML access path information and to create or update a PLAN_TABLE definition to support new DB2 Version 9 fields. The change management Register process has been enhanced to set or include the CURRENT SCHEMA ahead of the statements being registered. The Create Table and Alter Table dialogs have been enhanced to allow creating tables with BIGINT, BINARY, VARBIN, DECFLOAT or XML data types, or altering to add such columns. Additionally, the ALC dialog allows adding, removing or renaming such columns. Note: Changing the data types to or from the above data types within ALC will be provided in a future APAR. The RDEF dialog has been enhanced to allow specifying an index using the RANDOM keyword, and changing a table space format from a V8 format to a partitioned-by-range format. The Drop Impact dialog has been enhanced to report upon DB2 Version 9 object types and authorizations. The WSL Validate function has been enhanced to recognize that DB2 Version 9 will create certain objects implicitly, such as unique or primary key index, and thus not report an error. The Batch Restart facility (ADBTEP2) has been enhanced to support unloading XML objects, tables with hidden columns, and preserving the active CURRENT SCHEMA across restart points. To preserve data values during unload, tables with hidden columns shall be unloaded using only supported utilities which unload the hidden columns (DB2 Unload and HPU). DSNTIAUL does not unload hidden columns so it cannot be used to unload such tables.
Problem conclusion
Temporary fix
Comments
The enhancements have been provided.
APAR Information
APAR number
PK72442
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
720
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-09-18
Closed date
2009-06-18
Last modified date
2009-07-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADBASW ADBBIND ADBCCMM ADBCDTS ADBCEST ADBCHANG ADBCHAN7 ADBCHKPT ADBCHU06 ADBCHU07 ADBCMPC ADBCRCA ADBCRCC ADBCRCM ADBCRCP ADBCRCR ADBCSPG ADBCVCT ADBCVEX ADBCVIC ADBCVOB ADBC04 ADBC10 ADBC11 ADBETEP ADBHC2L ADBHDEC ADBHDIPD ADBHE ADBHELI ADBHELS ADBHGEN ADBHW1Q ADBH1DAJ ADBH1K ADBH1S ADBH1T ADBH1X ADBH1XA ADBH1XAR ADBH5L ADBH6CTF ADBH6CTU ADBH7A ADBH7CR ADBH9000 ADBMAIN ADBPDEC ADBP9000 ADBTEPU ADBTEP2 ADBTTP ADBV99 ADB1000 ADB2ALL0 ADB2CCA ADB2CDC ADB2CID ADB2CIMP ADB2CMM ADB2CPS ADB2CRO ADB2CR0 ADB2C14 ADB2C2L ADB2DEP ADB2DIP ADB2DIPD ADB2E ADB2EL ADB2ELF ADB2ELI ADB2ELIH ADB2ELS ADB2FMT ADB2GEN ADB2GENS ADB2GEN2 ADB2GEN6 ADB2MSK ADB2OVW ADB2PA ADB2PA3 ADB2PA4 ADB2PA5 ADB2PA6 ADB2PA7 ADB2PSTM ADB2PTPL ADB2RE ADB2REC ADB2REE ADB2REG ADB2REH ADB2REM ADB2REP ADB2RER ADB2RES ADB2RET ADB2REU ADB2REY ADB2REZ ADB2RGC ADB2RIPI ADB2RPT ADB2U ADB2UPA ADB2USH2 ADB2USU ADB2UT ADB2UTH1 ADB2UTU ADB2UTUL ADB2UT0 ADB2WCL ADB2WIN ADB2WL4 ADB2WVL ADB2W1 ADB2Z2B ADB2Z2BU ADB21A ADB21D ADB21DAJ ADB21DAR ADB21DA0 ADB21DS ADB21J ADB21K ADB21S ADB21SA ADB21SAJ ADB21SAR ADB21T ADB21TA ADB21TAB ADB21TAF ADB21TAN ADB21TAP ADB21X ADB21XA ADB21XAR ADB21XAS ADB25T ADB25TE ADB25TL1 ADB25TU ADB25TU3 ADB26CRT ADB26CT ADB26CTF ADB26CTP ADB26CTU ADB26CUU ADB26DD ADB26DG ADB26DS ADB26DT ADB26PTR ADB27A ADB27AC ADB27AD ADB27C ADB27CA ADB27CAA ADB27CFU ADB27CMR ADB27CSR ADB27CU ADB27CX ADB27C0 ADB27DUP ADB27IFF ADB27PC ADB27PTR ADB27STR ADB27TUL ADB28ADD ADB28AS ADB28ASD ADB28ATD ADB28HPU ADB28M ADB28MC ADB28MM ADB28M2 ADB28S ADB28T ADB28UL1 ADB28UT ADB29 ADB3000 ADB33 ADB34 ADB38 ADB45 ADB47 ADB5000 ADB51 ADB52 ADB54 ADB70 ADB72 ADB73 H0IH720J
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
R720 PSY UK47570
UP09/06/26 P F906
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:
01 July 2009