APAR status
INTRAN
Error description
DB2 11 Migration Info APAR . FIX CATEGORIES IBM.Migrate-Fallback.DB2.V11 and IBM.Coexistence.DB2.SYSPLEXDataSharing are now used to represent fixes that allow prior releases of DB2 to migrate to or fall back from DB2 V11 and Fixes that enable to coexist when in data sharing mode respectively. . See more information on FIXCAT at External Site -- http://www.ibm.com/systems/z/os/zos/features/smpe/fix-category.h tml Internal Site -- http://w3.pok.ibm.com/~smpdev/fixcat/radarfc.keyword.xml . FOLLOWING PTFS ARE FOR DB2 11 MIGRATION and/or 10 FALLBACK AS OF 02/10/2015 and MAY NOT BE COMPLETE. Please use FIXCAT to get a complete list. The list below will not be updated. NOTE: * RSU is CST Quarterly Report (RSU1502) is Based upon the previous quarter. This addendum contains PE resolutions or HIPER Security/Integrity/Pervasive PTFs and their associated requisities and supersedes through Jan 2015. http://www-03.ibm.com/systems/z/os/zos/support/servicetest/ ..... . PM31841/RA10 UK96357 PE'd, fix is PI28150/UI24847 HDBAA10 NFM requirement for Fallback to V10 from V11. MODULES/MACROS: DSNARIB DSNGEDLC DSNIRTSX DSNRRPRC DSNRRSBS DSNTSTR2 DSNUECM2 DSNUEXDB DSNUGMAP DSNXCATL DSNXCOBC DSNXKFUN DSNXLDBD DSN7GCMD . PM89117/RA10 UK95677 CL13/07/09 V10 NFM features to next release. Module: DSNIRTSX . PM94714/RB10 UK97919 CL13/10/11 ABEND04E RC00E40601 IN DSNUEXDL+1508 DURING JTC/CATMAINT JOB ON SYSTSQRY The problem is caused by excessive plan hint lookup into SYSIBM.SYSQUERY table during migration. Module: DSNXOD0P . PM94057/RA10 UK98219 CL13/10/20 NEW FUNCTION FOR PREMIGRATION CHECKOUT MODULES: DSNTINS1 DSNTIJPB . PM93782/RB10 UK97159 CL13/10/03 PDO= 1338 DSNTRIN FAILS WITH SQLCODE -811 WHEN CHECKING THE COLUMN_SIZE IN SYSIBM.SQLTYPEINFO WITH TYPE_NAME='XML'. MODULES/MACROS: DSN@RIN DSNTRIN . PM94213/RB10 UK98117 CL13/10/17 PDO= 1342 INCORROUT REMOVE NEW FORMAT DDL FOR DSNRLMTXX TABLE FROM DSNTIJSG WHEN TAILORED FOR MIGRATION TO DB2 11 CONVERSION MODE. -START RLIMIT issues. New DDL in DSNTIJNX/DSNTIRL. MODULES/MACROS: DSNTINS1 DSNTINS3 DSNTIJNX . PM90893/RB10 UK98164 CL13/10/18 PDO= 1343 INCORROUT CHANGE DEFAULT VALUE OF ZPARM IX_TB_PART_CONV_EXCLUDE FROM NO TO YES PROBLEM CONCLUSION: IBM recommends that all current DB2 9 for z/OS, DB2 10 for z/OS and DB2 11 for z/OS customers who use IX_TB_PART_CONV_EXCLUDE=NO now convert to IX_TB_PART_CONV_EXCLUDE=YES. Review ++HOLD actions. MODULES/MACROS: DSN@XAZP DSN6SPRM DSNTXAZP DSNTIDXA DSNTIDXB DSNTIJUZ . PM89655/RB10 UK98189 CL13/10/18 PDO= 1343 NF RESTRICTIONS FOR INDEX-CONTROLLED PARTITIONED TABLE SPACES DB2 parameter, PREVENT_NEW_IXCTRL_PAR introduced. (1) Update customized copies of DB2 installation CLIST members (2) Update your customized copy of job DSNTIJUZ (3) Update private copies of the DSNTIDxx CLIST input member (4) Update the package for DSNTXAZP Update to install panel DSNTIP71. Review ++HOLD actions. MODULES/MACROS: DSN@XAZP DSNDQWPZ DSNDSPRM DSNTINST DSNTIP71 DSN6SPRM DSNTXAZP DSNWZIFB DSNXIATB DSNXICIX DSNTIDXA DSNTIDXB DSNTIJUZ . PM92730/RB10 UK98196 CL13/10/18 PDO= 1343 INCORROUT MISCELLANEOUS DB2 FOR Z/OS INSTALLATION FIXES referencing: DSNTIJMV, Clist with (DSNTESC), DSNTIPB presents panel DSNTIP61 vs DSNTIP62, DSNTIJNH -> DSNTIJEN, DSNTINSV, DSNTEJ67, DSNTIJCB, DSNTESR , V11 DSNTIJMV--CLIST update, panel DSNTIPRL, DSNTIJCB. Review ++HOLD actions. MODULES/MACROS: DSNTINST DSNTINSV DSNTINS1 DSNTIPB DSNTEJ67 DSNTESR DSNTIJCB DSNTIJMV DSNTIJNF DSNTIJNH . PM96764/RB10 UK98203 CL13/10/18 PDO= 1343 NEW FUNCTION CHANGE TO THE DEFAULT VALUE OF RBALRSN_CONVERSION KEYWORD WHEN THE ZPARM UTILITY_OBJECT_CONVERSION IS SET TO NOBASIC MODULES/MACROS: DSNUCINT DSNURFIT DSNURWI . PM94213/V11 UK98117 SB13/10/01 F310 INCORROUT REMOVE NEW FORMAT DDL FOR DSNRLMTXX TABLE FROM DSNTIJSG WHEN TAILORED FOR MIGRATION TO DB2 11 CONVERSION MODE MODULES/MACROS: DSNTINS1 DSNTINS3 DSNTIJNX . PM94714/V11 UK97919 SB13/09/25 F310 ABEND04E RC00E40601 DSNUEXDL+1508 DURING JTC/CATMAINT JOB ON SYSTSQRY MODULES/MACROS: DSNXOD0P . PM96764/V11 UK98203 SB13/10/03 F310 CHANGE TO THE DEFAULT VALUE OF RBALRSN_CONVERSION KEYWORD WHEN THE ZPARM UTILITY_OBJECT_CONVERSION IS SET TO NOBASIC MODULES/MACROS: DSNUCINT DSNURFIT DSNURWI . PI04986/RB10 UI15964 Cancelled -> AE UI17091/PI13996 CL14/06/03 AUXILIARY STORAGE SHORTAGE HANG MAY OCCUR FOR A VERY LARGE QUERY INVOLVING A VERY LARGE NUMBER OF TABLES. MODULES: DSNXOSJO DSNXOTS . UI16235 V10,UI16236 V11,UI16237 V9/PI09041 CL14/03/19 F404 REPAIR DBD TEST UTILITY ABENDS WITH 04E-00640600 WHEN DATABASE TESTED HAS TABLE REFERERENCED BY INVALID TRIGGER. MODULE: DSNTIJPB DSNTIJPM . UI19815 V10, UI19816 V11 /PI11316 CL14/07/21 F408 NF DB2 10 and 11 for z/OS users of user-created catalog indexes, 00D70014 and 00E50013 MODULES/MACROS: DSNTIJPA DSNTIJPB DSNTIJPM DSNXIAIX DSNXICX2 . UI17483 V10,UI17484 V11 /PI13733 CL14/06/03 F405 MIGRATION DB2 TO V10NFM OR V11 COULD HIT ABEND 04E-00E40601 IN DSNUTILA.DSNUEXDL+14EE MODULES: DSNGDART . UI17091 V11/PI13996 AE PI04986 FIX COMPLETION CL14/04/15 AE PI04986 FIX COMPLETION MODULES/MACROS: DSNXOSJO DSNXOTS . PI26218/V10-UI23171 V11-UI23172 CL15/01/02 F412 Orphaned rows in SYSIBM.SYSVIEWS, etc after running CATMAINT provided for PM88612 OR PI08928 . PI27220/V10-UI24100 V11-UI24101 CL15/01/07 F501 ABEND04E RC00E40601 DSNUEXDL+14EE WHEN RUNNING A CATMAINT JOB involving CREATE AUX Catalog Tables. Module: DSNXICB7 . PI28150/RA10 UI24847 CL15/01/30 F502 NFM requirement for Fallback to V10 from V11. ABEND04E RC00E70100 in V10 USING REGENERATING SQLPL CREATED in V11. Module: DSNXISB in V10 . PI28945/RB10 UI24327 CL15/02/03 F501 REBIND TRIGGER PACKAGE ON V9/V10 PACKAGE CAN TURN OFF PLANMGMT OR GET DSNT216I FOR PLANMGMT(BASIC|EXTENDED) ON V11. Module: DSNTBRB2 . PI29707/RB10 UI25067 CL15/02/25 F502 Ensures V10 function is available in V11. Modules: DSNUGPRT DSNUFCMR DSNUGTTR DSNUGTDS . PI39053/RB10 RC00C200EA DURING CATALOG REORG . PI37869 V10 DSNTIJPB report27, DSNTIJPM report39, V11 DSNTIJPM report39 premigration query modified to have correct result . PI43662 DSNTIJEN blocked by accelerator heartbeat monitor service task 033.ACCEPKG1 . PI43916/RB10 DSNTIJEN BLOCKED BY THREADS HOLDING DBD LOCKS ON CATALOG and DIRECTORY . PI43662/UI30100 DSNTIJEN IS TIMED OUT BY THE ACCELERATOR PI48181/UI31285 DSNJ122I IS ISSUED BY DSNJCNVT DSNTIJCB PI51674/UI33437 DATA SHARING JOIN LRSN CORRUPTION PI52768/UI34194 ABEND04E RC00E80053 FROM RESTARTING DB2 Migration Fixcat KEYWORD: DB2MIGV11/K
Local fix
N/A
Problem summary
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
II14660
Reported component name
PB LIB INFO ITE
Reported component ID
INFOPBLIB
Reported release
000
Status
INTRAN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2012-10-09
Closed date
Last modified date
2016-01-26
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:
26 January 2016