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 total time, in seconds, during which CPU execution was observed while the SQL request was being processed. |
| Suspend | The total time, in seconds, during which CICS had suspended execution of the transaction while the SQL request was being processed. |
| Delay | The total time, in seconds, during which 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 total service time for the transaction during which the SQL request was being processed. This includes execution, suspend and delay time. |