PH47895: SMF 100 / 101 RFES

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• This APAR is for RFEs raised with new fields from SMF_100 / 101:
  
  RFE 152539
  Request for the SMF 100 field QW0225AT (IFCID 255) for thread
  count be added to the DB2_STORAGE tables.
  
  TS009307377
  Add field QWSAIIPT to table KPM_DB2_SYSTEM_T.
  
  This metric is useful to monitor DB2 I/O interrupt CPU usage.
  
  
  RFE 152643
  Add the following new fields on IZDS/IZPCA DB2 tables:
  
  QXSTSRT - Number of times RDS Sort was performed
  QXSTSRTL - Number of times RDS Sort used the IBM Integrated
  Accelerator for Z Sort
  QXSTMLFD - The number of times when a PREPARE request was
  satisfied because db2zai stabilized the statement.
  QXSTMLST - The number of times when db2zai sort feedback was
  used.
  INSERT_ALG_1 - Inserts performed via algorithm type 1
  INSERT_ALG_2 - Inserts performed via algorithm type 2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All IBM Z Decision Support (IZDS) V190 and   *
  *                 IBM Z Performance and Capacity Analytics     *
  *                 (IZPCA) V310 users of a number of Db2        *
  *                 tables.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Customers requesting, via RFEs       *
  *                         152539 and 152643, new fields from   *
  *                         the SMF 100 record are added to the  *
  *                         product Db2 tables.                  *
  *                                                              *
  *                      2. The record  procedure DRLSD64D       *
  *                         produces incorrect results with      *
  *                         Db2 V12 or V13 records.              *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTFs and follow the       *
  *                 HOLD ACT instructions.                       *
  ****************************************************************
  1. New fields in the SMF 100 record introduced in Db2 v12 and
     v13 are added to product Db2 tables.
  
  2. Changes are made to the Db2 record procedure DRLSD64D to
     support the new fields introduced in Db2 v12 and v13.
  

Problem conclusion

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:

  UI82034 UI82035 UI82036 UI82037

Modules/Macros

• DRLIDB2  DRLIKDB2 DRLRS100 DRLSD64D DRLTD2D  DRLTD2DD DRLTD2ST
  DRLTKD01 DRLTKD05 DRLTKD06 DRLTKD11 DRLUD2DD DRLUKD01 DRLUKD05
  DRLUKD06 DRLUKD11
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• R901 PSY UI82036

     UP22/08/25 P F208

• R9A0 PSY UI82037

     UP22/08/25 P F208

• RC01 PSY UI82034

     UP22/08/25 P F208

• RCA0 PSY UI82035

     UP22/08/25 P F208

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.