PM37993: SM COMPRESSION RATIO SHOULD BE SET TO 0 SINCE SM USES AVG ROW SIZE 11/04/28 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• In DB2 Administration Tool for z/OS, Space Management function
  incorrectly puts in Compression Ratio from PAGESAVE instead
  of putting in 0 since Avg. Row Size is already compressed.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the DB2 Administration Tool for     *
  *                 z/OS who use the Table space estimator       *
  *                 function on panel ADB2M 'DB2 Space Manager'. *
  ****************************************************************
  * PROBLEM DESCRIPTION: In the DB2 Administration Tool for      *
  *                      z/OS, the Space Management function     *
  *                      incorrectly adds the Compression Ratio  *
  *                      value from PAGESAVE instead of 0 since  *
  *                      the table space is defined as COMPRESS  *
  *                      NO.                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  The methods to estimate the average row size, compression ratio,
  and rows per page are not correct.  Panel ADBHMES has been
  updated to clearly explain the correct meaning of the fields
  "Avg. row size", "Compression ratio" and "Rows per page".
  

Problem conclusion

• The problem has been resolved.
  

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:

  UK69721 UK69722

Modules/Macros

•    ADBHMES  ADB2MES  ADB2MESG
  

Fix information

• Fixed component name

  DB2 ADMIN TOOL

• Fixed component ID

  568851500

Applicable component levels

• RA10 PSY UK69721

     UP11/07/15 P F107

• R720 PSY UK69722

     UP11/07/15 P F107

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.