IBM Support

II14464: DB2 V8 MIGRATION/FALLBACK INFOAPAR TO/FROM DB2 9 (CONTINUED FROM II14401)

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
    (Continued from II14401)
    
    Key   n.v. = not visible under a Diagnose Display MEPL
          *    = quick module check under Diagnose Display MEPL
    Please pay special attention to ++Hold Actions.
    
    FOLLOWING PTFS ARE FOR DB2 9 MIGRATION:
    (Updated on Feb/01/2013)
    
    
      PK62161/UK44050-v8,UK44051-v9 (F903)
        IFCID 002 / IFCID 003 are updated to include new counters
        that indicate the number of rows
        fetched/updated/inserted/deleted.
    MODULES/MACROS:  DSNDQXST DSNIDLEC* DSNILREP DSNISRTI DSNISRTW
    DSNITDLE DSNTLRAC DSNTSTRT DSNTXACT DSNTXSTB DSNUECM2 DSNUGUCA
    DSNWAACT DSNWVSMT DSNWVZIT DSNWVZSA DSNWZDG2 DSNXEBR  DSNXEET
    DSNXELX  DSNXENR  DSNXIENF DSNXINIT DSNXISTK DSNXTAD  DSNXTSD
    
      PK62178/UK44489-v9 (F903)
        The maximum number of databases that can be created
        implicitly is hard-coded to 60000.
    MODULES/MACROS:  DSNUECSE DSNXIAQ1 DSNXIASQ DSNTISB5
    
      PK70060(HIPER)/UK46839-v9 (F906)
        DGTT mass delete performance enhancement.
        ABEND04E RC00E72088 DSNXSMRG+3452
        during scan of workfile
    MODULES/MACROS:  DSNIBWAC DSNICMT2 DSNIGWAC DSNISEGD DSNISEGF
    DSNISGNS DSNITNPG DSNIWCUB DSNIWKFL DSNWDFDM
    
      PK72214/UK46092-v8,UK46093-v9 (F905)
        Unexpected DSNU778I and SQLCODE -148 when running CATMAINT
        or CATENFM utility.
    MODULES/MACROS:  DSNTIJP9  v8 , DSNUECSE DSNTIJPM  v9      n.v.
    
      PK75643/UK42565-v9 (F901)
        The default value of subsystem parameter OPTIOWGT is bein
        changed from DISABLE to ENABLE.
    MODULES/MACROS:  DSNTINST DSN6SPRM DSNTIDXA DSNTIJUZ        n.v.
    
      PK78958(HIPER)/UK45353-v9(F904) -- Superceded By
        PK85985(PE)/UK47287(F906)
        Disable REORG TABLESPACE and LOAD REPLACE from converting a
        COMPRESS YES table space or partition from Basic Row Format
        (BRF) to Reordered Row Format (RRF) in DB2 9 NFM.
    MODULES/MACROS:  DSNUGRSP DSNUGRST DSNURFBR DSNURFIT DSNURLAP
    DSNURSCN DSNURSWD DSNURWI  DSNURWT
    
      PK78959/UK45881(PE)-v9 (F905)    -- SUPERSEDED BY:
      PK85985/UK47287(PE)-v9 (F906)
      >>PM12302(PE/y)/UK58993-v9     << see above
        REORG SERVICEABILITY ENHANCEMENT.
    MODULES/MACROS:   DSNIRFNX DSNIRLPG DSNUCASA DSNUGRSP DSNUGRST
    DSNURFBR DSNURFIT DSNURLAP DSNURSCN DSNURSWD DSNURWI  DSNURWT
    
      PK79327/UK44899-v9 (F904)
        Set DB2 member ineligible for randomized group attach
        processing.
    MODULES/MACROS:  DSN@ZP   DSNDQWPZ DSNTINST DSN6GRP  DSNWZP
    DSN3AMI2* DSN3CHGZ DSNTIDXA DSNTIJUZ
    
      PK79327/UK44899-v9 (F904)
        Set DB2 member ineligible for randomized group attach
        processing.
    MODULES/MACROS:  DSN3ID00
    
      PK85640/UK48559-v9 ( F908) INCORROUT      NFM
      SYSIBM.SYSPACKAGE.DISTRIBUTE = '00' IS NOT A CHAR(1)
      SYSIBM.SYSPACKAGE.LASTUSED = '0000-00-00' IS NOT A VALID DATE
    MODULES/MACROS:  DSNTBSPL
    
      PK85985(HIPER)/UK47286-v8,UK47287(PE)-v9 (F906)
      >>PM12302(PE/y)/UK58993-v9     <<  see above
        A DB2 V8 or V9 LOAD RESUME YES into a compressed tablespace
        that has more than 256 parts may corrupt populated parts if
        any of the parts less than 257 are empty, and the LOAD
        RESUME of is at the tablespace level (not using INTO TABLE
        PART nnn).
    MODULES/MACROS:   DSNGDART DSNGDBDC DSNGDCOB DSNIPTYM DSNUKDFK
    DSNUKSCT DSNURBX  DSNURWI  ,..DSNXIAB4 DSNXICX2  v8
                               ,..DSNXISB5           v9
    
      PK64485/UK37636-v9 (F808)
        The DSNTIJNF job failed to put DB2 subsystem to new
        function mode (NFM) even after successful completion of
        the DSNTIJEN job.
    MODULES/MACROS:  DSNUECMJ
    
      PK71531/UK40060-v9 (F810)
        MULTIPLE ABENDS ON WORKFILES AFTER MIGRATION/FALLBACK
        CM AND V8 NFM - OBDFINPS IS SETUP WITH A WRONG VALUE
    MODULES/MACROS:  DSNGDCPD
    
      PK72214/UK46092-v8,UK46093-v9 (F905)
        Unexpected DSNU778I and SQLCODE -148 when running CATMAINT
        or CATENFM utility.
    MODULES/MACROS:  DSNTIJP9  v8 , DSNUECSE DSNTIJPM  v9
    
      PK77228/UK46734-v8,UK46735-v9 (F906)
        Changed installation job DSNTIJRA, DSNTIJSG, DSNTIJEN,
        DSNTIJOC and DSNTIJPM.
    MODULES/MACROS:  DSNTIDXA DSNTIJNE DSNTIJRA DSNTIJSG DSNTINST
    DSNTINS1 , .. DSNTIJP9                              v8
               .. DSNTINS3 DSNTIPL   DSNTIJEN DSNTIJPM  v9
    
      PK85068/UK53249(AI)-v8,UK53250(AI)-v9 (F001)
        Migrate Explain table.
    MODULES/MACROS:  DSNTIJPM DSNTIJXA DSNTIJXB DSNTIJXC DSNTXTA
    DSNTXTB , .. DSNTIJP9     v8
    
      PK93084/UK51594-v8,UK51595-v9 (F911)
        Changed installation job DSNTIJMV and DSNTIJSG.
    MODULES/MACROS:  DSNTIJSG DSNTINS1                          n.v.
    
      PK95022(HIPER)/UK51772-v9 (F911)
        Error occurred when customer reverted from V9 NFM to V9
        CM* and index compression was active (COMPRESS YES).
    MODULES/MACROS:  DSNB5RAP DSNB5RDP DSNIFOI  DSNKFRMT
    
      PM11897(PE/y)/UK56789-v9 (F005)
        After migration to DB2 V9 NFM an SRB (service request block)
        loop occurs when running sample job DSNTEJ1, job step
        PH01S13.
    MODULES/MACROS:  DSNTINST DSNTINS1 DSNTINS2 DSNTINS3 DSNTEJ1
    DSNTIJNX DSNTIJOC DSNTIJOM DSNTIJOS                         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
    
      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
    .
    

Local fix

  • N/A
    

Problem summary

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    II14464

  • 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

    2009-08-13

  • Closed date

  • Last modified date

    2013-02-01

  • 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:
01 February 2013