IBM Support

PK68325: EXCESSIVE GETPAGES DURING LOAD SHRLEVEL NONE COMPRESS YES ON PARTITIONED TABLESPACES. AE PK64261 FIX COMPLETION

A fix is available

 

APAR status

  • Closed as program error.

Error description

  • Running a LOAD SHRLEVEL NONE RESUME YES COMPRESS YES on a
    partitioned tablespace with some parts empty will cause
    excessive GETPAGES during the utilinit phase.

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 for OS/390 or z/OS V7 users of *
    * PK31044/PTF UK21410, DB2 for z/OS V8 users *
    * of PK31044/PTF UK21411, and DB2 9 for z/OS *
    * utility users of LOAD RESUME utility *
    ****************************************************************
    * PROBLEM DESCRIPTION: AE FIX completion for PK64261. *
    * *
    * After applying V8 PTF UK21411 or for *
    * all DB2 9 utility users, *
    * LOAD RESUME YES leaves an empty *
    * COMPRESS YES table space in RECP status *
    * after failing with MSGDSNU047I and *
    * ending with RC8. *
    * *
    * After applying V7 PTF UK21410, V8 PTF *
    * UK21411, or for all DB2 9 utility users *
    * LOAD RESUME YES on a classic *
    * partitioned table space with some *
    * non-empty partitions may encounter a *
    * performance degradation in the UTILINIT *
    * phase. *
    ****************************************************************
    * RECOMMENDATION: Apply corrective PTF when available *
    ****************************************************************
    After applying V8 PTF UK21411 or for all DB2 9 utility users the
    following problem can occur:
    A LOAD RESUME YES utility was run on an empty COMPRESS YES
    table space where the INDDN specified on the LOAD statement
    (INDDN SYSREC00) did not match the actual JCL DD card
    (//SYSREC). The LOAD issued MSGDSNU047I - A REQUIRED DD CARD
    OR TEMPLATE IS MISSING. NAME=SYSREC00 and MSGDSNU560I -
    TABLESPACE tsname PARTITION 1 IS IN RECOVER PENDING STATE and
    ended with RC8. The table space should not be left in a RECP
    state when failing early in reload initialization.

    The problem can also occur for LOAD RESUME YES on an empty
    COMPRESS YES partition on a partitioned table space and for
    LOAD RESUME NO on an empty COMPRESS YES table space.

    After applying V7 PTF UK21410, V8 PTF UK21411, or for all DB2 9
    users the following problem can occur:
    LOAD RESUME YES with both empty and non-empty partitions may
    encounter a performance degradation in the UTILINIT phase.
    The check for an empty partition caused additional GETPAGEs
    resulting in a performance degradation. This check
    to determine if the partition was empty or not was not needed
    for LOAD RESUME YES SHRLEVEL NONE on a COMPRESS NO partition
    or LOAD RESUME YES SHRLEVEL CHANGE. However, this check for
    empty was needed for LOAD RESUME YES SHRLEVEL NONE on COMPRESS
    YES partitions to determine whether or not to build a
    compression dictionary. Since there may be a significant
    performance degradation during this empty check for classic
    partitioned table spaces (not UTS PBG or PBR), the behavior
    of LOAD RESUME YES SHRLEVEL NONE on COMPRESS YES partitions
    of a classic partitioned table space will change to prevent
    this performance degradation as described in the solution
    below and in the ++HOLD.

Problem conclusion

  • Code has been modified for a LOAD RESUME YES or NO on an empty
    table space to remove the RECP state immediately following the
    procedure that required it. This will leave the object
    available if an initialization error occurs.

    Code has been modified for LOAD RESUME YES SHRLEVEL NONE on
    COMPRESS NO partitions or for LOAD RESUME YES SHRLEVEL CHANGE
    to not check for empty partitions since compression dictionaries
    are not built for these cases.

    Code has been modified for LOAD RESUME YES SHRLEVEL NONE to
    only attempt to build a compression dictionary for COMPRESS YES
    partitions of a classic partitioned table space if the partition
    is physically empty (unused). In V7/V8, LOAD RESUME YES
    SHRLEVEL NONE will no longer build compression dictionaries for
    logically empty (used partitions that may have had data loaded
    or inserted at one time) partitions of a classic partitioned
    table space to avoid the potential performance degradation of
    determining whether or not a partition is logically empty.

    In V9, LOAD RESUME YES SHRLEVEL NONE, a new algorithm allows
    LOAD to build compression dictionaries for logically empty
    partitions where possible. Specifically, when the HI-U-RBA
    divided by the page size is less than 20 pages. If HI-U-RBA
    divided by the page size is greater than or equal to 20 pages,
    a LOAD PART REPLACE with DUMMY input is recommended on the
    logically empty partition(s). This LOAD PART REPLACE with
    DUMMY input will reduce the number of pages that are
    preformatted, so the subsequent LOAD RESUME YES will be able
    to check for logical empty since the HI-U-RBA divided by page
    size will now be less than 20 pages.

Temporary fix

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

Comments

APAR Information

  • APAR number

    PK68325

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    710

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-06-27

  • Closed date

    2008-09-16

  • Last modified date

    2009-06-24

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

    PK64261

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

Modules/Macros
DSNURWI          

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R710 PSY UK37621

       UP08/10/02 P F810

  • R810 PSY UK37622

       UP08/10/02 P F810

  • R910 PSY UK37623

       UP08/10/02 P F810

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.

Document information

More support for: DB2 for z/OS

Software version: 710

Reference #: PK68325

Modified date: 24 June 2009