PH61791: REORG DOESN'T BUILD DICTIONARY FOR NEW PARTS AFTER PBG IS CONVERTED TO PBR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After a tablespace is altered from PBG to PBR, REORG is required
  to materilize the change.  If the number of partitions is bigger
  after the REORG, the REORG just builds dictionary for the
  original number of parts. New parts generated after the
  conversion contains no dictionary.  Customer could observe space
  increase in those new partitions.
  

Local fix

• BYPASS/CIRCUMVENTION:
  REORG the parts with no dictionary again.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Db2 13 for z/OS users of REORG utility   *
  *                 to materialize PBG to PBR conversion         *
  ****************************************************************
  * PROBLEM DESCRIPTION: A pending alter materializing REORG     *
  *                      did not build compression dictionaries  *
  *                      for new partitions of a table space     *
  *                      undergoing PBG to PBR conversion        *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available          *
  ****************************************************************
  A REORG TABLESPACE was run to materialize a pending definition
  change to convert an existing COMPRESS YES partition-by-growth
  table space to a partition-by-range table space, where the new
  PBR table space had more partitions defined than the original
  PBG table space.  The REORG utility completed successfully,
  but it was noticed that there were no compression dictionaries
  built for the new non-overlapping partitions of the resulting
  PBR table space.
  
  The reported problem was caused by incorrect program logic
  where REORG did not initialize the in-memory dictionary work
  area correctly using the number of partitions in the resulting
  PBR table space.  This caused REORG to not build new
  compression dictionaries for these partitions, which resulted
  in the observed space growth of the affected partitions.
  
  Additional keywords:
  - DSNU244I MSGDSNU244I
  - ABEND04E RC00C20305 DSNICLDR OFFSET013C6 x'13C6'
  

Problem conclusion

• Code has been modified for the pending alter materializing
  REORG in the aforementioned scenario to correctly initialize
  the dictionary work areas during PBG to PBR conversion, which
  results in the building of the new compression dictionaries
  on the affected partitions.
  

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:

  UI98524

Modules/Macros

• DSNURFUI
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RD10 PSY UI98524

     UP24/10/02 P F410

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.