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 Feb 10,2015)
    .
      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
    .
    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

    2015-08-08

  • 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



Document information


More support for:

z/OS family

Software version:

000

Operating system(s):

MVS

Reference #:

II14660

Modified date:

2015-08-08

Translate my page

Content navigation