IBM Support

PH22119: ABEND04E 00C90101 DSNISORT 5003

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00C90101 in DSNISORT ERQUAL5003 can occur in rare
    case under ISO(CS) bind.
    In this particular case customer was running in ISO(UR), so the
    chance to hit is increasing.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Db2 users with queries using a                           *
    * data-partitioned secondary index (DPSI).                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ABEND04E RC00C90101                                          *
    * LOC=DSNIDM.DSNISORT ERQUAL5003                               *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    When a reader without holding a lock (e.g. ISO(UR) or ISO(CS))
    uses DPSI to retrieve and order data by DPSI key columns, the
    keys may be updated by another thread. When Db2 detects a
    change in the key, Db2 will skip the row and fetch the next
    one based on the order of the key. However, Db2 incorrectly
    uses the changed key instead of the previous key which has
    the correct position to perform the next fetch. This causes
    Db2 to abend in a failed sanity check when Db2 detects the
    retrieved data is out of order during the fetch-next
    processing.
    

Problem conclusion

  • Db2 DPSI data retrieval logic has been fixed to preserve the
    previous key position for fetch-next processing when Db2 skips
    a row due to a change in the key values.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH22119

  • 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

    2020-02-12

  • Closed date

    2020-03-06

  • Last modified date

    2020-04-02

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

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

    UI68252 UI68253

Modules/Macros

  • DSNIFDPO
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI68252

       UP20/03/14 P F003

  • RC10 PSY UI68253

       UP20/03/14 P F003

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":"BU048","label":"IBM Software"}, "Product":{"code":"SSEPEK","label":"DB2 for z/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":""},{"Business Unit":{"code":"BU048","label":"IBM Software"}, "Product":{"code":"SG19M","label":"APARs - z/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":""}]

Document Information

Modified date:
27 March 2020