PH22051: REMOVE SUPPORT FOR HIPERPOOL COLUMNS GETTING VALUES FROM FIELDS QBACHRE, QBACHRF, QBACHWR, QBACHWF AND QBACHPG OF RECORD SMF_101

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Remove support for BP4K_HPOOL_* tables since they are no longer
  supported by DB2.
  In DB2 component, for DB2_USER_APPL_x, DB2_USER_TRAN_x,
  DB2_APPLICATION_x, and DB2_TRANSACTION_x tables;
  Update the following columns:
  BP4K_HPOOL_READ_SU
  BP4K_HPOOL_READ_UN
  BP4K_HPOOL_WRIT_SU
  BP4K_HPOOL_WRIT_UN
  BP4K_HPOOL_AREAD
  We will be setting these columns to NULL after we apply the
  change.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: TDSz/IZDS users of the DB2 Component,        *
  *                 4 Accounting and Response Time Statistic     *
  *                 subcomponent and Analytics - DB2 component,  *
  *                 4 Accnt & RespTime subcomponent for V181,    *
  *                 V182 and V190.                               *
  ****************************************************************
  * PROBLEM DESCRIPTION: Wrong values on Hiperpool columns       *
  *                      getting values from fields QBACHRE,     *
  *                      QBACHRF, QBACHWR, QBACHWF and QBACHPG   *
  *                      of SMF_101 record which are no longer   *
  *                      supported by DB2.                       *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  The fields QBACHRE, QBACHRF, QBACHWR, QBACHWF and QBACHPG of
  SMF_101 record are no longer supported in DB2 record but are
  still used on TDSz / IZDS code.
  

Problem conclusion

• The following change are done for this APAR:
  
  1. Change the value for the fields
     BP4K_HPOOL_READ_SU, BP4K_HPOOL_READ_UN,
     BP4K_HPOOL_WRIT_SU, BP4K_HPOOL_WRIT_UN,
     BP4K_HPOOL_AREAD, BP32_HPOOL_READ_SU,
     BP32_HPOOL_READ_UN, BP32_HPOOL_WRIT_SU,
     BP32_HPOOL_WRIT_UN, BP32_HPOOL_AREAD,
     BP8K_HPOOL_READ_SU, BP8K_HPOOL_READ_UN,
     BP8K_HPOOL_WRIT_SU, BP8K_HPOOL_WRIT_UN,
     BP8K_HPOOL_AREAD, BP16_HPOOL_READ_SU,
     BP16_HPOOL_READ_UN, BP16_HPOOL_WRIT_SU,
     BP16_HPOOL_WRIT_UN and BP16_HPOOL_AREAD
     to set to NULL for DB2 V8 and up in the following table:
     A_DB2_UT_BP_I (only for V181, V182 and V190),
     DB2_APPLICATION_H,
     DB2_APPLICATION_W,
     DB2_TRANSACTION_D
     DB2_TRANSACTION_W
     DB2_USER_APPL_H
     DB2_USER_APPL_W
     DB2_USER_TRAN_D
     DB2_USER_TRAN_H
  
  2. Update the System Performance Feature Reference Volume I
     to change the comment for the updated fields.
  

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:

  UI68777 UI68780 UI68781 UI68782

Modules/Macros

• DRLTA2D4 DRLTD2A  DRLTD2B2 DRLTD2BA DRLTD2T  DRLTD2UA DRLTD2UT
  DRLUA2D4 DRLVA2D4
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• R80A PSY UI68781

     UP20/04/04 P F004

• R8A0 PSY UI68782

     UP20/04/04 P F004

• R8A9 PSY UI68780

     UP20/04/04 P F004

• R9A0 PSY UI68777

     UP20/04/04 P F004

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.