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 (Continued from II14401) Key n.v. = not visible under a Diagnose Display MEPL * = quick module check under Diagnose Display MEPL Please pay special attention to ++Hold Actions. FOLLOWING PTFS ARE FOR DB2 9 MIGRATION: (Updated on Feb/01/2013) PK62161/UK44050-v8,UK44051-v9 (F903) IFCID 002 / IFCID 003 are updated to include new counters that indicate the number of rows fetched/updated/inserted/deleted. MODULES/MACROS: DSNDQXST DSNIDLEC* DSNILREP DSNISRTI DSNISRTW DSNITDLE DSNTLRAC DSNTSTRT DSNTXACT DSNTXSTB DSNUECM2 DSNUGUCA DSNWAACT DSNWVSMT DSNWVZIT DSNWVZSA DSNWZDG2 DSNXEBR DSNXEET DSNXELX DSNXENR DSNXIENF DSNXINIT DSNXISTK DSNXTAD DSNXTSD PK62178/UK44489-v9 (F903) The maximum number of databases that can be created implicitly is hard-coded to 60000. MODULES/MACROS: DSNUECSE DSNXIAQ1 DSNXIASQ DSNTISB5 PK70060(HIPER)/UK46839-v9 (F906) DGTT mass delete performance enhancement. ABEND04E RC00E72088 DSNXSMRG+3452 during scan of workfile MODULES/MACROS: DSNIBWAC DSNICMT2 DSNIGWAC DSNISEGD DSNISEGF DSNISGNS DSNITNPG DSNIWCUB DSNIWKFL DSNWDFDM PK72214/UK46092-v8,UK46093-v9 (F905) Unexpected DSNU778I and SQLCODE -148 when running CATMAINT or CATENFM utility. MODULES/MACROS: DSNTIJP9 v8 , DSNUECSE DSNTIJPM v9 n.v. PK75643/UK42565-v9 (F901) The default value of subsystem parameter OPTIOWGT is bein changed from DISABLE to ENABLE. MODULES/MACROS: DSNTINST DSN6SPRM DSNTIDXA DSNTIJUZ n.v. PK78958(HIPER)/UK45353-v9(F904) -- Superceded By PK85985(PE)/UK47287(F906) Disable REORG TABLESPACE and LOAD REPLACE from converting a COMPRESS YES table space or partition from Basic Row Format (BRF) to Reordered Row Format (RRF) in DB2 9 NFM. MODULES/MACROS: DSNUGRSP DSNUGRST DSNURFBR DSNURFIT DSNURLAP DSNURSCN DSNURSWD DSNURWI DSNURWT PK78959/UK45881(PE)-v9 (F905) -- SUPERSEDED BY: PK85985/UK47287(PE)-v9 (F906) >>PM12302(PE/y)/UK58993-v9 << see above REORG SERVICEABILITY ENHANCEMENT. MODULES/MACROS: DSNIRFNX DSNIRLPG DSNUCASA DSNUGRSP DSNUGRST DSNURFBR DSNURFIT DSNURLAP DSNURSCN DSNURSWD DSNURWI DSNURWT PK79327/UK44899-v9 (F904) Set DB2 member ineligible for randomized group attach processing. MODULES/MACROS: DSN@ZP DSNDQWPZ DSNTINST DSN6GRP DSNWZP DSN3AMI2* DSN3CHGZ DSNTIDXA DSNTIJUZ PK79327/UK44899-v9 (F904) Set DB2 member ineligible for randomized group attach processing. MODULES/MACROS: DSN3ID00 PK85640/UK48559-v9 ( F908) INCORROUT NFM SYSIBM.SYSPACKAGE.DISTRIBUTE = '00' IS NOT A CHAR(1) SYSIBM.SYSPACKAGE.LASTUSED = '0000-00-00' IS NOT A VALID DATE MODULES/MACROS: DSNTBSPL PK85985(HIPER)/UK47286-v8,UK47287(PE)-v9 (F906) >>PM12302(PE/y)/UK58993-v9 << see above A DB2 V8 or V9 LOAD RESUME YES into a compressed tablespace that has more than 256 parts may corrupt populated parts if any of the parts less than 257 are empty, and the LOAD RESUME of is at the tablespace level (not using INTO TABLE PART nnn). MODULES/MACROS: DSNGDART DSNGDBDC DSNGDCOB DSNIPTYM DSNUKDFK DSNUKSCT DSNURBX DSNURWI ,..DSNXIAB4 DSNXICX2 v8 ,..DSNXISB5 v9 PK64485/UK37636-v9 (F808) The DSNTIJNF job failed to put DB2 subsystem to new function mode (NFM) even after successful completion of the DSNTIJEN job. MODULES/MACROS: DSNUECMJ PK71531/UK40060-v9 (F810) MULTIPLE ABENDS ON WORKFILES AFTER MIGRATION/FALLBACK CM AND V8 NFM - OBDFINPS IS SETUP WITH A WRONG VALUE MODULES/MACROS: DSNGDCPD PK72214/UK46092-v8,UK46093-v9 (F905) Unexpected DSNU778I and SQLCODE -148 when running CATMAINT or CATENFM utility. MODULES/MACROS: DSNTIJP9 v8 , DSNUECSE DSNTIJPM v9 PK77228/UK46734-v8,UK46735-v9 (F906) Changed installation job DSNTIJRA, DSNTIJSG, DSNTIJEN, DSNTIJOC and DSNTIJPM. MODULES/MACROS: DSNTIDXA DSNTIJNE DSNTIJRA DSNTIJSG DSNTINST DSNTINS1 , .. DSNTIJP9 v8 .. DSNTINS3 DSNTIPL DSNTIJEN DSNTIJPM v9 PK85068/UK53249(AI)-v8,UK53250(AI)-v9 (F001) Migrate Explain table. MODULES/MACROS: DSNTIJPM DSNTIJXA DSNTIJXB DSNTIJXC DSNTXTA DSNTXTB , .. DSNTIJP9 v8 PK93084/UK51594-v8,UK51595-v9 (F911) Changed installation job DSNTIJMV and DSNTIJSG. MODULES/MACROS: DSNTIJSG DSNTINS1 n.v. PK95022(HIPER)/UK51772-v9 (F911) Error occurred when customer reverted from V9 NFM to V9 CM* and index compression was active (COMPRESS YES). MODULES/MACROS: DSNB5RAP DSNB5RDP DSNIFOI DSNKFRMT PM11897(PE/y)/UK56789-v9 (F005) After migration to DB2 V9 NFM an SRB (service request block) loop occurs when running sample job DSNTEJ1, job step PH01S13. MODULES/MACROS: DSNTINST DSNTINS1 DSNTINS2 DSNTINS3 DSNTEJ1 DSNTIJNX DSNTIJOC DSNTIJOM DSNTIJOS 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 PM70285/RA10 UK81944,R910 UK81945 - UP12/10/10 (F210) INSERT SQL ABENDS WITH 00C90101 DSNKINSL:5033 BECAUSE INDEX ROW ON A PAGE CREATED BY SPLIT IS NOT ROLLED BACK AT ABORT. MODULES/MACROS: DSNICLDR .
Local fix
N/A
Problem summary
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
II14464
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
2009-08-13
Closed date
Last modified date
2013-02-01
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:
01 February 2013