PM97867: DB2 10: INSERT PERFORMANCE ENHANCEMENT

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • Insert performance enhancement for DML activity pattern such as
    insert and delete within the same commit scope in one-way data
    sharing environment.
                                                          (d167243)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 V10 for z/OS users of applications   *
    *                 that access Universal Table space (UTS)      *
    *                 with a data pattern of insert and            *
    *                 delete.                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION: An application that accesses            *
    *                      Universal Table Space (UTS) could       *
    *                      result in high get page count if the    *
    *                      data accessing pattern consists of      *
    *                      inserts and deletes.                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When deleted space distributes through the table space,
    the subsequent insert process could result in high get page
    count. This is due to the false lead threshold that was
    increased to improve space reuse within the candidate segment
    or during the exhaustive search prior to physical extend.
    However, the extra page search does not fit for the situation
    where the data page has unusable free space. As a result, the
    get page count would increase by visiting more pages for each
    search step.
    

Problem conclusion

Temporary fix

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

Comments

  • DB2 code was changed to limit the threshold increase to
    DSNDBD01 object only.
    

APAR Information

  • APAR number

    PM97867

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-25

  • Closed date

    2013-12-03

  • Last modified date

    2014-01-02

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

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

    UI13153

Modules/Macros

  • DSNISUPI
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI13153

       UP13/12/24 P F312 ½

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 #:

PM97867

Modified date:

2014-01-02

Translate my page

Machine Translation

Content navigation