SQL request detail line

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 mean time, in seconds, CPU execution was observed while the SQL request was being processed.
Suspend	The mean 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 fourth-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: CICS The CICS region was busy processing other transactions and could not dispatch this transaction. MVSWait The entire region was in a wait for an MVS™ service. MVSBusy The MVS system was busy and did not dispatch the CICS region. CICSSusp The transaction has been suspended by CICS while waiting on a resource.
Service	The mean service time for the transaction the SQL request was being processed. This includes execution, suspend and delay time.