II14660: DB2 10 MIGRATION/FALLBACK INFOAPAR TO/FROM DB2 11

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

  • 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
    (Updated on July 23,2014)
    .
      NOTE:  * RSU is CST Quarterly Report (RSU1404) service thru
      end of Mar 2014 not already marked RSU.  PE resolutions and
      HIPER Security/Integrity/Pervasive PTFs and their associated
      requisities and supersedes through May 2014.
    http://www-03.ibm.com/systems/z/os/zos/support/servicetest/
    .....
    .
    PM31841/RA10 UK96357  CL13/09/03   PDO= 1334 or F308
      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
    .
    UI  ptf builds /PI11316      CL14/07/21 F40n
      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
    .
    .
    .
    .
    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

  • Submitted date

    2012-10-09

  • Closed date

  • Last modified date

    2014-07-24

  • 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 #:

II14660

Modified date:

2014-07-24

Translate my page

Machine Translation

Content navigation