IBM Support

PI07694: LOG APPLY PERFORMANCE IMPROVEMENT FOR INDEX LOG RECORDS.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Performance improvement for processing index log records in DB2.
    .
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 users.                               *
    ****************************************************************
    * PROBLEM DESCRIPTION: LOG APPLY PERFORMANCE IMPROVEMENT FOR   *
    *                      INDEX LOG RECORDS.                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Today, during index recovery (DB2 restart, Recover utility or
    Restore utility) using Fast Log Apply (FLA), prefetching of
    index pages is disabled. This results in slower index recovery
    compared to table space recovery using DB2 logs. This APAR will
    enable prefetch for index pages when FLA is used for index
    recovery. This will result in improved elapsed times for index
    recovery. The recovery log apply improvement may vary depending
    on the degree of random updates to the index pages.
    

Problem conclusion

  • DB2 index space log apply performance may be improved when
    fast log apply is used.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI07694

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-12-09

  • Closed date

    2014-01-06

  • Last modified date

    2014-02-05

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

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

    UI14003 UI14004 UI14005

Modules/Macros

  • DSNB1SPF DSNIFLAA DSNIFLRD DSNIRSTR
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI14003

       UP14/01/21 P F401

  • RB10 PSY UI14004

       UP14/01/21 P F401

  • R910 PSY UI14005

       UP14/01/21 P F401

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

Document Information

Modified date:
05 February 2014