PK84764: ALLOW LOAD RESUME YES TO CREATE COMPRESSION DICTIONARIES FOR PHYSICALLY EMPTY PARTITIONS

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Retrofit of V9 code to allow LOAD RESUME YES to build
  compression dictionaries for physically empty partitions. APAR
  PK70866 must also be applied.
  

Local fix

• LOAD PART REPLACE or REORG PART, rather than LOAD RESUME YES
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 for z/OS V8 utility users of LOAD    *
  *                 RESUME YES on a COMPRESS YES partitioned     *
  *                 table space                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION: LOAD RESUME YES on a COMPRESS YES       *
  *                      partitioned table space does not build  *
  *                      compression dictionaries for logically  *
  *                      empty partitions even if the partition  *
  *                      was never populated with data           *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  LOAD RESUME YES on a COMPRESS YES partitioned table space does
  not build compression dictionaries for logically empty
  partitions even if the partition never contained data.
  
  Prior to this fix, LOAD RESUME YES on a COMPRESS YES partitioned
  table space would only build compression dictionaries for
  physically empty (untouched) partitions.  However, partitions
  that never had any data LOADed or INSERTed into them may be
  considered logically empty in cases where a prior LOAD reserved
  space for a compression dictionary that was never built.
  

Problem conclusion

• LOAD RESUME YES code has been modified to build compression
  dictionaries on logically empty COMPRESS YES 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

Comments

APAR Information

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

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

  UK46797

Modules/Macros

• DSNPIPP  DSNURWI
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK46797

     UP09/06/05 P F906

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.