The figure shows transaction response times.
More specifically, it shows the events that occur during the transaction
and what type of elapsed time is recorded during these events. The
accounting trace reports on three classes of times:
- Class 1 is standard accounting data. It records the application elapsed time.
- Class 2 is elapsed and processor time in Db2®.
- Class 3 is elapsed wait time in Db2.
The following list summarizes the events that
occur during a typical transaction that involves two SQL statements:
- User Presses enter. End user response time begins.
- Line transmit. CICS® or IMS elapsed time begins.
- TP monitor and application code. Db2 total transit time begins.
- First SQL statement. Transaction enters Db2.
- Create thread. Class 1 application time begins. Class 2 in Db2 time begins.
- First SQL statement completes. Transaction exits Db2. Class 2 in Db2 time ends. Transaction exits Db2.
- Second SQL statement. Transaction enters Db2. Class 2 in Db2 time begins. Class 3 wait time begins.
- Second SQL statement is processed. Class 3 wait time ends.
- Second SQL statement processing ends. Class 3 wait time begins.
- Second SQL statement completes. Transaction exits Db2. Class 2 in Db2 time ends. Class 3 wait time ends.
- End of transaction. Commit Phase 1 begins. Transaction enters Db2. Class 2 in Db2 time begins. After short delay, class 3 wait time begins.
- Commit Phase 1 ends. Transaction exits Db2. Class 2 in Db2 time begins. Class 3 wait time ends.
- Commit Phase 2 begins. Transaction enters Db2. Class 2 in Db2 time begins. Class 3 wait time begins.
- Class 3 wait time ends.
- Terminate thread. Class 1 application time ends. Class 2 in Db2 time ends.
- Transaction exits Db2
- TP monitor and application code. Db2 total transit time ends.
- Line transmit. CICS or IMS elapsed time ends.
- User receives response. End user response time ends.