PH42405: PKG_ELAPSED_SEC INCORRECT OUTPUT ON KPM_DB2_PACKAGE_H TABLE

APAR status

• Closed as program error.

Error description

• The update definition ends up counting intervals with the
  TIME1900 variable causing the intervals to be large.
  PKG_ELAPSED_SEC from KPM_DB2_PACKAGE_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.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All IBM Z Decision Support (IZDS)            *
  *                 and IBM Z Performance and Capacity Analytics *
  *                 (IZPCA) customers using the component        *
  *                 Key Performance Metrics - DB2.               *
  ****************************************************************
  * PROBLEM DESCRIPTION: For some Db2 transactions the time      *
  *                      value (seconds) in field                *
  *                      PKG_ELAPSED_SEC of table                *
  *                      KPM_DB2_PACKAGE_H is much larger than   *
  *                      the actual elapsed time shown in the    *
  *                      job output.                             *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  The fields PKG_ELAPSED_SEC and PKG_CP_CPU_SEC in tables
  KPM_DB2_PACKAGE_H, _D, _W include the data from the Db2 record
  that contains the elapsed time of the Db2 parallel roll up
  tasks. This makes the apparent elapsed time longer than that
  recorded in the job log.
  

Problem conclusion

• New fields PKG_ELAPSED_SECP and PKG_CP_CPU_SECP are created in
  tables KPM_DB2_PACKAGE_H, _D, _W 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:

  UI80545 UI80546

Modules/Macros

• DRLTKD08 DRLUKD08
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels