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

Obtain the fix for this APAR

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 is sysrouted FROM one or more of the following:

  PK64261

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

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.