IBM Support

PI26404: REORG KEEPDICTIONARY ON PBG TABLESPACE ABEND04E 00C90101 DSNIKESR ERQUAL500B OR ABEND04E 00C9007E DSNIRLPG

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • With large rba support, REORG KEEPDICTIONARY on PBG tablespace
    abends with 04E-00C90101 DSNIKESR:500B.
    
    Keywords: ExtendedRBA DB2EXTRBA/K
    Additional symptoms: ABEND04E RC00C9007E DSNIRLPG OFFSETCC70
                         DSNIRLPG RC00C90101 00C90101 ERQUAL5018
                         5018 00C9007E OFFSETCC3C
     Abend title example:
     DSN ,ABND=04E-00C9007E,U=uuuuuuu ,M=N  ,C=111.DMC -DSNILPG
     ,M=DSNTFRCV,LOC=DSNIDM  .DSNIRLPG+CC70
     (r14 at abend is LZDP . LZDPCC at + x'33' is 01 length error.)
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 11 for z/OS users of REORG           *
    *                 TABLESPACE KEEPDICTIONARY on a               *
    *                 compressed PBG table space.                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00C90101 DSNIKESR ERQUAL500B *
    *                      during REORG TABLESPACE KEEPDICTIONARY  *
    *                      on a compressed partition-by-growth     *
    *                      (PBG) table space with different        *
    *                      dictionaries for multiple partitions.   *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available.         *
    ****************************************************************
    A REORG TABLESPACE KEEPDICTIONARY on a compressed PBG table
    space with different dictionaries for multiple partitions
    abended with ABEND04E RC00C90101 at DSNIKESR:500B because the
    wrong dictionary was used to decompress the data records when
    reloading them back to a different partition.
    
    The problem only happens when the BSDS of the subsystem has been
    converted to extended format that supports 10-byte RBA and LRSN
    fields by running job DSNTIJCB and at least one of the different
    dictionaries was built after the conversion.
    
    Additional symptoms:
    ABENDS0C7 ABEND0C7 DSNIRLPG + x'32AC' OFFSET32AC
    

Problem conclusion

  • Code has been modified to decompress the records during the
    UNLOAD phase of REORG if KEEPDICTIONARY is specified and
    different dictionaries exist for the partitions of the PBG
    table space.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI26404

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-09-25

  • Closed date

    2014-12-21

  • Last modified date

    2015-04-24

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI24114

Modules/Macros

  •    DSNURFUI
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI24114

       UP15/01/13 P F501

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
06 May 2020