PH41728: ELAPSED_SEC_CL1 & ELAPSED_SEC_CL2 INCORRECT OUTPUT ON KPM_DB2_ENDUSER_H TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ELAPSED_SEC_CL1 & ELAPSED_SEC_CL2 have incorrect output on
  KPM_DB2_ENDUSER_H table. The update definition ends up counting
  intervals with the TIME1900 variable causing the intervals to be
  large.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Decision Support for zOS (TDS)    *
  *                 Version 1.8.2, IBM Z Decision Support (IZDS) *
  *                 and IBM Z Performance and Capacity Analytics *
  *                 (IZPCA) using the component                  *
  *                 Key Performance Metrics - DB2.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: For some Db2 transactions the time      *
  *                      value (seconds) in field                *
  *                      ELAPSED_SEC_CL1 is much larger than the *
  *                      actual elapsed time shown in the job    *
  *                      output.                                 *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  The fields ELAPSED_SEC_CL1 and ELAPSED_SEC_CL2 in tables
  KPM_DB2_USERTRAN_H and KPM_DB2_ENDUSER_H include the data from
  the Db2 record that contains the elapsed time of the Db2
  parallel tasks. This makes the apparent elapsed time longer
  than that recorded in the job log.
  

Problem conclusion

• New fields ELAPSED_SEC_CL1P and ELAPSED_SEC_CL2P are created in
  tables KPM_DB2_USERTRAN_H and KPM_DB2_ENDUSER_H which do not
  include the the data from the Db2 parallel tasks.
  

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:

  UI78138 UI78139 UI78140

Modules/Macros

• DRLTKD09 DRLTKD10 DRLUKD09 DRLUKD10
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• R8A9 PSY UI78138

     UP21/11/20 P F111

• R9A0 PSY UI78140

     UP21/11/20 P F111

• RCA0 PSY UI78139

     UP21/11/20 P F111

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.