IBM Support

PH04150: ABEND04E RC00C90101 DSNKISPL ERQUAL5003

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After a CICS/DB2 deadlock 00C90088 - an ABEND 04E 00C90101 in
    DSNKISPL ERQUAL 5003 produced a dump and put the index into LPL
    for LOGAPPLY. Since the deadlock drove ABORT UNDO processing
    for a unique index defined on a PBR table, as we're attempting
    a leaf page split to reinsert the deleted key, which we don't
    allow during ABORT processing.
    
    Additional keywords: RC00C90088 MSGDSNT375I DSNT375I MSGDSNT501I
                         DSNT501I MSGDSNB250E DSNB250E LOGAPPLY
                         RC00C90101 DSNIBHUN ERQUAL5013 5013
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Db2 for z/OS V12 data sharing users.                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ABEND04E RC00C90101 ERQUAL5003 in                            *
    * DSNKISPL.                                                    *
    * ABEND04E RC00C90101, RC00C90102,                             *
    * RC00C90105, or RC00C902xx in                                 *
    * various CSECTs.                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    Problems are due to using an incorrect commit-LSN value which
    makes it appear that uncommitted updates are in fact committed.
    For example, the space for a deleted row or index entry may be
    reused even though the delete was not committed.
    
    The bad commit-LSN is the result of a timing window during the
    collection of LRSNs from all members of the data sharing group.
    When an LRSN list has been filled up, the code fails to account
    for the lag time since a member list was created.
    

Problem conclusion

  • The LRSN list merge process has been modified to always account
    for the potential lag time since a member's list was generated.
    Additionally, the process has been modified to ignore old lists
    from quiesced members.
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

APAR Information

  • APAR number

    PH04150

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-10-16

  • Closed date

    2018-11-01

  • Last modified date

    2018-12-12

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

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

    UI59483

Modules/Macros

  • DSNB1PCK
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI59483

       UP18/11/17 P F811 ¢

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":"12.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":"12.0","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
12 December 2018