IBM Support

PH14585: ABEND04E 00C90101 AT DSNIDM DSNISFPI ERQUAL 5001 WHEN USING INSERT ALGORITHM 2 - IAG2

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When INSERT transaction running parallel using Insert Algorithm
    2 in a data sharing environment, there is timing window that
    transaction can referencing down level space map page without
    page latch. As a result, insert can encounter various forms of
    data corruption detection abends.
    Additional symptoms: ERQUAL5001 DSNKINSL 5033 ERQUAL5033
                         00C90207 DSNIOW 5003 ERQUAL5003
                         DB2IAG2/K
    

Local fix

  • Disable IAG2 - DEFAULT_INSERT_ALGORITHM
    With PH02052/UI61453 applied, then the -SET SYSPARM
    command will support the online change of
    DSN6SPRM.DEFAULT_INSERT_ALGORITHM
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Db2 12 for z/OS using Insert Algorithm 2                     *
    * (IAG2) with tables defined with APPEND                       *
    * NO attribute.                                                *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When inserting into a table defined                          *
    * as APPEND NO and Insert Algorithm 2                          *
    * (IAG2) is used, the following errors                         *
    * were encountered:                                            *
    *                                                              *
    * 1. ABEND04E RC00C90101 AT DSNIDM.                            *
    * DSNISFPI:5001                                                *
    * 2. ABEND04E RC00C90101 AT DSNIDM.                            *
    * DSNKINSL:5033                                                *
    * 3. ABEND04E RC00C90207 AT DSNIDM.                            *
    * DSNIOW:5003                                                  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply corrective PTF when available                          *
    ****************************************************************
    When insert or load data into a table defined with APPEND
    NO, using Insert Algorithm 2 (IAG2), Db2 scanned all existing
    space map pages to fill a set of pipes with available data
    pages.  When this process was completed, the space map page
    was unlatched, and the write intent was released on the
    page.  However, the internal control flag indicating the write
    intent
    status of the space map page was still held, as a result, the
    subsequent process got the down-leveled space map page without
    refreshing it from the buffer pool.  This caused various Db2
    abends (mentioned in Problem Description section).
    

Problem conclusion

  • Data Manager module is modified to reset the flag indicating
    that no write intent of the space map page after it is
    unlatched.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH14585

  • 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

    2019-07-16

  • Closed date

    2019-08-09

  • Last modified date

    2020-07-21

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

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

    UI64682

Modules/Macros

  • DSNISFAS DSNISFRO
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RC10 PSY UI64682

       UP19/08/27 P F908

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"}],"Version":"12.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
22 July 2020