PI52899: AVGRLEN NOT CALCULATING PROPERLY ON REORG USING MORE SPACE THAN NECESSARY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• During a REORG with honor_keepdictionary YES
  it doesn't decompress but it allocates
  the same amount of tracks as
  honor_keepdictionary NO causing
  more DASD allocation than necessary
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS      *
  *                 users of REORG TABLESPACE utility.           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Average row length was overestimated    *
  *                      during a REORG KEEPDICTIONARY on a      *
  *                      table space to convert the row format   *
  *                      with ROWFORMAT BRF/RRF when the ZPARM   *
  *                      HONOR_KEEPDICTIONARY was set to YES.    *
  ****************************************************************
  * RECOMMENDATION: Apply corrective PTF when available.         *
  ****************************************************************
  A REORG KEEPDICTIONARY with ROWFORMAT BRF/RRF option was run on
  a table space with a table with all fixed length columns to
  convert the row format.  The ZPARM HONOR_KEEPDICTIONARY was set
  to YES.  The REORG estimated the average row length using the
  decompressed data, however the compressed record was unloaded
  and sorted for this case, so the estimate for the sort work data
  set was overestimated.
  
  A REORG KEEPDICTIONARY with ROWFORMAT BRF/RRF option was run on
  a table space with a table with varying length columns to
  convert the row format.  The ZPARM HONOR_KEEPDICTIONARY was set
  to YES.  The REORG incorrectly unloaded some records
  decompressed.
  

Problem conclusion

• REORG code has been modified to estimate the average row length
  on the compressed data if KEEPDICTIONARY and ROWFORMAT BRF/RRF
  options are specified when the ZPARM HONOR_KEEPDICTIONARY is
  set to YES.
  REORG code has been modified to unload the compressed record
  for the table space with a table with varying length columns for
  this case.
  

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:

  UI35765 UI35766

Modules/Macros

• DSNUCRUL DSNUKIUL DSNURFBR DSNURFIT DSNURFUI
  DSNURSCN DSNUSTBL DSNUULXA
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI35765

     UP16/03/16 P F603

• RB10 PSY UI35766

     UP16/03/16 P F603

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.