IBM Support

II14564: DB2 9 MIGRATION/FALLBACK INFOAPAR TO/FROM DB2 10 (II) (CONTINUED FROM II14477)

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

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