CICS DB2: Summary resource statistics - request information

The request information gives details of how many requests of various types have been performed against each DB2ENTRY.

Table 1. CICS DB2: Summary resource statistics - request information
DFHSTUP name Description
DB2Entry Name is the name of the installed DB2ENTRY.

 

Call Count is the total number of SQL calls made using this DB2ENTRY.

 

Signon Count is the total number of DB2® signons performed for this DB2ENTRY.

 

Partial Signon is the total number of DB2 partial signons performed for this DB2ENTRY.

 

Commit Count is the total number of two phase commits performed for units of work using this DB2ENTRY.

 

Abort Count is the total number of units of work using this DB2ENTRY that were rolled back.

 

Single Phase is the total number of units of work using the DB2ENTRY that used single phase commit, either because they were read-only UOWs, or because DB2 was the only recoverable resource updated in the UOW.

 

Thread Reuse is the total number of times CICS® transactions using the DB2ENTRY were able to reuse an already created DB2 thread.

 

Thread Terms is the total number of terminate thread requests made to DB2 for threads of this DB2ENTRY.

 

Thread Waits/Overflows is the total number of times all available threads in the DB2ENTRY were busy and a transaction had to wait for a thread to become available, or overflow to the pool and use a pool thread instead.