Transaction Delays view (IDLTR)
In the Transaction Delays view the Avg Resp field shows the average amount of time that units of work associated with each transaction spent in execution.
You can use the IDLTR view to quickly determine if there is a processing event problem.
The columns to the right break down the delays that occurred. A high percentage in any of the columns indicates where a potential problem could be. For example, if the I/O delay percentage is high, the transaction may be waiting for a device. You can hyperlink from the %I/O Dly field to access a more detailed view of I/O delays and look for potential causes.
You can access the IDLTR view by hyperlinking from the:
- Resp Time field in the DBCDTLGR view
- Tran Delay Factors option in the DBCTL Menu (DBCMP)
COMMAND ===> SCROLL ===> CSR
CURR WIN ===> 1 ALT WIN ===>
>W1 =IDLTR=============I13H51CT=*========06AUG2013==13:26:56====MVIMS====D===17
IMS Arrv Proc Resp %Inp % CPU CPU I/O Lck Lth Pol Oth DB2
Trancode ID Rate Rate Avg Que Elap Act Dly Dly Dly Dly Dly Dly Dly
APPL0007 I13H 0.357 0.357 0.0500 86 14 6 6 6
APPL0008 I13H 0.356 0.356 0.0165 94 6 3 3
APPL0009 I13H 0.357 0.357 0.0575 95 5 3 3
APPL0017 I13H 0.326 0.326 0.0403 86 14 4 14 4 4
APPL0018 I13H 0.320 0.320 0.0143 89 11
APPL0019 I13H 0.321 0.321 0.0460 87 13 4 9 4
APPL0027 I13H 0.302 0.302 0.0690 91 9 2 2 2 2 2
APPL0028 I13H 0.303 0.303 0.0212 93 7
APPL0029 I13H 0.302 0.302 0.0763 96 4
APPL0037 I13H SQ 0.213 0.0415 84 16 8 8
APPL0038 I13H SQ 0.213 0.0160 91 9
APPL0039 I13H SQ 0.216 0.0532 92 8 8
IMFT1H I13H 0.029 0.000
IVTNO I13H SQ 1.083 0.0229 63 37 5 2 14 5 26
IVTNV I13H 0.741 0.742 0.0224 62 38 9 9 24 19
THDAMINQ I13H 0.030 0.030 0.1066 4 75 100
THDAMUPD I13H 0.104 0.104 0.0274 54 46 46
The following hyperlinks are provided on the view:
Hyperlink from | To access |
|---|---|
Trancode | Transaction Delay Menu (IDLMT), where you can access more detailed information about transaction delays |
I/O Dly | I/O Delays by Transaction (IDLTRIO), which displays the percentage of elapsed time an I/O event contributed to the transaction's response time |
Lck Dly | Lock Delays by Transaction (IDLTRLK) displays the transactions being delayed by lock waits and the effect each lock has on response time |
Lth Dly | Latch Delays by Transaction (IDLTRLH), which displays the transactions being delayed by latch waits and the effect each latch has on response time |
Pol Dly | Pool Delays by Transaction (IDLTRPL), which displays the percentage of elapsed time a storage wait for a pool contributed to a transaction's response time |
Oth Dly | Other Delays by Transaction (IDLTROT) identifies any delays that are not displayed in the other delay views |
DB2 Dly | DB2 Delays by Transaction (IDLTRDB2), which displays the percentage of elapsed time DB2 processing waits contributed to transaction response time |
Related topic