A fix is available
APAR status
Closed as new function.
Error description
Native Stored Procedures support for DB2 9
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Administration Tool Version 7.2 * * and DB2 Version 9. * **************************************************************** * PROBLEM DESCRIPTION: * * This APAR adds the following additional * * capabilities in support of DB2 Version * * 9 Native SQL Procedures (NSP): * * * * Create dialog panels to allow creating * * a NSP. Alter dialog panels to allow * * altering a NSP. GEN and DDL support of * * a NSP. Cloning support of objects in * * the NSP body Validate support of a NSP. * * and objects in the NSP body. For Change * * Management installations, APAR PK72445 * * is required, which delivers companion * * function for DB2 Object Comparison Tool * * for z/OS. * * * * The product has been recompiled with * * Enterprise PL/I for z/OS Version 3.6. * * * * At the PK72446 level, the value * * produced for the catalog column * * SYSTABLESPACESTATS.UNCOMPRESSEDDATASIZE * * when generating catalog statistics was * * from SYSTABLESPACESTATS.DATASIZE. With * * this APAR, the UNCOMPRESSEDDATASIZE * * value is used for the value. * * * * Note: A non-active NSP cannot be * * changed when using the * * Change Management function. * * * * Note: The capability to create DDL for * * Trusted Contexts and Roles will * * be provided in a future APAR. * **************************************************************** * RECOMMENDATION: Apply The PTF. * **************************************************************** This APAR adds the following additional capabilities in support of DB2 Version 9 Native SQL Procedures (NSP): Create dialog panels to allow creating a NSP. Alter dialog panels to allow altering a NSP. GEN and DDL support of a NSP. Cloning support of objects in the NSP body. Validate support of a NSP and objects in the NSP body. For Change Management installations, APAR PK72445 is required, which delivers companion function for DB2 Object Comparison Tool for z/OS. The product has been recompiled with Enterprise PL/I for z/OS Version 3.6. At the PK72446 level, the value produced for the catalog column SYSTABLESPACESTATS.UNCOMPRESSEDDATASIZE when generating catalog statistics was from SYSTABLESPACESTATS.DATASIZE. With this APAR, the UNCOMPRESSEDDATASIZE value is used for the value. Note: A non-active NSP cannot be changed when using the Change Management function. Note: The capability to create DDL for Trusted Contexts and Roles will be provided in a future APAR.
Problem conclusion
Temporary fix
Comments
These enhancements have been provided. PK72446 includes the following 26 APARs. - PK57815 PK57826 PK57978 PK63776 PK72431 PK77968 PK79940 PK81089 PK82671 PK82758 PK83069 PK83906 PK83969 PK83972 PK84569 PK84937 PK85860 PK86496 PK86504 PK86510 PK87225 PK87918 PK87987 PK88009 PK89740 PK91464 o. APAR PK57815 PROBLEM DESCRIPTION CM ANALYZE WITH RECOVER IS MISSING REBIND STATEMENT FOR DROPPED INDEX. o. APAR PK57826 PROBLEM DESCRIPTION User abend 4,038 dec occurred processing command 'DSN '. FUNCTION=ADB2WVL,LINE 261: Signal error o. APAR PK57978 PROBLEM DESCRIPTION The SQL procedure body was not being extracted by the GEN or DDL commands. o. APAR PK63776 PROBLEM DESCRIPTION The generated DDL for an MQT did not reflect the current setting of the 'maintained by' & 'query optimization' settings. This problem occurs when these settings are altered after the MQT is created. o. APAR PK72431 PROBLEM DESCRIPTION SQLCODE -665 using DB2 v9 when attempting to Alter an implicit table space. o. APAR PK77968 PROBLEM DESCRIPTION When comparing tables that use table-controlled partitioning the number of partitions is reduced. Definition of indexes is not provided in the source. The option Suppress DROP of objects is specified enforcing to keep indexes. Indexes are recreated with the definition from target which has the old number of parts. Validate does not detect a partition number mismatch between table space or table and index. SQL CODE -644 / SQLCODEN644 will be seen for this problem. o. APAR PK79940 CHANGE MANAGEMENT MISSING NEW COLUMN IN INDEX. o. APAR PK81089 PROBLEM DESCRIPTION The following parser error occurred "Special register error after CURRENT" ADB1847E WARNING : Error parsing <stmt-type> statement. o. APAR PK82671 PROBLEM DESCRIPTION When generating a view or MQT with an 'object owner' ( 'object schema' for DB2 v9 ) override whose object definition contains an unqualified table reference, a parser error occurs when running the ADB2GEN program. ADB1847E WARNING : Error parsing <stmt-type> statement. o. APAR PK82758 PROBLEM DESCRIPTION Users have to manually go to the generated JCL to remove REBIND parm generated by ADB2GEN. o. APAR PK83069 PROBLEM DESCRIPTION An 'abend0c4 oncode8094 ADB2REG' occurred in the COL_PROC of ADB2REG: IBM0534S ONCODE=8094 PROTECTION EXCEPTION FROM COMPILE UNIT ADB2REG AT ENTRY POINT COL_PROC AT STATEMENT 3153 AT COMPILE UNIT OFFSET 00022D7A AT ENTRY OFFSET 00003FB6 AT ADDRESS 17CE64E2. o. APAR PK83906 PROBLEM DESCRIPTION ALC on table, using CM with UTIL user-template PUNCHDDN produces WSL with duplicate. o. APAR PK83969 PROBLEM DESCRIPTION DB2 Administration Tool always sorts alphabetically, including numeric columns. This may display a result that is confusing to the user. o. APAR PK83972 PROBLEM DESCRIPTION The GEN program issued the following message: ADB1636E Catalog row stack full. o. APAR PK84569 PROBLEM DESCRIPTION A parser error (Parameter in Procedure call not recognized) occurred while generating DDL for a trigger. o. APAR PK84937 PROBLEM DESCRIPTION Using DEFER YES masking ability was not working in the Change Management Import process. o. APAR PK85860 PROBLEM DESCRIPTION A protection exception can occur while running the ADB2GEN program "Protection Exception in GEN_INDEX+8612 in module ADB2REM". o. APAR PK86496 PROBLEM DESCRIPTION User inputs on ADB2USO1 does not retain when the look up function for MAPTBL NAME return. o. APAR PK86504 PROBLEM DESCRIPTION Users can only enter up to 7 characters in the LISTDEFs Table Owner field via panel ADB25LA. It should allow for up to 8 characters. o. APAR PK86510 PROBLEM DESCRIPTION When using line command GEN with EXECUTION MODE=TSO on ADB2GEN and then using line command REP, EXECUTION MODE was changed to BATCH. o. APAR PK87225 PROBLEM DESCRIPTION Validating Changes file results in discrepancy of consistency check report. o. APAR PK87918 PROBLEM DESCRIPTION The database override value was not applied to the database reference in a MQT definition. o. APAR PK87987 PROBLEM DESCRIPTION The DB2 Administration Tool for z/OS ALC command causes the panel ADB2P2 'Change DB2 Admin Defaults' field 'Max No of Rows to Fetch' to be set to 5000. o. APAR PK88009 PROBLEM DESCRIPTION A parser error occurred when parsing a CREATE TABLESPACE statement. This is similar to the following, but the token_index value can be different: Invalid token after NO in CREATE/ALTER TABLESPACE statement -- TOKEN_INDEX= 29;, Token=IN o. APAR PK89740 PROBLEM DESCRIPTION Changing a DECIMAL to a TIME column can cause an ABEND S04E abend in the LOAD step of an ALC job. o. APAR PK91464 PROBLEM DESCRIPTION ALC on panel ADB21T may not proceed to panel ADB27C under certain circumstances. ž**** PE09/08/26 PTF IN ERROR. SEE APAR PK94699 FOR DESCRIPTION ž**** PE09/11/25 PTF IN ERROR. SEE APAR PK98931 FOR DESCRIPTION ž**** PE10/08/06 PTF IN ERROR. SEE APAR PM17236 FOR DESCRIPTION
APAR Information
APAR number
PK72446
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-07-25
Last modified date
2010-09-23
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK48694
Modules/Macros
ADBASW ADBASWSI ADBASW1 ADBCCME ADBCCMM ADBCDCH ADBCDTS ADBCDTW ADBCEST ADBCHU06 ADBCIMU ADBCMPC ADBCMRQ ADBCPRE ADBCPRT ADBCRC ADBCRCA ADBCRCC ADBCRCM ADBCRCP ADBCRCR ADBCSPG ADBCSRV ADBCUPC ADBCUPD ADBCVC ADBCVCP ADBCVCT ADBCVEX ADBCVIC ADBCVIM ADBCVOB ADBCVSX ADBDBSP ADBDELE ADBDICT ADBFB2VB ADBGETE ADBHGEN ADBH1O ADBH1XAR ADBH6CO ADBH6COQ ADBH6COU ADBH6COV ADBH6COW ADBH8M ADBIRXF ADBJCLIP ADBMAIN ADBMCCS ADBMLOBF ADBMSG ADBMSGP ADBNSPB ADBPGMN ADBSR ADBSRL ADBSR0 ADBTEPU ADBTEP2 ADBUNI ADBVCHR ADBV99 ADB1000 ADB2CDC ADB2CHK ADB2CID ADB2CMM ADB2CMPR ADB2CON ADB2C21 ADB2DEP ADB2DF ADB2DID ADB2FMT ADB2GEN ADB2GENS ADB2GEN2 ADB2GEN6 ADB2GET ADB2INC ADB2ISQ ADB2LC ADB2LCAT ADB2MSK ADB2M1S ADB2OVW ADB2PA ADB2PA3 ADB2PA4 ADB2PA5 ADB2PA6 ADB2PA7 ADB2PRP ADB2RCM ADB2RCP ADB2RE ADB2REC ADB2REE ADB2REG ADB2REH ADB2REM ADB2REP ADB2RER ADB2RES ADB2RET ADB2REU ADB2REY ADB2REZ ADB2RGC ADB2RIP ADB2RPT ADB2RS ADB2SQL ADB2SYS ADB2TSO ADB2UOPL ADB2UOPS ADB2USO1 ADB2WCL ADB2WIN ADB2WVL ADB2W1 ADB2ZP ADB2ZPV ADB2ZZ ADB2ZZRS ADB2ZZSP ADB2ZZV7 ADB2ZZV8 ADB2ZZV9 ADB21DSN ADB21I ADB21K ADB21KB ADB21KR ADB21KRT ADB21O ADB21OI1 ADB21S ADB21SA ADB21SP ADB21TDE ADB21XP ADB25 ADB25LA ADB25T ADB25TL1 ADB26CO ADB26COP ADB26COQ ADB26COU ADB26COV ADB26COW ADB27A ADB27AC ADB27ACM ADB27AD ADB27AP ADB27C ADB27C0 ADB27DC1 ADB27SP ADB28M ADB28MC ADB28MM ADB3000 ADB38 ADB70 ADB71 ADB72 ADB73 ADB8SQL H0IH720J
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
R720 PSY UK48694
UP09/07/31 P F907
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:
23 September 2010