APAR status
INTRAN
Error description
5740XYR00 RA10 DB2 9 MIGRATION/FALLBACK INFOAPAR TO/FROM DB2 10 (II) . . FIX CATEGORIES IBM.Migrate-Fallback.DB2.V10 and IBM.Coexistence.DB2.SYSPLEXDataSharing . KEYWORD DB2MIGV10/K are now used to represent fixes that allow prior releases of DB2 to migrate to or fall back from DB2 V10 and Fixes that enable to coexist when in data sharing mode respectively. . See more infomation on FIXCAT at http://www-03.ibm.com/systems/z/os/zos/smpe/fixcategory.html . . FOLLOWING PTFS ARE FOR DB2 10 MIGRATION: (Updated on Feb 16, 2012) NOTE: * Info APARs II14401 and II14464 list V8 to DB2 9 migration and fallback considerations. * Info APAR II14474 lists V8 to DB2 10 migration and fallback considerations. * The current RSU is CST 4th Quarter 2011 1st Addendum (RSU1201) dated Feb/06/2012. (...continued from II14477 and continued in II14637) . PM19844/UK60722 UP10/09/29 (F009) SUPPORT ENHANCEMENT FOR THE NEW HEADER VERSION 2 OF SPATIAL FUNCTIONS. . PM21557/UK60687 UP10/10/13 (F009) Support new function in V10. . PM22091/UK65974 RA10 UP11/03/26 (F103) UK65975 R910 UP11/03/26 (F103) New DB2 stored procedure SYSPROC.ADMIN_INFO_SYSLOG. . PM23243/UK59283 UP10/12/29 (F012) Change the output of the DISPLAY GROUP command. . PM24808/UK63971 RA10 UP11/02/02 (F102) UK63972 R910 UP11/02/02 (F102) DB2 install changes. . PM27949/UK66360 RA10 UP11/02/02 (F104) UK66362 R910 UP11/02/02 (F104) Abend04E RC00C200D8 DB2 hang during DB2 shutdown. . PM29831/UK65988 RA10 UP11/03/26 (F103) UK65990 R910 UP11/03/26 (F103) DB2 installation fixes. . PM30297/UK66833 UP11/05/04 Optional job to check catalog and directory indexes after ENFM. . PM30593/UK65445 UP11/03/22 (F103) Message IRA201E CRITICAL AUXILIARY STORAGE SHORTAGE received on LPAR containing DB2 for z/OS V10. . PM31813/UK69055 (F107) Abend04E 00E2000C DSNGEFLC.DSNSVSVB+0AAA occurred because EDM SKPT RTSPOOL is full. . PM34521/UK65660 UP11/03/11 (F103) Installing new DB2 10 system failed caused by DSN5OEXP. . PM40872/UK69946 UP11/08/04 PREPARATION FOR APAR PM42237 . PM42237/UK69950 UP11/08/04 (This is V10 APAR but required to review ++HOLD or APAR closing text before proceeding with PM40872) An application using IBM Data Server Driver for JDBC and SQLJ Type 4 Connectivity calls a stored procedure with OUT or INOUT parameters on a DB2 for z/OS data sharing group in V9/V10 or V8/V10 coexistence mode and receives incorrect data output results or encounters various java.lang exceptions, including: - ArrayIndexOutOfBoundsException - NullPointerException - StringIndexOutOfBoundsException . PM45187/RA10 UK73140 (F111) R810 UK73141 R910 UK73142 Notify exit issued ABEND04E RC00C90101 DSNIQISE ERQUAL5001 when multiple notify exits executed DSNIQISE concurrently. . PM47246/UK74766 v10, UK74767 v8,UK74768 v9 UP11/12/31 (F112) MISC DB2 INSTALLATION CHANGES: DSNWZP, DSNTXAZP, DSNTIJTC, DSNTIJPA. MODULES/MACROS: DSN@XAZP DSNTXAZP . PM48933 RA10 PSY UK75341 UP12/01/26 F201 R810 PSY UK75342 UP12/01/26 R910 PSY UK75343 UP12/01/26 All users of DSNTXAZP, a tool for refreshing a DB2 CLIST input (DSNTIDxx) member: EVERY MISSING ROW FROM INPUT XAINPUT A ROW WITH THE DEFAULT VALUE WILL BE ADDED INTO XAOUTPUT. . PM56483/UK76197 v10,UK76198 v8,UK76199 v9 UP12/03/01 (F202) ZPARM DISALLOW_DEFAULT_COLLID SHOWS WRONG VALUE, IT WILL ALWAYS HAVE A VALUE NO. MODULES/MACROS: DSNDQWPZ DSNWZIFA . PM56722/UK74411 (F202) DSNTRIN INCORRECTLY INDICATES STORED PROCEDURE ADMIN_INFO_SQL REQUIRES NEW FUNCTION MODE. Replacement of PLI8/Service SQL (problem determination doc), so either apply apar or create ADMIN_INFO_SQL for V10. . PM62572/UK78307 RA10 CL12/05/02 F204 Undetected lock contention failure during the switch phase of the ENFM REORG step MODULES/MACROS: DSNGEDLC DSNURSWD . PM58575/UK77742 RA10 CL12/05/02 F204 Auto bind triggers deadlock with RTS ... on SYSIBM.SYSPACKAGE table. MODULES/MACROS: DSNTBAB2 . PM58012/R810 UK78144 (F205) R910 UK78145 (F205) With PM30991, fallback from V10 CM8 to V8 NFM, may get abends with abend04e RC00E40119 in DSNUYAS2. . PM62119 / RA10 UK80924 CL12/08/23 R910 UK80925 CL12/08/23 ABEND04E RC00E70014 AT DSNXLDDL OFFSET 2234 accessing a catalog index during migration. . PM66287/UK82732 RA10 CL12/12/04 F211 Ensure RTS and AUTOBIND do not interfere with Online CATMAINT MODULES/MACROS: DSNGERTS DSNIRTST DSNTBAB2 . . . . ---------------------------------------------------------------- Before migrating to V10, review the settings you use for the following DB2 subsystem (DSNZPxxx) parameters in DSN6SPRM and ensure they are set as recommended below. However, seek IBM advice by PMR before changing the setting of any of these parameters to values that differ from their defaults: . (1) OPTIOWGT: Use of OPTIOWGT=ENABLE is the default in V9 and V10. OPTIOWGT=ENABLE causes DB2 to choose SQL access paths that accurately reflect ongoing improvements in System z processor speeds. Use of OPTIOWGT=DISABLE causes DB2 to use a traditional cost balance formula that can lead to sub-optimal performance of queries because it does not account for these improvements. . (2) OPTIXIO: Use of OPTIXIO=ON is the default in V8, V9, and V10. OPTIXIO=ON specifies that DB2 is to provide stability to I/O costing for queries, with less sensitivity to bufferpool sizes. Use of OPTIXIO=OFF can cause access path selection to be heavily influenced by object size and bufferpool sizes. . (3) OPTXQB: Use of OPTXQB=ON is the default in V9 and V10. OPTXQB=ON enables global query block optimization for SQL with subqueries. Use of OPTXQB=OFF can inhibit optimization of such queries. . (4) STATCLUS: Use of STATCLUS=ENHANCED is the default in V9 and V10. STATCLUS=ENHANCED causes RUNSTATS to collect clustering statistics using an algorithm that more accurately aligns with dynamic prefetch which is relied upon for data access via an index in V9 and V10. Use of STATCLUS=STANDARD causes RUNSTATS to collect clustering statistics as it did in DB2 V8, which can cause the DB2 optimizer to incorrectly estimate when dynamic prefetch may be invoked in V9 and V10. . REAL STORAGE CONSIDERATION Ensure that you have defined a high enough value for HVSHARE and HVCOMMON to satisfy all requests on this LPAR. DB2 Version 10 requires 128GB of contiguous 64-bit shared private storage above the 2GB bar for each DB2 subsystem . DB2 requires 6GB of contiguous 64-bit above the 2GB bar common storage for each DB2 subsystem. If not enough contiguous storage for HVCOMMON and HVSHARE exists, the DB2 member will abend with S0DC2 RC8A001721 at the first starting. . PM59631/UK80303 R910 UP12/08/01 P (F207) ABEND04E RC00F30113 IN DSN3UR00 WHEN IPLING Z/OS AND A DB2 IEFSSN MEMBER CONTAINS A SUBGROUP ATTACHMENT . PM81189/UK93990 RA10,UK93991 R910 CL13/06/04 F305 Associated with the CGTT set of problems to be corrected, no row in SYSIBM.SYSPACKCOPY IN V10 NFM that uses CGTTs. MODULES/MACROS: DSNXOTL DSNTIJPM . ---------------------------------------------------------------- z/OS related APARs . Allocation (COMPID=5752SC1B4) . OA36101(HIPER OVERLAY) UA60221(770) UA60222(780) ----------------------------------------------------------- For COMPIDS getting GIM69142I msgs, SMP/e Standards for CSI. Define Cluster issue in DSNTIJAA, REALLOCATE/REPRO the CSI's defined by the DB2 supplied sample defintions and change VSAM Cluster Allocation to conform with SMP recommended values as specified in SAMPLIB Member GIMSAMPU. (FIN) . DEFINE CLUSTER - (NAME(#globalcsi) - FREESPACE(10,5) - KEYS(24 0) - RECORDSIZE(24 143) - SHAREOPTIONS(2) - UNIQUE - VOLUMES(volserc) - ) - DATA - (NAME(#globalcsi.DATA) - > CONTROLINTERVALSIZE(8192) - CYLINDERS(30 2) - ) - INDEX - (NAME(#globalcsi.INDEX) - > CONTROLINTERVALSIZE(4096) - CYLINDERS(5 1) - ) . & removal of IMMBED. -------------------------------------------------------------
Local fix
N/A
Problem summary
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
II14564
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
2011-05-17
Closed date
Last modified date
2015-01-13
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:
13 January 2015