These lines appear under a CICS® Program detail line. Each one 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, CPU execution was observed while the SQL request was being processed. |
Suspend | The total time, in seconds, CICS had suspended execution of the transaction while the SQL request was being processed. |
Delay | The mean time, in seconds, execution of the
transaction was delayed. This is a fifth-level detail line shown directly
under the CICS transaction detail line. This line represents
a CICS resource type or a wait type. The complete
list of resource types is documented in the CICS Transaction Server for z/OS® Problem
Determination Guide
The most common wait types include:
|
Service | The total service time for the transaction the SQL request was being processed. This includes execution, suspend and delay time. |