Viewing data for a single thread
This section contains procedures for viewing data for a single thread using the STRAC display.
This section contains the following topics:
The Summary Trace Entry display, STRAC, shows summary data for this thread. It contains complete activity statistics from the DB2 accounting record. For a detail trace, there are also summaries of the captured detail events, such as SQL statements.
The most critical information is summarized in the base section, shown in the following figure. It includes:
- Identifiers
- Completion status
- Commits and rollbacks
- Runtime graphic analysis of elapsed and CPU times
- Most important activity counts
- Key indicators of failures or possible problems
BMC SOFTWARE -------------- SUMMARY TRACE ENTRY -----------PERFORMANCE MGMT
SERV ==> STRAC INPUT 09:15:13 INTVL=> 3 LOG=> N TGT==> JXODEHF
PARM ==> T121608,SEQ=1 ROW 1 OF 203 SCROLL=> CSR
EXPAND: MON(WKLD), DETAIL
ACCOUNTING: ENV, ELAP, SQLCNTS, BPOOL, LOCKS, PRLL, PKG, RTN, ACC, DDF
SUMMARIES: SQL, SCANS, IO/LOCK, SORTS
STOP.....13JUN 12.25.11.63 PLAN...............DSNTEP2 TYPE.........ACCELERATOR
START....13JUN 12.11.37.57 AUTHID............BOLJXO1 CONNECT........BATCH/TSO
ELAPSED...........00:13:34 ORIG PRIM AUTH....BOLJXO1 CORR ID.....BOLJXOAD
TERM........NORMAL/DEALLOC COMMITS..................1 ROLLBACKS..............0
------------------------------------------------------------------------------
RUNTIME ANALYSIS IN DB2 IN APPL. TOTAL %IN DB2(=) TOTAL(*)
---------------- -------- -------- -------- 0 ...25...50...75..100%
ELAPSED TIME 00:11:01 00:02:33 00:13:34 | ================**** |
CPU TIME 00:03:52 00:01:45 00:05:37 | |
DB2 WAIT TIME 00:04:46 | ======= |
- Specialty Engine CPU times - -
- In DB2 CPU 0 us 0 us | |
- STORED PROC 0 us
- UDF 0 us
- TRIGGER 0 us
- Accel-elig elpsd 0 us
- Eligible CPU 0 us
- Eligible zIIP 0 us
- - - - - - ACTIVITY - - - - - - - - - - - - KEY INDICATORS - - - - - - -
TOTAL SQL.................22,000K SQL: SELECT= 0, FETCH= 22M
GETPAGES......................176 ACCEL CONNECTS= 22, REQUESTS= 44
SYNC READS (PRLL=00)............0 SQL: DYNAMIC(PREPARE)= 24
PREFETCH PAGES READ.............0
UPDATES/COMMIT................0.0
BFR HIT RATIOS:...........VP=100%
LOG RECORDS WRITTEN.............0
SERV ==> STRAC INPUT 09:15:13 INTVL=> 3 LOG=> N TGT==> JXODEHF
PARM ==> T121608,SEQ=1 ROW 1 OF 203 SCROLL=> CSR
EXPAND: MON(WKLD), DETAIL
ACCOUNTING: ENV, ELAP, SQLCNTS, BPOOL, LOCKS, PRLL, PKG, RTN, ACC, DDF
SUMMARIES: SQL, SCANS, IO/LOCK, SORTS
STOP.....13JUN 12.25.11.63 PLAN...............DSNTEP2 TYPE.........ACCELERATOR
START....13JUN 12.11.37.57 AUTHID............BOLJXO1 CONNECT........BATCH/TSO
ELAPSED...........00:13:34 ORIG PRIM AUTH....BOLJXO1 CORR ID.....BOLJXOAD
TERM........NORMAL/DEALLOC COMMITS..................1 ROLLBACKS..............0
------------------------------------------------------------------------------
RUNTIME ANALYSIS IN DB2 IN APPL. TOTAL %IN DB2(=) TOTAL(*)
---------------- -------- -------- -------- 0 ...25...50...75..100%
ELAPSED TIME 00:11:01 00:02:33 00:13:34 | ================**** |
CPU TIME 00:03:52 00:01:45 00:05:37 | |
DB2 WAIT TIME 00:04:46 | ======= |
- Specialty Engine CPU times - -
- In DB2 CPU 0 us 0 us | |
- STORED PROC 0 us
- UDF 0 us
- TRIGGER 0 us
- Accel-elig elpsd 0 us
- Eligible CPU 0 us
- Eligible zIIP 0 us
- - - - - - ACTIVITY - - - - - - - - - - - - KEY INDICATORS - - - - - - -
TOTAL SQL.................22,000K SQL: SELECT= 0, FETCH= 22M
GETPAGES......................176 ACCEL CONNECTS= 22, REQUESTS= 44
SYNC READS (PRLL=00)............0 SQL: DYNAMIC(PREPARE)= 24
PREFETCH PAGES READ.............0
UPDATES/COMMIT................0.0
BFR HIT RATIOS:...........VP=100%
LOG RECORDS WRITTEN.............0
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*