PK59970: TDSZ UAC - REPORT ADDITIONAL CPU USAGE IN THE DB2 TCB TIME

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The DRLCDB2 program reports TCB time in the ZZ32 Rate code.
  The TCB time is calculated from the SMF 101 record QWACBJST and
  QWACEJST fields. By subtracting the beginning time from the
  ending time (QWACEJST - QWACBJST) the TCB CPU time is produced.
  
  There are additional fields in the SMF 101 record that contain
  CPU usage:
  
     QWACTRTE = the accumulated CPU time consumed while executing
     triggers on a nested task.
  
     QWACTRTT = the accumulated CPU time consumed while executing
     triggers on the main application execution unit.
  
     QWACSPCP = the accumulated CPU time used to satisfy stored
     procedure requests processed in a DB2 stored procedure WLM
     address space.
  
  Invalid time fields in the SMF 101 record are producing
  inaccurate TCB times, (QWACEJST - QWACBJST). APAR PK46171 is
  available to correct the times fields when the SMF 101
  record is created.
  
  
  The SMF 101 records are written based on an accounting reason,
  QWACRINV. CIMSDB2 will selectively calculate the TCB time
  (QWACEJST - QWACBJST) based on the QWACRINV. The criteria used
  for QWACRINV was too restrictive and TCB time could be under
  reported.
  

Local fix

• Invalid TCB time produced by the invalid times in the SMF 101
  records is corrected by APAR PK46171.
  
  A DRLCDB2 control statement is available to adjust the
  accounting reasons check used to verify valid end times. The
  following control statement causes the TCB calculation to be
  done when the QWACRINV is 20 or less:
  
  
            ACCOUNT DB2 CRINV < 21
  
  All SMF 101 records with a QWACRINV value greater than 20 may
  have invalid end times (QWACEJST).
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Decision Support UAC customers    *
  *                 using the DB2 feature                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: Missing DB2 CPU time in rate code ZZ32  *
  ****************************************************************
  * RECOMMENDATION: APPLY THE PTF FIXING THIS APAR               *
  ****************************************************************
  The following SMF 101 fields were not available for CPU
  Calculation: QWACTRTE, QWACTRTT and QWACSPCP
  

Problem conclusion

• Added support for additional precision of DB2 resources and new
  options for the CPU resource.
  New control statements were added with the new CIMSDB2 program.
  
  CPU TIME= TCB TRTE TRTT SPCP
  
  This control statement specifies now to calculate the CPU time.
  The CIMS standard is to use the TCB time
  (SRB time is no longer set by DB2).
  
  The TCB time is calculated from the SMF 101 record fields
  QWACBJST and QWACEJST. The TCB CPU time is produced by
  subtracting the beginning time from the ending time
  (QWACEJST - QWACBJST).
  
  The TRTE, TRTTT and SPCP options are used to reference the
  SMF 101 record  fields QWACTRTE, QWACTRTT and QWACSPCP. When
  these options are specified, the values in the associated
  fields will be included in the CPU calculation.
  
  QWACTRTE = the accumulated CPU time consumed while executing
  triggers on a nested task.
  
  QWACTRTT = the accumulated CPU time consumed while executing
  triggers on the main application execution unit.
  
  QWACSPCP = the accumulated CPU time used to satisfy stored
  procedure requests processed in a DB2 stored procedure WLM
  address space.
  
  The CIMSDB2 program will produce a transaction CPU value
  (rate code = ZZ32) that includes the sum of the TCB CPU time,
  accumulated CPU time executing triggers, and accumulated CPU
  time used to satisfy stored procedure requests processed in a
  DB2 stored procedure WLM address space. Use the following
  control statement:
  
  Example
  CPU TIME=TCB TRTE SPCP
  
  The following control statement has been added:
  
  CPU HIGH PRECISION
  This control statement changes the precision used to calculate
  the CPU and elapsed times. The normal precision uses the
  DB2 STCK times using a stepping interval of .000016 seconds.
  Specifying the CPU HIGH PRECISION control statement will change
  the precision so that the 8-byte store clock value is used with
  a stepping interval of a clock unit (approximately 244
  picoseconds). The resource values produced with this option
  may be different than those produced with the normal precision,
  but should be more accurate. The values written to the 791
  record are still maintained in seconds with 6 decimal places
  of precision, but the summarization done by CIMSDB2 will include
  the 8-byte store clock value.
  

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:

  UK34755

Modules/Macros

• DRLCDB2
  

Fix information

• Fixed component name

  TDS FOR Z/OS

• Fixed component ID

  569510100

Applicable component levels

• R801 PSY UK34755

     UP08/03/26 P F803

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.