PH07965: Support for DB2 Delta Statistics

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Support for DB2 Delta Statistics
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All IZDS and IZPCA users who want to         *
  *                 collect DB2 delta statistics metrics.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2 statistics (SMF type 100) are       *
  *                      cumulative, from the time a subsystem   *
  *                      starts until it is reported at the end  *
  *                      of an SMF interval. IZDS and IZPCA      *
  *                      collect this information "as is" to     *
  *                      the data tables, which makes reporting  *
  *                      on those values impractical.            *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  IZDS and IZPCA need to collect DB2 statistics applicable to
  the SMF interval.
  

Problem conclusion

Temporary fix

Comments

• The following changes are done for this APAR:
  
  1. New record procedure DRLSD64D for DB2 statistics records.
     This record procedure calculates the delta values for the
     fields with cumulative data by subtracting the previous
     reported value from the current reported value for each
     interval, and generates new internal records (SMF_100_0_X
     and SMF_100_1_X) which contain delta values applicable to
     the SMF interval.
  
  2. Record mappings SMF_100_0_X and SMF_100_1_X for new internal
     records create by record procedure DRLSD64D.
  
  3. New tables D_DB2_BUFF_POOL_T, D_DB2_BUFF_POOL_H,
     D_DB2_DATABASE_T, D_DB2_DATABASE_H, D_DB2_SYSTEM_T and
     D_DB2_SYSTEM_H in the DB2 component.
  
  4. New tables D_KPM_DB2_SYSTEM_T, D_KPM_DB2_SYSTEM_H,
     D_KPM_DB2_BP_T, D_KPM_DB2_BP_H, D_KPM_DB2_DBASE_T,
     D_KPM_DB2_DBASE_H, in the KPMDB2 component.
  
  5. New sub-components 2b Address Space Delta Statistics
     and 3b Buffer Pool Delta Statistics in the DB2 component.
  
  6. DB2 sub-components 2 Address Space Statistics and
     3 Buffer Pool Statistics renamed to 2a Address Space
     Statistics and 3a Buffer Pool Statistics.
  
  7. New sub-component DB2 System Level Delta Statistics in
     the Key Performance Metrics - DB2 component.
  
  8. System Performance Feature Reference Volume I updated
     to reflect these changes.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI63862 UI63863 UI75818 UI75819

Modules/Macros

• DRLDOD11 DRLIDB2  DRLIKDB2 DRLPIO   DRLPMG29 DRLPXW1W DRLRS100
  DRLSD64D DRLSDB41 DRLSDB42 DRLSIZRE DRLSKDDB DRLSSYS1 DRLTD2BD
  DRLTD2DD DRLTD2SA DRLTIZRE DRLTKD11 DRLTKD13 DRLTKD15 DRLUD2BD
  DRLUD2DD DRLUD2SA DRLUKD11 DRLUKD13 DRLUKD15
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• R901 PSY UI63862

     UP21/07/14 P F107

• R9A0 PSY UI63863

     UP21/07/14 P F107

• RC01 PSY UI75818

     UP21/07/14 P F107

• RCA0 PSY UI75819

     UP21/07/14 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.