PM31614: PERFORMANCE OF PACKAGE ALLOCATION IMPROVEMENT

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Package allocation performance improvement
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 users.                               *
    ****************************************************************
    * PROBLEM DESCRIPTION: Some packages experience higher CPU     *
    *                      times and LC25 when compared with       *
    *                      a prior release of DB2.                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    Packages that have very short running SQL statements or that
    issue frequent Commits and they are bound release commit may
    have increased CPU time when compared to a prior release of DB2.
    Also Latch Class 25 contention may increase in a multi-thread
    environment where there are a number of threads accessing the
    same package
    

Problem conclusion

  • DB2 code was modified so that some of the code is no longer
    executed under the latch. This reduces the latch contention.
    Some of the code was moved to a service task to reduce the
    CPU time required for packages that have a very short
    running SQL statements or that issue frequent commits.
    

Temporary fix

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

Comments

APAR Information

  • APAR number

    PM31614

  • 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

    2011-01-31

  • Closed date

    2011-03-31

  • Last modified date

    2011-05-01

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

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

    UK66374

Modules/Macros

  •    DSNDEDM  DSNGEFLC DSNGEINT DSNGEPLC DSNGERTS
    DSNIRTST
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK66374

       UP11/04/17 P F104

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

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM31614

Modified date:

2011-05-01

Translate my page

Machine Translation

Content navigation