APAR status
INTRAN
Error description
FIX CATEGORY (FIXCAT) for the fixes that allow the prior release of DB2 to migrate to or fall back from DB2 V9 is IBM.Migrate-Fallback.DB2.V9 The keyword for this is DB2MIGV9/K . See the detail on FIXCAT at http://www-03.ibm.com/systems/z/os/zos/smpe/fixcategory.html . . 5740XYR00 R910 DB2 V8 MIGRATION/FALLBACK INFOAPAR TO/FROM DB2 9 FOLLOWING PTFS ARE FOR DB2 9 MIGRATION: (Last Updated on 02/04/2011) Key: n.v. = not visible under a Diagnose Display MEPL * = quick module check under Diagnose Display MEPL Please pay special attention to all ++Hold Actions. --------------------------------------------------------------- PK11129(PE/y)/UK90008-v8 (F610) Toleration of fallback from DB2 Version 9 (R910). In a Data Sharing environment, required for coexistence of V8R1 and V9R1. MODULES/MACROS: DSNDRIB DSNACA70 DSNARA70 DSNARIB DSNECP12 DSNGEDLC DSNHDECP DSNRRPRC DSNRRSBS DSNTSTR2 DSNUECM2* DSNXCATL DSNXLDBD DSNXLVCM DSNX9RIB PK31841/UK23131-v8,UK23132-v9 (F704) Fix errors in the DB2 V9 premigration job DSNTIJPM that is shipped with DB2 V9. Also provide V9 premigration job DSNTIJP9 that is shipped with DB2 V8. These jobs provide a convenient way for current DB2 for z/OS V8 customers to run health checks in preparation for migration to DB2 V9.1 for z/OS. MODULES/MACROS: DSNTIJP9 DSNTINS1 v8, DSNTIJPM v9 n.v. PK33664(PE/y)/UK22035-v8 (F702) In V8/V9 coexistence or fallback from V9 to V8 situations, different abends may occur in the V8 DB2 member: 1. Abend04E RC00E40317 in DSNUTILA.DSNUGABN+0692 2. Abend04E RC00E30086 in DSNTDC.DSNTDMI+1452 3. Abend0C4 RC00000038 in DSNXKAP.DSNXKINS+0812 MODULES/MACROS: DSNXCATL DSNXKINS PK35481/UK20612 (COMPID - 5740SM105 , DFSORT) ABENDS0C4 with 00000028 during migration to DB2 V9 while reorging SYSPACKAGE. MODULES/MACROS: ICECOBV PK38799(PE/y)/UK24425-v8 (F704) (1) If a user migrates to V9 and creates V9 Explain tables, then after fallback to V8 the user will no longer be able to do Explain. SQLCODE -220 may occur during Explain. UK90008 was missing fallback support for Explain. (2) Various abends in DSNSVBK or other modules may occur after applying UK20137 when Explain is performed and DSN_PREDICAT_TABLE or DSN_FUNCTION_TABLE exists. MODULES/MACROS: DSNXIEPL DSNXOCCH* DSNXOD0 DSNXOD0A DSNXOD0P DSNXOD0Z DSNXOD1 DSNXOD10 DSNXOD12 DSNXOD13 DSNXOD2 DSNXOD3 DSNXOD4 DSNXOD7 DSNXOD8 DSNXOD9 DSNXOLX1 DSNXOLX2 DSNXOOP DSNXOPTH DSNXOPTI DSNXOPTJ DSNXOTS PK39677/UK28751-v9 (F709) When migrating to DB2 Version 9 MSGDSNT501I is displayed during job step ENFM1103 of job DSNTIJEN. REASON RC00C90080 TYPE00000200 NAME DSNRTSDB.DSNRTSTS MODULES/MACROS: DSNIRTSX PK39850(PE/y)/UK23138-v8 (F704) New Function - DB2 internal change to support future functions. MODULES/MACROS: DSNUGSUG DSNUGTE0 DSNUGUCC PK41731/UK24302-v9 (F707) MIGRATION FAIL FROM V8 TO V9 COMPAT MODE WHEN USING NATIONAL SIGN LEADING SEPARATE DATA TYPE IN A COBOL APPLICATION MODULES/MACROS: DSNHLEXC DSNHPSRV n.v. PK44544/UK29819-v9 (F710) Add optional job steps to DSNTIJPD to deploy temporary indexes to reduce runtime of the DSNTP2DP exec, a tool that facilitates conversion of applications from Private Protocol. MODULES/MACROS: DSNTIJPD n.v. PK44884(PE/y)/UK27092-v8 (F707) DSNE133E DSNECP12 RELEASE LEVELS NOT COMPATIBLE after applying APAR PK11129. TSO Attach attempts to determine if the DB2 version level of the attachment code and the DB2 subsystem are compatible, however the V8 RIBLIDV contains an incorrect constant value. MODULES/MACROS: DSNDRIB DSNECP12 n.v. PK45376(PE/y)/UK29761-v8,UK29762-v9 (F710) During Enabling New Function Mode (enfm) DSNTIJNE REORG with ptf UK21909 applied, MSGICE046A SORT CAPACITY EXCEEDED occurrs when REORGing SPT01. MODULES/MACROS: DSNURFIT PK45722/UK27799-v8,UK27800-v9 (F708) The DSNH CLIST has two different input parms for BIND REOPT options. These parms are called REOPT and PREOPT: The REOPT parm specifies the REOPT option setting for the DSNH-generated BIND PLAN statement, and the PREOPT parm specifies the REOPT option setting for the DSNH-generated BIND PACKAGE statement. Currently, PREOPT settings other than PREOPT(VARS) are ignored by DSNH. MODULES/MACROS: DSNH n.v. PK45981/UK27823-v8,UK27825-v9(F708) All users of V9 premigration checkout job DSNTIJP9 on DB2 UDB for z/OS Version 8 systems that specify COMMA for the DSNHDECP DECIMAL parameter are affected by this change. . All users of V9 premigration checkout job DSNTIJPM shipped with DB2 Version 9.1 for z/OS, and used on DB2 UDB for z/OS Version 8 systems that specify COMMA for the DSNHDECP DECIMAL parameter, are affected by this change. MODULES/MACROS: DSNTIJP9 v8 , DSNTIJPM v9 n.v. PK46054/UK29645-v9 (F710) Remove obsolete subsystem parameter REOPTEXT from DB2 V9.1 for z/OS. This change includes removing field 15 REOPT AUTOMATICALLY from installation panel DSNTIP8. MODULES/MACROS: DSNCIM DSNCIMX DSN@ZP DSNDQWPZ DSNDSPRM DSNTINST DSNTIP8 DSN6SPRM DSNWZP DSNTIDXA DSNTIJUZ n.v. PK46585/UK28799-v9 (F709) SQLCODE -904 may be issued incorrectly when a V8 member tries to access an object that was created by a V9 member. MODULES/MACROS: DSNXISB6 PK47538/UK26789-v9( F707) Empty string is returned to the client when executing a package bound prior to V9R1 to set host variable = CURRENT TIMESTAMP in a server which is migrated to V9. PK47893/UK32047(PE)(F712)-v9 Superseded By PK63288(PE/y)/UK36794(F806)-v9 PK47893/UK32046-v8 (F712) This PTF is shipped to update the DB2 administrative enablement interface, including the administrative scheduler. The update contains a partly new interface and bug fixes. MODULES/MACROS: DSNCIM DSN@DMTA DSN@DMTL DSN@DMTR DSN@DMTS DSN@DMTU DSN@6DB2 DSN@6THP DSNTINS1 DSNTINS2 DSN6SPRM DSNADMMG DSNADMMW DSNADMTA DSNADMTI* DSNADMTL DSNADMTM DSNADMTP DSNADMTR DSNADMTS DSNADMTU DSNA6BUF DSNA6DB2 DSNA6DMN DSNA6II DSNA6IPC DSNA6ITK DSNA6MAI DSNA6SCH DSNA6THD DSNA6THJ DSNA6THP DSNFADIR DSNFMDIR DSNYSTRT DSN7SINI DSNTIJDE DSNTIJFV DSNTIJIN DSNTIJSG MODULES/MACROS: DSNXRPUF PK48290/UK27933-v9 (F708) All DB2 V9 MQT users. MQT rewrite didn't happen on V9 for MQT created at V8. MODULES/MACROS: DSNXOXIC PK49077/UK33785-v8,UK33786-v9 (F803) At least one of the trace class startup fields on the V8 and V9 DSNTIPN (tracing parms) panel is too small to enter a desired combination of classes for that trace type. This requires the user to manually track the settings for migration. MODULES/MACROS: DSNTINST DSNTIPN PK49881/UK35078-v8,UK35079-v9 (F804) Users of the DB2 installation CLIST in DB2 UDB for z/OS Version 8 and DB2 Version 9.1 for z/OS and users of V8 install job DSNTIJNE and V9 install job DSNTIJEN are affected by this APAR. MODULES/MACROS: DSNTIPA1 DSNT46 DSNTIDXA DSNTIJEN n.v. PK50989/UK31536-v8,UK31537-v9 (F712) The IVP job DSNTEJ3M creates sample tables, populates the sample tables, creates Materialized Query Tables, produces statistics, and runs EXPLAIN on the sample queries. The EXPLAIN output should indicate that the sample queries used an MQT instead of the base tables. The current EXPLAIN output in STEP 7 of IVP job DSNTEJ3M shows that base tables were used instead of Materialized Query Tables. MODULES/MACROS: DSNTEJ3M n.v. PK54738/UK32702-v8,UK32703-v9 (F801) EIBNFM bit is NOT set ON at the completion of the migration from DB2 z/OS V8 Compat mode to New Function mode even though the new functions in the New Function mode are available. MODULES/MACROS: DSNGEDLC* DSNGENER DSNRRPRC DSNUECMI PK58941/UK34434-v8,UK34435-v9 (F803) ADDITIONAL FUNCTION OF DB2 FOR Z/OS OPTIMIZATION SERVICE CENTER DSNTIJOC: OSC OE, DSNTIJNX: user-managed DB2-supplied objects DSNTIJRA: install job for security OSC OE, DSNTESC: sample explain tables DSNTIJOM: existing V8 DB2 OSC & OE to V9 DB2. MODULES/MACROS: DSNTIxxx, DSNUGxxx, DSN5Oxxx macro's PK59399/UK39757-v8,UK39811-v9 (F809) Add support to DB2 for z/OS 1.10 utilities to read DFSORT installation options that were activated through ICEPRMxx members in PARMLIB. MODULES/MACROS: DSNUCRIB* DSNUCSOR DSNUGLSR DSNUGSOR DSNUGSRT DSNUKPIK DSNURPCT DSNURPIB DSNURSOR DSNUSDRB DSNUSSOR PK61841/UK38390-v8,UK38391-v9 (F808) All users of job DSNTIJPM in DB2 Version 9.1 for z/OS are affected by this change. DSNTIJP9 and V9 DSNTIJPM do not report incomplete object definitions. MODULES/MACROS: v8- DSNTIJP9 v9- DSNTIJPM n.v. PK62253/UK37066-v9 (F807) 04E-00C90101 DSNIMOFR erqual 5006 while running CATMAINT in migration from DB2 V8 to V9. MODULES/MACROS: DSNPGSGI PK66563/UK38612-v8,UK38613-v9 (F808) The authorization check for DISPLAY THREAD command resulted in ABEND0C4 with RC00000038, when DB2 is started in ACCESS(MAINT). MODULES/MACROS: DSNXACKP PK73081/UK42331-v8,UK42332-v9 (F812) Fix V9 premigration queries (DSNTIJP9,DSNTIJPM) for user defined indexes on the catalog and for incomplete table spaces. MODULES/MACROS: DSNTIJP9 v8 , DSNTIJPM v9 n.v. AI PK85068/UK53249-v8,UK53250-v9 (F001) EXPLAIN TABLE MIGRATION MODULES/MACROS: DSNTIJPM DSNTIJXA DSNTIJXB DSNTIJXC DSNTXTA DSNTXTB v8 & v9 , DSNTIJP9-v8 only PM14223/UK60838-v8,UK60839-v9 (F010) SQLCODE = -545 WHEN USING PREFIX.DSN_VIRTUAL_INDEXES TO CREATE VIRTUAL INDEXES ON AN EMPTY TABLE MODULES/MACROS: DSNTESC DSNTIJOS DSNTXTB PM17891/UK61197-v8,UK61198-v9/PM17891 (F010) DSNTIJXA/DSNTXTA AND DSNTIJXB/DSNTXTB DO NOT GENERATE VALID CONVERSION STATEMENTS (EBCDIC to UNICODE) MODULES/MACROS: DSNTXTA DSNTXTB
Local fix
N/A
Problem summary
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
II14401
Reported component name
PB LIB INFO ITE
Reported component ID
INFOPBLIB
Reported release
000
Status
INTRAN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-10-04
Closed date
Last modified date
2011-08-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":null,"label":null},"Product":{"code":"SG19O","label":"APARs - MVS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"000","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"000","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 August 2011