This table provides daily and weekly statistics on DB2 transactions grouped by transaction. They contain accounting and response time data based on SMF type 101 records (DB2 accounting, IFCID 0003).
The following comprises a list of the attributes for this attribute group. The name in bold text shows how the attribute appears in the Tivoli Enterprise Portal.
Node The managed system name of the agent.
Timestamp The value is the time collected from the agent system when the data row was built and sent from the agent to the Tivoli Enterprise Monitoring Server (or stored for historical purposes). It represents the local time zone of the agent system.
Date Date when the accounting records were collected by SMF. From SM101DTE.
Period Name Name of the period. This is derived using SM101DTE and SM101TME as parameters in the PERIOD function.
MVS System ID MVS system ID. This is the SMF system ID. From SM101SID.
DB2 System ID DB2 system ID. This is the SMF subsystem ID. From SM101SSI.
Correlation ID Correlation ID value. From QWHCCV.
DB2 Plan Name Plan name. From QWHCPLAN.
Unsuccessful DB2 Threads Number of DB2 threads that completed unsuccessfully. This is the count of SMF type 101 accounting records with unsuccessful completion (QWACRINV >= 20).
Abort Count Number of abort requests. This is the sum of QWACABRT.
Row Trigger Activations Number of times a row trigger was activated. New with DB2 V6. From QXROWTRG.
SQL Trigger Activations Number of times a statement trigger was activated. New with DB2 V6. From QXSTTRG.
Commit Count Number of successful commits. This is the sum of QWACCOMM.
Highest CPU Time Used Highest CPU time (in 16-microsecond timer units) used in a successful DB2 call, rather than a single SQL call. This is the maximum of QTXACHUS.
Accumulated DB2 Elapsed Time Accumulated DB2 elapsed time, in seconds. This column contains a value only if accounting class 2 is started. Calculated as the sum of QWACASC/4096000000.
Total Elapsed Time Total elapsed time (class 1) of the application, in seconds. Calculated as the sum of the time intervals from QWACBSC to QWACESC.
Implicit Prepares The number of times an implicit prepare was performed because KEEPDYNAMIC(YES) option was used and an OPEN, EXECUTE or DESCRIBE of a dynamic statement occurred but DB2 no longer had a valid copy of the prepared statement. Sum of QXSTIPRP.
IO Wait Time for Database Accumulated DB2 elapsed time, in seconds. This column contains a value only if accounting class 2 is started. Calculated as the sum of QWACASC/4096000000.
IO Wait Time for Thread Accumulated I/O elapsed wait time for I/O under this thread, in sec. Up to DB2 V5 it is the sum of QWACAWTI/4096E6. From V6 on, the sum of (QWACAWTI+QWACAWLG)/4096E6, since V6 splits the wait for I/O into wait for log write I/O and wait for database I/O.
Successful DB2 Threads Number of DB2 threads that completed successfully. This is the count of SMF type 101 accounting records with successful completion (QWACRINV smaller or = 16).
Satisfied Prepare Requests The number of times a PREPARE request was satisfied by making a copy from the prepared statement cache. This is the sum of QXSTFND.
Row Access to Index Number of times that DB2 tried to use direct row access but used an index instead. New with DB2 V6. From QXROIIDX.
Row Access to Table Space Number of times that DB2 tried to use direct row access but used a table space scan instead. New with DB2 V6. From QXROITS.
Successful Direct Row Access Number of times that DB2 used direct row access successfully. New with DB2 V6. From QXROIMAT.
Accumulated DB2 TCB Time Accumulated DB2 TCB time, in seconds. This column contains a value only if accounting class 2 is started. Calculated as the sum of QWACAJST/4096000000.
Total CPU TCB Time Total CPU time (class 1) spent for TCB execution, in seconds. Calculated as the sum of the time intervals from QWACBJST to QWACEJST.