SQL request detail line
These lines appear under a CICS® program detail line. Each line represents an SQL request issued by the program identified in the name field of the CICS program line under which these lines are grouped.
| Under Heading | This is Displayed |
|---|---|
| Name | The hexadecimal offset in the identified CICS program of the return address of the EXEC SQL command. This is in +xxxx format. This field is always displayed in red. |
| Description | The SQL request function – SELECT, FETCH, UPDATE, etc. |
| Execution | The mean time, in seconds, that CPU execution was observed while the SQL request was being processed. |
| Suspend | The mean time, in seconds, that CICS had suspended execution of the transaction while the SQL request was being processed. |
| Delay | The mean time, in seconds, that execution of
the transaction was delayed while the SQL request was being processed.
Transaction execution can be delayed for one of the following
reasons:
|
| Service | The mean service time for the transaction the SQL request was being processed. This includes execution, suspend and delay time. |