IBM Support

II14401: DB2 V8 MIGRATION/FALLBACK INFOAPAR TO/FROM DB2 9

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

  • FIX CATEGORY (FIXCAT) for the fixes that allow the prior release
    of DB2 to migrate to or fall back from DB2 V9 is
    IBM.Migrate-Fallback.DB2.V9
    The keyword for this is DB2MIGV9/K
    .
    See the detail on FIXCAT at
    http://www-03.ibm.com/systems/z/os/zos/smpe/fixcategory.html
    .
    .
                     5740XYR00 R910
    DB2 V8 MIGRATION/FALLBACK INFOAPAR TO/FROM DB2 9
    
    FOLLOWING PTFS ARE FOR DB2 9 MIGRATION:
    (Last Updated on  02/04/2011)
    Key:  n.v. = not visible under a Diagnose Display MEPL
          *    = quick module check under Diagnose Display MEPL
    
    Please pay special attention to all ++Hold Actions.
    ---------------------------------------------------------------
      PK11129(PE/y)/UK90008-v8 (F610)
        Toleration of fallback from DB2 Version 9 (R910). In a Data
        Sharing environment, required for coexistence of V8R1 and
        V9R1.
    MODULES/MACROS:   DSNDRIB  DSNACA70 DSNARA70 DSNARIB  DSNECP12
    DSNGEDLC DSNHDECP DSNRRPRC DSNRRSBS DSNTSTR2 DSNUECM2* DSNXCATL
    DSNXLDBD DSNXLVCM DSNX9RIB
    
      PK31841/UK23131-v8,UK23132-v9 (F704)
        Fix errors in the DB2 V9 premigration job DSNTIJPM that is
        shipped with DB2 V9.  Also provide V9 premigration job
        DSNTIJP9 that is shipped with DB2 V8.  These jobs provide a
        convenient way for current DB2 for z/OS V8 customers to run
        health checks in preparation for migration to DB2 V9.1 for
        z/OS.
    MODULES/MACROS:  DSNTIJP9 DSNTINS1 v8, DSNTIJPM v9          n.v.
    
      PK33664(PE/y)/UK22035-v8 (F702)
        In V8/V9 coexistence or fallback from V9 to V8 situations,
        different abends may occur in the V8 DB2 member:
          1. Abend04E RC00E40317 in DSNUTILA.DSNUGABN+0692
          2. Abend04E RC00E30086 in DSNTDC.DSNTDMI+1452
          3. Abend0C4 RC00000038 in DSNXKAP.DSNXKINS+0812
    MODULES/MACROS:   DSNXCATL DSNXKINS
    
      PK35481/UK20612 (COMPID - 5740SM105 , DFSORT)
        ABENDS0C4 with 00000028 during migration to DB2 V9 while
        reorging SYSPACKAGE.
    MODULES/MACROS:  ICECOBV
    
      PK38799(PE/y)/UK24425-v8 (F704)
        (1) If a user migrates to V9 and creates V9 Explain tables,
            then after fallback to V8 the user will no longer be
            able to do Explain.
            SQLCODE -220 may occur during Explain.  UK90008 was
            missing fallback support for Explain.
        (2) Various abends in DSNSVBK or other modules may occur
            after applying UK20137 when Explain is performed and
            DSN_PREDICAT_TABLE or DSN_FUNCTION_TABLE exists.
    MODULES/MACROS:  DSNXIEPL DSNXOCCH* DSNXOD0  DSNXOD0A DSNXOD0P
    DSNXOD0Z DSNXOD1  DSNXOD10 DSNXOD12 DSNXOD13 DSNXOD2  DSNXOD3
    DSNXOD4  DSNXOD7  DSNXOD8  DSNXOD9  DSNXOLX1 DSNXOLX2 DSNXOOP
    DSNXOPTH DSNXOPTI DSNXOPTJ DSNXOTS
    
      PK39677/UK28751-v9 (F709)
        When migrating to DB2 Version 9 MSGDSNT501I is displayed
        during job step ENFM1103 of job DSNTIJEN.
            REASON RC00C90080
            TYPE00000200
            NAME DSNRTSDB.DSNRTSTS
    MODULES/MACROS:  DSNIRTSX
    
      PK39850(PE/y)/UK23138-v8 (F704)
        New Function - DB2 internal change to support future
        functions.
    MODULES/MACROS:  DSNUGSUG DSNUGTE0 DSNUGUCC
    
      PK41731/UK24302-v9 (F707)
        MIGRATION FAIL FROM V8 TO V9 COMPAT MODE WHEN USING NATIONAL
        SIGN LEADING SEPARATE DATA TYPE IN A COBOL APPLICATION
    MODULES/MACROS:  DSNHLEXC DSNHPSRV                          n.v.
    
      PK44544/UK29819-v9 (F710)
        Add optional job steps to DSNTIJPD to deploy temporary
        indexes to reduce runtime of the DSNTP2DP exec, a tool that
        facilitates conversion of applications from Private
        Protocol.
    MODULES/MACROS:  DSNTIJPD                                   n.v.
    
      PK44884(PE/y)/UK27092-v8 (F707)
        DSNE133E DSNECP12 RELEASE LEVELS NOT COMPATIBLE after
        applying APAR PK11129.  TSO Attach attempts to determine if
        the DB2 version level of the attachment code and the DB2
        subsystem are compatible, however the V8 RIBLIDV contains
        an incorrect constant value.
    MODULES/MACROS:  DSNDRIB  DSNECP12                         n.v.
    
      PK45376(PE/y)/UK29761-v8,UK29762-v9 (F710)
        During Enabling New Function Mode (enfm) DSNTIJNE REORG
        with ptf UK21909 applied, MSGICE046A SORT CAPACITY EXCEEDED
        occurrs when REORGing SPT01.
    MODULES/MACROS:  DSNURFIT
    
      PK45722/UK27799-v8,UK27800-v9 (F708)
        The DSNH CLIST has two different input parms for BIND REOPT
        options. These parms are called REOPT and PREOPT: The REOPT
        parm specifies the REOPT option setting for the
        DSNH-generated BIND PLAN statement, and the PREOPT parm
        specifies the REOPT option setting for the DSNH-generated
        BIND PACKAGE statement.  Currently, PREOPT settings other
        than PREOPT(VARS) are ignored by DSNH.
    MODULES/MACROS:  DSNH                                       n.v.
    
      PK45981/UK27823-v8,UK27825-v9(F708)
        All users of V9 premigration checkout job DSNTIJP9 on DB2
        UDB for z/OS Version 8 systems that specify COMMA for the
        DSNHDECP DECIMAL parameter are affected by this change.
        .
        All users of V9 premigration checkout job DSNTIJPM shipped
        with DB2 Version 9.1 for z/OS, and used on DB2 UDB for z/OS
        Version 8 systems that specify COMMA for the DSNHDECP
        DECIMAL parameter, are affected by this change.
    MODULES/MACROS:  DSNTIJP9  v8 , DSNTIJPM  v9                n.v.
    
      PK46054/UK29645-v9 (F710)
        Remove obsolete subsystem parameter REOPTEXT from DB2 V9.1
        for z/OS. This change includes removing field 15 REOPT
        AUTOMATICALLY from installation panel DSNTIP8.
    MODULES/MACROS:   DSNCIM   DSNCIMX  DSN@ZP   DSNDQWPZ DSNDSPRM
    DSNTINST DSNTIP8  DSN6SPRM DSNWZP   DSNTIDXA DSNTIJUZ       n.v.
    
      PK46585/UK28799-v9 (F709)
        SQLCODE -904 may be issued incorrectly when a V8 member
        tries to access an object that was created by a V9 member.
    MODULES/MACROS:   DSNXISB6
    
      PK47538/UK26789-v9( F707)
        Empty string is returned to the client when executing a
        package bound prior to V9R1 to set host variable = CURRENT
        TIMESTAMP in a server which is migrated to V9.
    
      PK47893/UK32047(PE)(F712)-v9 Superseded By
        PK63288(PE/y)/UK36794(F806)-v9
      PK47893/UK32046-v8 (F712)
        This PTF is shipped to update the DB2 administrative
        enablement interface, including the administrative
        scheduler. The update contains a partly new interface and
        bug fixes.
     MODULES/MACROS:  DSNCIM   DSN@DMTA DSN@DMTL DSN@DMTR DSN@DMTS
    DSN@DMTU DSN@6DB2 DSN@6THP DSNTINS1 DSNTINS2 DSN6SPRM DSNADMMG
    DSNADMMW DSNADMTA DSNADMTI* DSNADMTL DSNADMTM DSNADMTP DSNADMTR
    DSNADMTS DSNADMTU DSNA6BUF DSNA6DB2 DSNA6DMN DSNA6II  DSNA6IPC
    DSNA6ITK DSNA6MAI DSNA6SCH DSNA6THD DSNA6THJ DSNA6THP DSNFADIR
    DSNFMDIR DSNYSTRT DSN7SINI DSNTIJDE DSNTIJFV DSNTIJIN DSNTIJSG
    MODULES/MACROS:  DSNXRPUF
    
      PK48290/UK27933-v9 (F708)
        All DB2 V9 MQT users.
        MQT rewrite didn't happen on V9 for MQT created at V8.
    MODULES/MACROS:  DSNXOXIC
    
      PK49077/UK33785-v8,UK33786-v9 (F803)
        At least one of the trace class startup fields on the V8
        and V9 DSNTIPN (tracing parms) panel is too small to enter
        a desired combination of classes for that trace type.  This
        requires the user to manually track the settings for
        migration.
    MODULES/MACROS:  DSNTINST DSNTIPN
    
      PK49881/UK35078-v8,UK35079-v9 (F804)
        Users of the DB2 installation CLIST in DB2 UDB for z/OS
        Version 8 and DB2 Version 9.1 for z/OS and users of V8
        install job DSNTIJNE and V9 install job DSNTIJEN are
        affected by this APAR.
    MODULES/MACROS:  DSNTIPA1 DSNT46  DSNTIDXA DSNTIJEN         n.v.
    
      PK50989/UK31536-v8,UK31537-v9 (F712)
        The IVP job DSNTEJ3M creates sample tables, populates the
        sample tables, creates Materialized Query Tables, produces
        statistics, and runs EXPLAIN on the sample queries. The
        EXPLAIN output should indicate that the sample queries used
        an MQT instead of the base tables.  The current EXPLAIN
        output in STEP 7 of IVP job DSNTEJ3M shows that base tables
        were used instead of Materialized Query Tables.
    MODULES/MACROS:  DSNTEJ3M                                   n.v.
    
      PK54738/UK32702-v8,UK32703-v9 (F801)
        EIBNFM bit is NOT set ON at the completion of the migration
        from DB2 z/OS V8 Compat mode to New Function mode even
        though the new functions in the New Function mode are
        available.
    MODULES/MACROS:  DSNGEDLC* DSNGENER DSNRRPRC DSNUECMI
    
     PK58941/UK34434-v8,UK34435-v9 (F803)
       ADDITIONAL FUNCTION OF DB2 FOR Z/OS OPTIMIZATION SERVICE
       CENTER
       DSNTIJOC: OSC OE,
       DSNTIJNX: user-managed DB2-supplied objects
       DSNTIJRA: install job for security OSC OE,
       DSNTESC: sample explain tables
       DSNTIJOM:  existing V8 DB2 OSC & OE to V9 DB2.
    MODULES/MACROS:  DSNTIxxx, DSNUGxxx, DSN5Oxxx macro's
    
      PK59399/UK39757-v8,UK39811-v9 (F809)
        Add support to DB2 for z/OS 1.10 utilities to read DFSORT
        installation options that were activated through ICEPRMxx
        members in PARMLIB.
    MODULES/MACROS:  DSNUCRIB* DSNUCSOR DSNUGLSR DSNUGSOR DSNUGSRT
    DSNUKPIK DSNURPCT  DSNURPIB DSNURSOR DSNUSDRB DSNUSSOR
    
      PK61841/UK38390-v8,UK38391-v9 (F808)
        All users of job DSNTIJPM in DB2 Version 9.1 for z/OS are
        affected by this change. DSNTIJP9 and V9 DSNTIJPM do not
        report incomplete object definitions.
    MODULES/MACROS:  v8- DSNTIJP9   v9- DSNTIJPM                n.v.
    
      PK62253/UK37066-v9 (F807)
        04E-00C90101 DSNIMOFR erqual 5006 while running CATMAINT in
        migration from DB2 V8 to V9.
    MODULES/MACROS:  DSNPGSGI
    
      PK66563/UK38612-v8,UK38613-v9 (F808)
        The authorization check for DISPLAY THREAD command resulted
        in ABEND0C4 with RC00000038, when DB2 is started in
        ACCESS(MAINT).
    MODULES/MACROS:  DSNXACKP
    
      PK73081/UK42331-v8,UK42332-v9 (F812)
        Fix V9 premigration queries (DSNTIJP9,DSNTIJPM) for
        user defined indexes on the catalog and for incomplete
        table spaces.
    MODULES/MACROS:  DSNTIJP9 v8 , DSNTIJPM v9                n.v.
    
      AI PK85068/UK53249-v8,UK53250-v9 (F001) EXPLAIN TABLE
        MIGRATION
    MODULES/MACROS:  DSNTIJPM DSNTIJXA DSNTIJXB DSNTIJXC DSNTXTA
     DSNTXTB v8 & v9 , DSNTIJP9-v8 only
    
      PM14223/UK60838-v8,UK60839-v9  (F010) SQLCODE = -545 WHEN
        USING PREFIX.DSN_VIRTUAL_INDEXES TO CREATE VIRTUAL INDEXES
        ON AN EMPTY TABLE
    MODULES/MACROS:  DSNTESC  DSNTIJOS DSNTXTB
    
      PM17891/UK61197-v8,UK61198-v9/PM17891 (F010) DSNTIJXA/DSNTXTA
        AND DSNTIJXB/DSNTXTB DO NOT GENERATE VALID CONVERSION
        STATEMENTS (EBCDIC to UNICODE)
    MODULES/MACROS:  DSNTXTA  DSNTXTB
    

Local fix

  • N/A
    

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    II14401

  • 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

    2008-10-04

  • Closed date

  • Last modified date

    2011-08-02

  • 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:
02 August 2011