PM86984: ABEND04E RC00C90206 DSNIIDIS ERQUAL5002

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The following abend occurred during an update to a row.
    DSN ,ABND=04E-00C90206,U=xxxx    ,M=C9 ,C=101.DMC
     -DSNILREP,M=DSNTFRCV,LOC=DSNIDM  .DSNIIDIS:5002
                                                                   .
    Also, check index showed the mismatch:
     DSNU709I  -DSN  .. DSNUKIKI - NO INDEX ENTRY FOR ROW .
                                                                   .
    The RID had previously been inserted to the wrong leaf page ,
    due to small timing window during index look-aside processing .
    Index traversal route at abend time was correct, but therefore
    didn't locate the rid and DB2 took the abend.
                                                                   .
    Additional keywords: SSB , i/o parallelism . lookaside
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: DB2 10 for z/OS users using index insert     *
    *                 I/O parallelism.                             *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00C90206 DSNIIDIS ERQUAL5002 *
    *                      happened during SQL DELETE operation.   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    During SQL INSERT execution, index I/O parallelism could be used
    when there are three or more indexes defined on the table being
    inserted into.
    
    When index insert I/O parallelism is in use, if I/O wait is
    encountered on the clustering index get page request,
    index tree traversal will exit early without fully
    populating the index look aside buffer with correct information.
    
    In a very small timing window, the index look aside buffer
    already contains residual information before the index tree
    traversal starts. Index insert I/O parallelism will leave
    residual information in the index look aside buffer after the
    insert finishes. The subsequent SQL INSERT using the index look
    aside buffer causes the index key to be inserted into the wrong
    leaf page. This problem only happens when inserting into the
    clustering index.
    
    Later on, SQL DELETE detects the problem by issuing ABEND04E
    RC00C90206 DSNIIDIS ERQUAL5002. CHECK INDEX utility can also
    detect the error if it is run with DIAGNOSE TYPE(70,71).
    Index needs to be rebuilt to correct the error.
    

Problem conclusion

  • DB2 code was modified to make sure there is no residual
    information left in the index look aside buffer after SQL
    INSERT when index insert I/O parallelism is in use.
    
    
    Additional keywords: SQLINSERT
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PM86984

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-15

  • Closed date

    2013-05-21

  • Last modified date

    2013-07-02

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

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

    UK94483

Modules/Macros

  •    DSNKTRAV
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK94483

       UP13/06/07 P F306

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.



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM86984

Modified date:

2013-07-02

Translate my page

Machine Translation

Content navigation