A fix is available
APAR status
Closed as new function.
Error description
DB2 ADMINISTRATION TOOL FOR Z/OS 10.2 NEW FUNCTION.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the DB2 Administration Tool * * and DB2 Object Comparison Tool for * * z/OS. Users of the DB2 Cloning * * Tool, InfoSphere Optim Configuration * * Manager (OCM), or IBM Tools Customizer * * for z/OS (TCz). * **************************************************************** * PROBLEM DESCRIPTION: The enhancement to integrate DB2 * * Administration Tool Migrate (MIG) * * function and DB2 Cloning Tool for * * z/OS allows a DBA to draw upon the * * benefits and efficiencies of both * * products. For example, a DBA can now * * perform a data migration using DB2 * * Cloning Tool's data set cloning * * techniques as an option. A user can * * migrate an object using the DB2 * * Cloning Tool via the 'CT - Migrate * * this table using the DB2 Cloning * * Tool' command on panel 'ADB21T - * * Tables, Views, and Aliases', 'CT - * * Migrate this table space using the * * DB2 Cloning Tool' command on panel * * 'ADB21S - Table Spaces', and the * * 'CT - Migrate this database using the * * DB2 Cloning Tool' command on panel * * 'ADB21D - Databases', and new panel * * 'ADBPCTT - Clone Tables' to generate * * migrate jobs. * * * * To enable the DB2 Table Editor 'EDIT - * * Edit with DB2 Table Editor' line * * command on DB2 Administration Tool * * for z/OS panel ADB21T 'Tables', * * panel ADB21A 'Aliases', and panel * * ADB21VV 'Views", new simplified * * instructions have been provided in * * DB2 Administration Tool EXEC member * * ADBETE. Enablement via TCz * * for the DB2 Administration Tool for * * z/OS is not available at this time, * * but will be provided via APAR PM75912. * * * * When binding DBRM ADB0 on a DB2 * * release other than DB2 10 in New * * Function Mode (NFM), message DSNX200I * * with SQLCODE=-206 / SQLCODEN206 can * * occur for statements 2577, 2692 and * * 3167 for DB2 catalog columns STMTBLOB * * and STATEMENT. These messages can be * * ignored at bind time because the * * originating statements will not be * * executed on the subsystem to which the * * DBRM is being bound. The statements * * will be marked in error at bind time. * * * * When the subsystem is migrated to * * DB2 10 in Enabling New Function * * Mode (ENFM) or New Function Mode * * (NFM), a REBIND for DBRM ADB0 will * * need to be performed. If a REBIND * * is not performed, the 'DET - Package * * details' line or primary command on * * a package may result in a SQLCODE=-525 * * / SQLCODEN525: * * * * DSNT408I SQLCODE = -525, * * ERROR: THE SQL STATEMENT * * CANNOT BE EXECUTED * * BECAUSE IT WAS IN ERROR AT * * BIND TIME FOR SECTION * * sectno PACKAGE = pkgname * * CONSISTENCY TOKEN = contoken * * DSNT418I SQLSTATE = 51015 * * SQLSTATE RETURN CODE * * * * If migration to DB2 10 Enabling New * * Function Mode (ENFM) has not * * completed successfully, the SQL * * statements for a package may not * * be present on panel ADBPD * * 'Details for object(s)' when using * * the 'DET - Package details' line * * or primary command on panel * * ADB21K 'Packages' on a package. * * Complete the migration process to * * DB2 10 ENABLING NEW FUNCTION * * (ENFM) MODE in order to view the * * SQL statements. * * * * The enhancements to Change * * Management in support of DB2 * * features are: * * * * 1. Extensions to CREATE and ALTER * * statements to define and maintain * * multiple versions of a SQL scalar * * function: * * * * Examples: * * * * CREATE FUNCTION * * >function name< >parameter list< * * RETURNS >parameter list< * * VERSION >routine version id< * * SPECIFIC >specific name< * * >other routine options< * * >function body< * * * * ALTER SPECIFIC FUNCTION * * >specific/function name< * * >alter options< * * * * ALTER SPECIFIC FUNCTION * * >specific/function name< * * ADD VERSION * * >routine version id< * * * * ALTER SPECIFIC FUNCTION * * >specific/function name< * * REPLACE VERSION * * >routine version id< * * * * ALTER SPECIFIC FUNCTION * * >specific/function name< * * DROP VERSION * * >routine version id< * * * * ALTER SPECIFIC FUNCTION * * >specific name< * * ACTIVATE VERSION * * >routine version id< * * * * 2. Support for SQL table functions: * * * * Example: * * * * CREATE FUNCTION >function name< * * >parameter list< * * RETURNS TABLE >column list with * * corresponding data types< * * >other routine options< * * * * 3. Support for using a distinct type * * in a native SQL procedure (NSP): * * * * CREATE PROCEDURE >procedure name< * * (>parameter name< * * >distinct type name<, ...) * * VERSION >routine version id< .... * * * * The enhancement to the Describe * * Package functionality adds EXPLAIN * * information to the describe report * * on panel ADBPD 'Details for object(s)'. * * Describe package report is view-able * * on panel ADBPD 'Details for object(s)' * * when the 'DET - Package details' * * primary or line command is issued on * * ADB21K panel, against selected * * package objects. * * * * The enhancements to Columns * * participating in the partitioning * * of the table and limitkey values for * * each of the partitions are: * * * * 1. When the partitioning is done * * via table controlled partitioning, * * the partitioning information follows * * the column information prior to * * presenting any indexes for the table. * * * * 2. When the partitioning is done * * via index controlled partitioning, * * the partitioning information is * * already presented because one of the * * indexes is the partitioning index. * * * * Removal of the ALTER TABLE ALTER * * COLUMN restriction for tables defined * * with the DATA CAPTURE CHANGES * * attribute. * * * * Prior to APAR PM05503, tables defined * * with the DATA CAPTURE CHANGES * * attribute could not be altered with * * the ALTER TABLE ALTER COLUMN command. * * The tables had to be dropped and * * recreated. * * * * The DB2 Admin and DB2 Object Compare * * product was bound by this restriction * * and implemented ALTER TABLE ALTER * * COLUMN changes with DROP/CREATE. * * * * When binding to package ADBL using the * * following bind statement: * * * * BIND PACKAGE(ADBL) * * MEMBER(ADB0) * * QUALIFIER(SYSIBM) * * VALIDATE(BIND) * * ISOLATION(CS) * * RELEASE(C) * * ENCODING(EBCDIC) * * SQLERROR(CONTINUE) * * EXPLAIN(NO) * * * * the user will receive a SQLCODE=-805 / * * SQLCODEN805: * * * * DSNT408I SQLCODE = -805, * * ERROR: DBRM OR PACKAGE NAME * * >location_name<..ADB0.>consistency * * token< NOT FOUND IN PLAN * * ADB. REASON 03 * * DSNT418I SQLSTATE = * * 51002 SQLSTATE * * RETURN CODE * * * * The following new DBRMs have been * * added: * * * * ADBCRCH, ADBLI, ADBLIO, * * ADBLIOB and ADBPARM * * * * BIND PACKAGE(ADBL) * * MEMBER(ADBCRCH) * * QUALIFIER(ADB) * * VALIDATE(BIND) * * ISOLATION(CS) * * RELEASE(C) * * ENCODING(EBCDIC) * * SQLERROR(CONTINUE) * * EXPLAIN(NO) * * * * BIND PACKAGE(ADBL) * * MEMBER(ADBLI) * * QUALIFIER(ADB) * * VALIDATE(BIND) * * ISOLATION(CS) * * RELEASE(C) * * ENCODING(EBCDIC) * * SQLERROR(CONTINUE) * * EXPLAIN(NO) * * * * BIND PACKAGE(ADBL) * * MEMBER(ADBLIOB) * * QUALIFIER(ADB) * * VALIDATE(BIND) * * ISOLATION(CS) * * RELEASE(C) * * ENCODING(EBCDIC) * * SQLERROR(CONTINUE) * * EXPLAIN(NO) * * * * BIND PACKAGE(OCMLOCATION.ADB) * * MEMBER(ADBLIO) * * QUALIFIER(IBMIOCM) * * VALIDATE(RUN) * * ISOLATION(CS) * * RELEASE(C) * * ENCODING(EBCDIC) * * SQLERROR(CONTINUE) * * EXPLAIN(NO) * * * * BIND PACKAGE(ADBL) * * MEMBER(ADBPARM) * * QUALIFIER(ADB) * * VALIDATE(BIND) * * ISOLATION(CS) * * RELEASE(C) - * * ENCODING(EBCDIC) * * SQLERROR(CONTINUE) * * EXPLAIN(NO) * * * * to the SADBDENU library and member * * ADBBND01 should be run. * * * * A bind job is generated and submitted * * as part of enabling DB2 Admin * * integration with InfoSphere Optim * * Configuration Manager (OCM), which is * * optional. This bind job is created * * via IBM Tools Customizer for z/OS * * (TCz) where the user must specify the * * location of the OCM database * * repository. * **************************************************************** * RECOMMENDATION: * **************************************************************** Enhancements are delivered.
Problem conclusion
Temporary fix
********* * HIPER * *********
Comments
Enhancements are delivered. Describe Package functionality was delivered via APAR PM69923. DB2 Administration Tool for z/OS exec members ADB21D 'Database', ADB21S 'Table Space', and ADB21T 'Tables, Views, and Aliases' have been updated to include on the new line command 'CT - Migrate objects using the DB2 Cloning Tool'. Therefore, if a customer modified/customized these three execs in the past by adding their own customized line commands, those customized line commands will need to be reapplied once the PTF has been applied. Restriction for the ALTER TABLE ALTER COLUMN for tables defined with the DATA CAPTURE CHANGES attribute has been removed. SQLERROR() option for package ADBL, member ADB0 was changed to CONTINUE. The following new DBRMs have been added: ADBCRCH, ADBLI, ADBLIO, ADBLIOB and ADBPARM to the SADBDENU library and member ADBBND01 should be run. The change management database has been updated. For existing users of DB2 Administration Tool for z/OS Version 10.2: 1. The ADBCHG01 SAMP member needs to be run to update the change management database.
APAR Information
APAR number
PM72590
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
A20
Status
CLOSED UR1
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt
Submitted date
2012-09-11
Closed date
2012-11-06
Last modified date
2012-12-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UK83270
Modules/Macros
ADB$$CCQ ADB$$DSC ADB$$PRM ADB$$SEQ ADBAC2D ADBA1TC ADBA1TG ADBA1TH ADBA1TM ADBA1TP ADBA1TV ADBA1TX ADBBIND ADBBND01 ADBCATVT ADBCCM ADBCCMM ADBCDTS ADBCDTW ADBCEST ADBCEXP ADBCFGBD ADBCFGPM ADBCHANG ADBCHG01 ADBCMPC ADBCMPDB ADBCPRE ADBCPRM ADBCRCH ADBCRCM ADBCRCR ADBCUPC ADBCUST ADBCVOC ADBC0 ADBC11 ADBC15 ADBC30 ADBD ADBDBSP ADBDELE ADBDICT ADBDK ADBDSR ADBDT ADBEAPI0 ADBECT ADBEC15 ADBED ADBEDIAG ADBETE ADBE8T ADBGETE ADBGHV ADBHCTS ADBHCTT ADBHC1 ADBHC15 ADBHC15A ADBHDIAG ADBHDK ADBHDT ADBHDTL ADBHDTP ADBHP2 ADBH1D ADBH1S ADBH1T ADBH8AD ADBH8ADD ADBH8AS ADBH8ASD ADBH8AT ADBH8ATD ADBIC ADBLI ADBLIM ADBLIO ADBLIOB ADBMAIN ADBMCMA ADBOPTS ADBOPT1 ADBOPT10 ADBOPT2 ADBOPT3 ADBOPT4 ADBOPT5 ADBOPT6 ADBOPT7 ADBOPT8 ADBOPT9 ADBPA ADBPARM ADBPA1 ADBPCEX ADBPCR ADBPCRS ADBPCTS ADBPCTT ADBPCT0 ADBPC15 ADBPC15A ADBPD ADBPDIAG ADBPLI ADBPMCR ADBR ADBREST ADBTEPI ADBTEP2 ADBUNIA ADBVCHR ADB0 ADB2CEX3 ADB2CID ADB2CLUP ADB2CMF ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2CUST ADB2C1 ADB2C11 ADB2C11A ADB2DEP ADB2DF ADB2FMT ADB2ISQ ADB2LC ADB2MSK ADB2PA ADB2PA3 ADB2PA5 ADB2PA6 ADB2PA7 ADB2P2 ADB2RCPC ADB2RE ADB2REE ADB2REH ADB2REM ADB2RER ADB2RES ADB2REZ ADB2TABS ADB2UOPS ADB2US0 ADB2VERD ADB2WCL ADB2WVL ADB2000 ADB21A ADB21D ADB21G ADB21GA ADB21I ADB21KB ADB21S ADB21SP ADB21T ADB21TC ADB21TIN ADB21TSE ADB21VV ADB21X ADB21XAR ADB21XP ADB26CFU ADB26CJ ADB26COU ADB26CUU ADB26CX ADB27C ADB27CA ADB27CAA ADB27CX ADB27PAS ADB27PTR ADB28AD ADB28ADD ADB28AS ADB28ASD ADB28AT ADB28ATD ADB7000 ADB74 ADB8SQL ADB9000 H0IHA20J
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RA20 PSY UK83270
UP12/11/09 P F211
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":"10.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 December 2012