IBM Support

PH36695: REORG ABEND04E RC00E2002F IN DSNSVSFM 21/07/05 PTF PECHANGE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • REORG TABLESPACE SHRLEVEL CHANGE is run on a classic
    partitioned or PBR table space with exactly one
    partitioning+clustering index defined in it.
    
    An overlay happens when clustering index is of length shorter
    than the mapping index.
    
    ADDITIONAL SYMPTOMS:
    ABEND04E RC00E40317 in DSNURBXD
    ABEND04E RC00E20992 in DSNSVSVB
    ABEND04E RC00E40347 in DSNURWBR
    ABEND04E RC00E2000E in DSNSVSFB
    

Local fix

  • BYPASS/CIRCUMVENTION:
    LOCAL FIX:
    1. Add the following as 1st line of SYSIN to bypass PI build
       logic:
             DIAGNOSE TYPE(892)
    2. Disable Parallelism with PARALLEL 1 in REOG job
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Db2 12 for z/OS users with PH28092 /                     *
    * UI71385 applied when REORG TABLESPACE                        *
    * SHRLEVEL CHANGE is run on a table space                      *
    * with a single clustering and partitioning                    *
    * index defined.                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * REORG TABLESPACE SHRLEVEL CHANGE with                        *
    * unload reload partition parallelism                          *
    * resulted in a storage overlay with                           *
    * PH28092 / UI71385 applied.                                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    With PH28092 / UI71385 applied, a REORG TABLESPACE SHRLEVEL
    CHANGE using data unload/reload partition parallelism on a
    table space with a single clustering and partitioning index
    resulted in a storage overlay and caused Db2 to crash.  For
    this overlay to happen, the following conditions all need to
    be satisified after applying the erroring PTF:
    1. REORG TABLESPACE SHRLEVEL CHANGE is run on a classic
    partitioned or PBR table space with one and only one
    partitioning index defined on it
    2. The partitioning index defined must have a sum of its max
    key column lengths less than 29 bytes long, which
    is the size of the mapping index key
    3. REORG is sorting the data records (SORTDATA YES) and is
    exploiting unload/reload partition parallelism (DSNU1160I
    issued)
    The reported problem is caused by an incorrect program logic
    when a task set number at the index level is being used to
    assign key length being processed at the partition level.
    Depending on the actual task set assignment, this might cause
    the build subtask processing the clustering index keys to be
    operating with a longer length than the actual clustering key
    length, resulting in overlays in the utility pipe and key
    buffers.  Depending on the trailing storage being used, a
    variety of external symptoms can be observed:
    ABEND04E RC00E40317 in DSNURBXD + x'1C92' OFFSET1C92
    ABEND04E RC00E2002F in DSNSVSVB + x'0838' OFFSET0838
    Additional keywords:
    DB2OVRLAY/K  MSGDSNU1160I MSGDSNU397I DSNU397I
    

Problem conclusion

  • Code has been modified to correct the aforementioned problems
    related to REORG TABLESPACE execution on a range partitioned
    table space with a single clustering and partitioning index
    defined.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH36695

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-04-26

  • Closed date

    2021-06-02

  • Last modified date

    2021-07-29

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

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

    UI75666

Modules/Macros

  • DSNURPCT
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI75666

       UP21/06/10 P F106 ¢

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.

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

Document Information

Modified date:
30 July 2021