IBM Support

PI96921: ABEND04E 00C90101 DSNIDBLG ERQUAL5460 WHEN IRLM IS BROUGHT DOWN IN A DATASHARING SYSTEM.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ABEND04E RC00C90101 at DSNIDBLG 5460 when IRLM is brought
    down in a datasharing system.
    D75284..
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Db2 for zOS users of Alter Table Add     *
    *                 Partition and users of partitioned           *
    *                 tablespaces.                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00C90101 in DSNIDBLG with    *
    *                      ERQUAL5460 when IRLM is brought down    *
    *                      in a datasharing environment.           *
    *                      Also ABEND04E RC00C90101 in DSNIDBEL    *
    *                      with ERQUAL5460.                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    During rollback of an ALTER TABLE ADD PARTITION, abends
    occurred processing a partitioned table.  The total number
    of partitions is less than the high partition range of an
    entry in an internal DBET control block.  During processing
    of the ALTER to add a new partition, the new partition is
    placed in extend-in-progress and the entry added to an
    internal DBET control block.  During rollback, this
    newly added entry is not cleaned up properly and is
    left in the control block.  Checks done later to
    ensure consistency fail when it finds this entry
    still in the control block.
    

Problem conclusion

  • DBET has been modified to correctly clean up during rollback
    of an ALTER TABLE ADD PARTITION.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI96921

  • 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

    2018-04-18

  • Closed date

    2018-05-15

  • Last modified date

    2018-06-04

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

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

    UI55872 UI55873

Modules/Macros

  •    DSNIDBEL DSNIDBLG
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI55873

       UP18/06/01 P F805

  • RC10 PSY UI55872

       UP18/06/01 P F805

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"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
04 June 2018