A fix is available
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 number
PK59970
Reported component name
TDS FOR Z/OS
Reported component ID
569510100
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2008-01-25
Closed date
2008-03-20
Last modified date
2008-04-01
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.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS2DUM","label":"IBM Z Decision Support"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"801","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}},{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEQQC","label":"IBM Z Decision Support for Capacity Planning"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"801","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
01 April 2008