II14474: DB2 V8 MIGRATION/FALLBACK INFOAPAR TO/FROM DB2 10

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 V8 MIGRATION/FALLBACK INFOAPAR TO/FROM DB2 10
    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 too 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.ibm.com/systems/z/os/zos/features/smpe/fix-category.h
    tml
    FOLLOWING PTFS ARE FOR DB2 10 MIGRATION:   (Updated 07/23/14)
      NOTE: * Info APARs II14401 and II14464 document V8 to DB2 9
              migration and fallback considerations.
            * Info APARs II14477, II14564, & II14637 document V9 to
              DB2 10 migration and fallback considerations.
            * RSU is CST Quarterly Report (RSU1406) service thru
              March 2014//PE Fixes, Hipers, Supersedes thru May 2014
    http://www-03.ibm.com/systems/z/os/zos/support/servicetest/
    .....
    
      PK56922/UK61199 UP10/10/20 (F010)
        SPE Migration and fallback from DB2 V8 (R810). In a Data
        Sharing environment, required for coexistence of DB2 V8 and
        DB2 10.  This APAR prereqs other SPE APARs.
      PK61766/UK44315 UP09/03/12 (F903)
        Changes to early code to provide compatability with DB2 10.
      PK64045/UK54507 UP10/0311  (F003)
        Help eliminate private protocol to prepare for DB2 10.
      PK74494(PE/y),UK43330-v8  (F902)  INCORROUT
        INVALID DATE '0000-00-00' SAVED INTO LASTUSED OF SYSPACKAGE
        / SYSPLAN.  Valid date is '01/01/0001' till V10.
        MODULES/MACROS:  DSNTBCM1 DSNTBCM2
      PK79925/UK51238 UP09/11/05 (F911)
        BIND with COLLID to convert from plans with DBRMs to plans
        with packages.
      PK85068/UK53249 UP10/01/20 <F001>
        Put DB2 explain tables into current release format.
        Migrate EBCDIC explain tables to Unicode.
      PK85956/UK55004 UP10/03/25 (F003)
        SPE allow DB2 10 format explain tables in DB2 V8.
      PK87280/UK57463 UP10/06/16 (F006)
        SPE early code to support DB2 10.
      PK87281/UK57461 UP10/06/16 (F006)
        SPE early code.
      PK92339/UK51678 UP09/11/18 (F911)
        Disallow private protocol with new parameter,
        PRIVATE_PROTOCOL NO
      PM04680/UK54988 UP10/03/24 (F003)
        SPE prevent active threads in migration to DB2 10.
      PM04968/UK56305 UP10/05/07 (F005)
        Premigration checking job DSNTIJPM.
      PM08102/UK56211 UP10/05/05 (F005)
        SPE virtual catalog.
      PM09148/UK57860 UP10/06/25 (F006)
        NEWFUN(V8) option in precompiler.
      PM10227/UK56246 UP10/05/05 (F005)
        Utility support.
      PM12572/UK56822 UP10/05/26 (F005)
        EDM support on plans.
      PM14377/UK57953 UP10/06/30 (F006)
        DSNG007I message.
      PM14630/UK57617 UP10/06/18 (F006)
        DSNISEL abended, adding code to support data versioning.
      PM15965/UK63315 RA10,UK63316 R810 UP11/01/05 (F101)
        Premigration checking job DSNTIJPM.
      PM19523/UK60216 UP10/09/18 (F009)
        Changes in support of future functions.
      PM22091/UK65974 UP11/03/26 (F103)
        New DB2 stored procedure SYSPROC.ADMIN_INFO_SYSLOG.
      PM23243/UK59282 UP10/12/29 (F012)
        Change the output of the DISPLAY GROUP command.
      PM24808/UK63971 UP11/02/02 (F102)
        DB2 install changes.
      PM29831/UK65988 RA10 UP11/03/26 (F103)
        DB2 installation fixes.
      PM30297/UK66833 UP11/05/04 (F105)
        Optional job to check catalog and directory indexes after
      PM34521/UK65660 UP11/03/11 (F103)
        Installing new DB2 10 system failed caused by DSN5OEXP.
      PM40872/UK69945 UP11/08/04 (F108)
        PREPARATION FOR APAR PM42237
      PM42237/UK69950 UP11/08/04  (F108)
       (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, R810 UK73141 - UP11/11/08  (F111)
        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. NSTALLATION CHANGES: DSNWZP, DSNTXAZP, DSNTIJTC,
      MODULES/MACROS:  DSN@XAZP DSNTXAZP
      PM48933 RA10 PSY UK75341 - UP12/01/26  F201
      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.
      PM56845/UK77500 V10 - UP12/04/17  (F204)
        PROVIDE OPTION FOR OPTIMIZE FOR 1 ROW TO ALLOW SOME SORT
        ACCESS PATHS
      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.
      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
    - PM58575/UK77742 RA10 CL12/05/02  F204
    - PM62572/UK78307 RA10 CL12/05/02  F204
    - PM58012/R910 UK78145,R810 UK78144 - UP12/05/09 (F205)
        With PM30991, fallback from V10 CM8 to V8 NFM, may get
        abends with abend04e RC00E40119 in DSNUYAS2.
    - PM62119/RA10 UK80924,R910 UK80925 - CL12/08/23
        ABEND04E RC00E70014 AT DSNXLDDL OFFSET 2234 accessing
        a catalog index during migration.
    .
    Changes in V8, V9, V10:
    DSNTEJ2A PREPUNL for DSNTIAUL has added AMODE & RMODE parms
      if missing could result in 0C4 RC11 DSNTIAUL
    .
    - 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
    - PM72784/RA10 UK83174 - UP12/11/20  F211
        ABEND04E 00C90216 DSNIOST2:5380 on DML after ALTER TABLE ADD
        COLUMN executed during DB2 10 from CM8 or ENFM8.
      MODULES:  DSNXIAB3
    - PM66287/UK82732 RA10 CL12/12/04  F211
       Ensure RTS and AUTOBIND do not interfere with Online CATMAINT
      MODULES/MACROS:  DSNGERTS DSNIRTST DSNTBAB2
    - PM70914/RA10 UK91338 - UP13/02/16  F302
      CATMAINT MSGDSNU778I DSNUEXDL - ERROR PROCESSING SQL STATEMENT
      DSNXISB5 SQLCODEM4732
      MODULES/MACROS: DSNUGUVR DSNTIJPM
    - PM81913/RA10 UK91829 - UP13/03/07  F303
      CATMAINT/CATENFM PROCESSING MAY BE IMPACTED IF CATENFM
      HALTENFM IS USED INCORRECTLY
      MODULES/MACROS:  DSNUECMI DSNUECM0 DSNUECM4
    - PM81189/R910 UK93991, RA10 UK93990  - UP13/05/nn F30n
      MSGDSNT217I ON REBIND PACKAGE SWITCH AND NO ROW IN
      SYSIBM.SYSPACKCOPY IN V10 NFM FOR PACKAGE THAT USES CGTT.
      Unnecessary invalidation of these packages during V10 ENFM.
      V9 - DSNTIJPA, V10 DSNTIJPM , MODULE: DSNXOTL
    - UI14060/PI07855 PE/y Hiper  CL14/02/05  F401
      DSNTIJEN FAILS DSNU777I REORG ENFM WITH BROKEN DATABASE
      DSNU016I ABEND04E 00E40600 INVOLVING LOB MERGE with DBD
      anywhere in the VSAM name.  DB2MIGV10/K  MODULE: DSNUECML
    ****************************************************************
    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 &
    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 contig-
    uous 64-bit above 2GB bar common storage for each DB2 subsystem.
    If not enough contiguous storage for HVCOMMON & HVSHARE exists,
    the DB2 member will abend - S0DC2 RC8A001721 the first starting.
    ****************************************************************
    z/OS related APARs/PTFs:
     - DFSMS Media Manager (Comp ID=5695DF126)
      OA35057(HIPER, DATALOSS)/UA58935 (RA10)  RSU1103
                               UA58936 (RB10)  RSU1103
                               UA58937 (RC10)  RSU1103
       -- DB2 loss of new updated records on disk for 32K pages.
    
     - Real Storage Manager (Comp ID=5752SC1CR)
      OA24441(HIPER)/UA41579 (HBB7750 z/OS V1.10)  RSU0807
      OA25169(HIPER)/UA42522 (HBB7750 z/OS V1.10)  RSU0809
      OA25485(SPEC/ATTN)/UA42805 (HBB7750 z/OS V1.10)  RSU0812
      OA27799(HIPER)/UA45772 (HBB7750 z/OS V1.10)  RSU0903
      OA31116(SPEC/ATTN)/UA57252 (HBB7750 z/OS V1.10)
                         UA57253 (HBB7760 z/OS V1.11)
                         UA57254 (HBB7770 z/OS V1.12)
      OA32001/UA54896 (HBB7750 z/OS V1.10)  RSU1009
              UA54897 (HBB7760 z/OS V1.11)  RSU1009
              UA54898 (HBB7770 z/OS V1.12)  RSU1009
      OA32599(HIPER)/UA55662 (HBB7750 z/OS V1.10)  RSU1008
                     UA55663 (HBB7760 z/OS V1.11)  RSU1008
                     UA55664 (HBB7770 z/OS V1.12)  RSU1008
      OA32668/UA56051 (HBB7750 z/OS V1.10)  RSU1008
              UA56052 (HBB7760 z/OS V1.11)  RSU1008
              UA56053 (HBB7770 z/OS V1.12)  RSU1008
      OA33920(HIPER)/UA57363 (HBB7750 z/OS V1.10)  RSU1011
      OA34099(HIPER)/UA57378 (HBB7750 z/OS V1.10)  RSU1011
      OA34191(HIPER)/UA57607 (HBB7750 z/OS V1.10)  RSU1012
                    /UA57608 (HBB7760 z/OS V1.11)  RSU1012
                    /UA57609 (HBB7770 z/OS V1.12)  RSU1012
    
     - Supervisor (Comp ID=5752SC1C5)
      OA28324(SPEC/ATTN)/UA50352 (HBB7750 z/OS V1.10) RSU1003
      OA31889/UA54042(PE) (HBB7750 z/OS V1.10)  RSU1009
                          PEd by OA33678/UA56824
              UA54043(PE) (HBB7760 z/OS V1.11)  RSU1009
                          PEd by OA33678/UA56825
      OA32071/UA57211 (HBB7750 z/OS V1.10)
              UA57212 (HBB7760 z/OS V1.11)
              UA57213 (HBB7770 z/OS V1.12)
      OA33106/UA56172 (HBB7750 z/OS V1.10)
              UA56173 (HBB7760 z/OS V1.11)
              UA56174 (HBB7770 z/OS V1.12)
      OA33678(PE)/UA56824 (HBB7750 z/OS V1.10)
                  UA56825 (HBB7760 z/OS V1.11)
                  UA56826 (HBB7770 z/OS V1.12)
    -----------------------------------------------------------
    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

    II14474

  • 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

    2010-02-22

  • Closed date

  • Last modified date

    2014-07-23

  • 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



Rate this page:

(0 users)Average rating

Document information


More support for:

z/OS family

Software version:

000

Operating system(s):

MVS

Reference #:

II14474

Modified date:

2014-07-23

Translate my page

Machine Translation

Content navigation