CICS DB2 statistics

This section contains the following statistics:

CICS DB2: Global statistics

These statistics can be accessed online using the EXEC CICS® COLLECT STATISTICS DB2CONN command, and are mapped by the DFHD2GDS DSECT. For programming information about the EXEC CICS COLLECT STATISTICS command, see the CICS System Programming Reference manual.

Table 21. CICS DB2: Global statistics
DFHSTUP name Field name Description
DB2® Connection Name D2G_DB2CONN_NAME is the name of the installed DB2CONN.

Reset characteristic: not reset

 

DB2 Groupid D2G_DB2_GROUP_ID is the name of a data sharing group of DB2 subsystems, specified in the installed DB2CONN definition. CICS connects to any active member of this group. If CICS is connected to DB2, or is waiting to reconnect to a specific DB2 subsystem to resynchronize outstanding units of work, D2G_DB2_ID shows the member of the data sharing group that has been chosen.

Reset characteristic: not reset

 

Resync Group Member D2G_RESYNCMEMBER specifies the action CICS takes if you are using group attach, with a DB2 group ID (D2G_DB2_GROUP_ID) set, and outstanding units of work are being held for the last DB2 data sharing group member to which CICS was connected. 'Yes' means that CICS reconnects to the last connected DB2 data sharing group member. 'No' means that CICS makes one attempt to reconnect to the last connected DB2 data sharing group member, and if that attempt fails, it connects to any member of the DB2 data sharing group. If you are not using group attach, this DSECT field contains nulls (which are shown as N/A in the reports).

Reset characteristic: not reset

 

DB2 Sysid D2G_DB2_ID is the name of the DB2 subsystem that CICS is connected to, or if a DB2 subsystem ID is specified in the installed DB2CONN definition, the DB2 subsystem that CICS will connect to. If a DB2 group ID (D2G_DB2_GROUP_ID) is specified in the installed DB2CONN definition instead of a DB2 subsystem ID, and CICS is not currently connected to DB2, D2G_DB2_ID is normally blank. However, if a DB2 group ID is specified, but CICS is waiting to reconnect to a specific DB2 subsystem to resynchronize outstanding units of work, D2G_DB2_ID shows the ID of the DB2 subsystem to which CICS is waiting to reconnect.

Reset characteristic: not reset

 

DB2 Connect Date / Time D2G_CONNECT_TIME_LOCAL is the local time when CICS connected to DB2. The DFHSTUP report expresses this time as hh:mm:ss; however the DSECT field contains the time as a local store clock (STCK) value.

Reset characteristic: not reset

 

DB2 Disconnect Date / Time D2G_DISCONNECT_TIME_ LOCAL is the local time when CICS disconnected from DB2. The DFHSTUP report expresses this time as hh:mm:ss; however the DSECT field contains the time as a local store clock (STCK) value. The disconnect time will only be present in DB2CONN unsolicited statistics records produced when the CICS DB2 interface is shutdown, after which the time field is cleared to nulls (which are shown as N/A in the reports).

Reset characteristic: not reset

 

DB2 Release D2G_DB2_RELEASE is the version and release level of the DB2 subsystem that CICS is connected to. If CICS is not currently connected to DB2 the DSECT field contain nulls (which are shown as N/A in the reports).

Reset characteristic: not reset

 

TCB Limit D2G_TCB_LIMIT is the maximum number of TCBs that can be used by the CICS-DB2 attachment facility.

Reset characteristic: not reset

 

Start of changeCurrent number of connectionsEnd of change D2G_TCB_CURRENT Start of changeis the current number of connections Start of changeassociated with OPEN TCBsEnd of change used by the CICS-DB2 attachment facility.

Reset characteristic: not reset

 

End of change
Start of changePeak number of connectionsEnd of change D2G_TCB_HWM Start of changeis the peak number of connections Start of changeassociated with OPEN TCBsEnd of change used by the CICS-DB2 attachment facility.

Reset characteristic: reset to current value (D2G_TCB_CURRENT)

 

End of change
Start of changeCurrent number of free connectionsEnd of change D2G_TCB_FREE Start of changeis the number of free connections available for use with CICS open TCBs.

Reset characteristic: not reset

 

End of change
Current number of tasks on the TCB Readyq D2G_TCB_READYQ_ CURRENT is the number of CICS tasks queued waiting because the TCBLIMIT specified in the DB2CONN has been reached.

Reset characteristic: not reset

 

Peak number of tasks on the TCB Readyq D2G_TCB_READYQ_HWM is the peak number of CICS tasks queued waiting because the TCBLIMIT specified in the DB2CONN has been reached.

Reset characteristic: reset to current value (D2G_TCB_READYQ_CURRENT)

 

Pool Thread Plan name D2G_POOL_PLAN_NAME is the name of the plan used for the pool. If a dynamic plan exit is being used for the pool this DSECT field will be nulls (which are shown as N/A in the reports).

Reset characteristic: not reset

 

Pool Thread Dynamic Planexit name D2G_POOL_PLANEXIT_NAME is the name of the dynamic plan exit to be used for the pool. If a static plan is being used for the pool this DSECT field will be nulls (which are shown as N/A in the reports).

Reset characteristic: not reset

 

Pool Thread Authtype D2G_POOL_AUTHTYPE is the type of id to be used for DB2 security checking for pool threads. If an Authid is being used for pool threads this DSECT field contains nulls (which are shown as N/A in the reports).

Reset characteristic: not reset

 

Pool Thread Authid D2G_POOL_AUTHID is the static id to be used for DB2 security checking for pool threads. If an Authtype is being used for pool threads this DSECT field contains nulls (which are shown as N/A in the reports).

Reset characteristic: not reset

 

Pool Thread Accountrec setting D2G_POOL_ACCOUNTREC specifies the frequency of DB2 accounting records to be produced for transactions using pool threads.

Reset characteristic: not reset

 

Pool Thread Threadwait setting D2G_POOL_THREADWAIT specifies whether transactions should wait for a pool thread or be abended if the number of active pool threads exceed the pool thread limit.

Reset characteristic: not reset

 

Pool Thread Priority D2G_POOL_PRIORITY is the priority of the pool thread subtasks relative to the CICS main task (QR TCB). If CICS is connected to DB2 Version 6 or later, this field contains zero, representing not applicable (which is shown as N/A in the reports).

Reset characteristic: not reset

 

Number of calls using Pool Threads D2G_POOL_CALLS is the number of SQL calls made using pool threads.

Reset characteristic: reset to zero

 

Number of Pool Thread Signons D2G_POOL_SIGNONS is the number of DB2 signons performed for pool threads.

Reset characteristic: reset to zero

 

Number of Pool Thread Partial Signons D2G_POOL_PARTIAL_SIGNONS is the number of DB2 partial signons performed for pool threads.

Reset characteristic: reset to zero

 

Number of Pool Thread Commits D2G_POOL_COMMITS is the number of two phase commits performed for units of work using pool threads.

Reset characteristic: reset to zero

 

Number of Pool Thread Aborts D2G_POOL_ABORTS is the number of units of work using pool threads that were rolled back.

Reset characteristic: reset to zero

 

Number of Pool Thread Single Phases D2G_POOL_SINGLE_PHASE is the number of units of work using pool threads that used single phase commit, either because they were read-only UOWs, or because DB2 was the only recoverable resource updated in the UOW.

Reset characteristic: reset to zero

 

Number of Pool Thread Reuses D2G_POOL_THREAD_REUSE is the number of times CICS transactions using the pool were able to reuse an already created DB2 thread. This count includes transactions that overflow to the pool to acquire a thread and reuse an existing thread.

Reset characteristic: reset to zero

 

Number of Pool Thread Terminates D2G_POOL_THREAD_TERM is the number of terminate thread requests made to DB2 for pool threads. This includes pool threads used by transactions that overflow to the pool.

Reset characteristic: reset to zero

 

Number of Pool Thread Waits D2G_POOL_THREAD_WAITS is the number of times all available threads in the pool were busy and a transaction had to wait for a thread to become available. This count includes transactions that overflow to the pool to acquire a thread and have to wait for a pool thread.

Reset characteristic: reset to zero

 

Current Pool Thread Limit D2G_POOL_THREAD_LIMIT is the current maximum number of pool threads allowed.

Reset characteristic: not reset

 

Current number of Pool Threads in use D2G_POOL_THREAD_CURRENT is the current number of active pool threads.

Reset characteristic: not reset

 

Peak number of Pool Threads in use D2G_POOL_THREAD_HWM is the peak number of active pool threads.

Reset characteristic: reset to current value (D2G_POOL_THREAD_CURRENT)

 

Current number of Pool tasks D2G_POOL_TASK_CURRENT is the current number of CICS tasks that are using a pool thread.

Reset characteristic: not reset

 

Peak number of Pool tasks D2G_POOL_TASK_HWM is the peak number of CICS tasks that have used a pool thread.

Reset characteristic: reset to current value (D2G_POOL_TASK_CURRENT)

 

Total number of Pool tasks D2G_POOL_TASK_TOTAL is the total number of completed tasks that have used a pool thread.

Reset characteristic: reset to zero.

 

Current number of tasks on the Pool Readyq D2G_POOL_READYQ_ CURRENT is the current number of CICS tasks waiting for a pool thread to become available.

Reset characteristic: not reset

 

Peak number of tasks on the Pool Readyq D2G_POOL_READYQ_HWM is the peak number of CICS tasks that waited for a pool thread to become available.

Reset characteristic: reset to current value (D2G_POOL_READYQ_CURRENT)

 

Command Thread Authtype D2G_COMD_AUTHTYPE is the type of id to be used for DB2 security checking for command threads. If an Authid is being used for command threads this DSECT field contains nulls (which are shown as N/A in the reports).

Reset characteristic: not reset

 

Command Thread Authid D2G_COMD_AUTHID is the static id to be used for DB2 security checking for command threads. If an Authtype is being used for command threads this DSECT field contains nulls (which are shown as N/A in the reports).

Reset characteristic: not reset

 

Number of calls using Command Threads D2G_COMD_CALLS is the number of DB2 commands issued using the DSNC transaction.

Reset characteristic: reset to zero

 

Number of Command Thread Signons D2G_COMD_SIGNONS is the number of DB2 signons performed for command threads.

Reset characteristic: reset to zero

 

Number of Command Thread Terminates D2G_COMD_THREAD_TERM is the number of terminate thread requests made to DB2 for command threads.

Reset characteristic: reset to zero

 

Number of Command Thread Overflows to Pool D2G_COMD_THREAD_OVERF is the number of times a DSNC DB2 command resulted in a pool thread being used because the number of active command threads exceed the command thread limit.

Reset characteristic: reset to zero

 

Command Thread Limit D2G_COMD_THREAD_LIMIT is the current maximum number of command threads allowed.

Reset characteristic: not reset

 

Current number of Command Threads D2G_COMD_THREAD_ CURRENT is the current number of active command threads.

Reset characteristic: not reset

 

Peak number of Command Threads D2G_COMD_THREAD_HWM is the peak number of active command threads.

Reset characteristic: reset to current value (D2G_COMD_THREAD_CURRENT)

 

NOT IN THE DFHSTUP REPORT D2G_CONNECT_TIME_GMT is the Greenwich mean time (GMT) when CICS connected to DB2. The DFHSTUP report expresses this time as hh:mm:ss; however the DSECT field contains the time as a GMT store clock (STCK) value.

Reset characteristic: not reset

 

NOT IN THE DFHSTUP REPORT D2G_DISCONNECT_TIME_GMT is the Greenwich mean time (GMT) when CICS disconnected from DB2. The DFHSTUP report expresses this time as hh:mm:ss; however the DSECT field contains the time as a GMT store clock (STCK) value. The disconnect time will only be present in DB2CONN unsolicited statistics records produced when the CICS DB2 interface is shutdown, after which the time field is cleared to nulls (which are shown as N/A in the reports).

Reset characteristic: not reset

CICS DB2: Resource statistics

These statistics can be accessed online using the EXEC CICS COLLECT STATISTICS DB2ENTRY() command and are mapped by the DFHD2RDS DSECT. For programming information about the EXEC CICS COLLECT STATISTICS command, see the CICS System Programming Reference manual.

There are three sections in the DFHSTUP report for CICS DB2 resource statistics:

CICS DB2: Resource statistics - resource information

The resource information gives details of various attribute settings of each DB2ENTRY.

Table 22. CICS DB2 : Resource statistics - resource information
DFHSTUP name Field name Description
DB2Entry Name D2R_DB2ENTRY_NAME is the name of the installed DB2ENTRY

Reset characteristic: not reset

 

Plan Name D2R_PLAN_NAME is the name of the plan used for this DB2ENTRY. If a dynamic plan exit is being used for the DB2Entry, this DSECT field will be nulls (which are shown as N/A in the reports).

Reset characteristic: not reset

 

PlanExit name D2R_PLANEXIT_NAME is the name of the dynamic plan exit to be used for this DB2ENTRY. If a static plan is being used for the DB2ENTRY this DSECT field will be nulls (which are shown as N/A in the reports).

Reset characteristic: not reset

 

Auth Id D2R_AUTHID is the static id to be used for DB2 security checking for this DB2ENTRY. If an Authtype is being used for the DB2ENTRY this DSECT field contains nulls (which are shown as N/A in the reports).

Reset characteristic: not reset

 

Auth Type D2R_AUTHTYPE is the type of id to be used for DB2 security checking for this DB2ENTRY. If an Authid is being used for the DB2ENTRY this DSECT field contains nulls (which are shown as N/A in the reports).

Reset characteristic: not reset

 

Account Records D2R_ACCOUNTREC specifies the frequency of DB2 accounting records to be produced for transactions using this DB2ENTRY.

Reset characteristic: not reset

 

Thread Wait D2R_THREADWAIT specifies whether transactions should wait for a thread, abend or overflow to the pool, if the number of active threads for this DB2ENTRY exceeds its thread limit.

Reset characteristic: not reset

 

Thread Prty D2R_PRIORITY is the priority of the DB2ENTRY thread subtasks relative to the CICS main task (QR TCB). If CICS is connected to DB2 Version 6 or later, this field contains zero, representing not applicable (which is shown as N/A in the reports).

Reset characteristic: not reset

 

CICS DB2: Resource statistics - request information

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

Table 23. CICS DB2: Resource statistics - request information
DFHSTUP name Field name Description
DB2Entry Name D2R_DB2ENTRY_NAME is the name of the installed DB2ENTRY

Reset characteristic: not reset

 

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

Reset characteristic: reset to zero

 

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

Reset characteristic: reset to zero

 

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

Reset characteristic: reset to zero

 

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

Reset characteristic: reset to zero

 

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

Reset characteristic: reset to zero

 

Single Phase D2R_SINGLE_PHASE is the 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.

Reset characteristic: reset to zero

 

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

Reset characteristic: reset to zero

 

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

Reset characteristic: reset to zero

 

Thread Waits/Overflows D2R_THREAD_WAIT_ OR_OVERF is the 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.

Reset characteristic: reset to zero

 

CICS DB2: Resource statistics - performance information

The performance information gives details of Thread information for each DB2ENTRY.

Table 24. CICS DB2: Resource statistics - performance information
DFHSTUP name Field name Description
DB2Entry Name D2R_DB2ENTRY_NAME is the name of the installed DB2ENTRY

Reset characteristic: not reset

 

Thread Limit D2R_THREAD_LIMIT is the current maximum number of threads allowed for the DB2ENTRY.

Reset characteristic: not reset

 

Thread Current D2R_THREAD_CURRENT is the current number of active threads for this DB2ENTRY.

Reset characteristic: not reset

 

Thread HWM D2R_THREAD_HWM is the peak number of active threads for this DB2ENTRY.

Reset characteristic: reset to current value (D2R_THREAD_CURRENT)

 

Pthread Limit D2R_PTHREAD_LIMIT is the current maximum number of protected threads allowed for this DB2ENTRY.

Reset characteristic: not reset

 

Pthread Current D2R_PTHREAD_CURRENT is the current number of protected threads for this DB2ENTRY.

Reset characteristic: not reset

 

Pthread HWM D2R_PTHREAD_HWM is the peak number of protected threads for this DB2ENTRY.

Reset characteristic: reset to current value (D2R_PTHREAD_CURRENT)

 

Task Current D2R_TASK_CURRENT is the current number of CICS tasks that are using this DB2ENTRY.

Reset characteristic: not reset

 

Task HWM D2R_TASK_HWM is the peak number of CICS tasks that have used this DB2ENTRY.

Reset characteristic: reset to current value (D2R_TASK_CURRENT)

 

Task Total D2R_TASK_TOTAL is the total number of completed tasks that have used this DB2ENTRY.

Reset characteristic: reset to zero.

 

Readyq Current D2R_READYQ_CURRENT is the current number of CICS tasks waiting for a thread to become available on this DB2ENTRY.

Reset characteristic: not reset

 

Readyq HWM D2R_READYQ_HWM is the peak number of CICS tasks that waited for a thread to become available on this DB2ENTRY.

Reset characteristic: reset to current value (D2R_READYQ_CURRENT)

 

CICS DB2: Summary global statistics

Summary statistics are not available online.

Table 25. CICS DB2: Summary global statistics
DFHSTUP name Description
DB2 Connection Name is the name of the installed DB2CONN.

 

Total DB2 Connection time is the total amount of time CICS was connected to the DB2 subsystem specified in this DB2CONN. The time is displayed as days:hh:mm:ss.

 

DB2 Groupid is the name of a data sharing group of DB2 subsystems, specified in the installed DB2CONN definition. CICS connects to any active member of this group.

 

Resync Group Member specifies the action CICS takes if you are using group attach, with a DB2 group ID set, and outstanding units of work are being held for the last DB2 data sharing group member to which CICS was connected. 'Yes' means that CICS reconnects to the last connected DB2 data sharing group member. 'No' means that CICS makes one attempt to reconnect to the last connected DB2 data sharing group member, and if that attempt fails, it connects to any member of the DB2 data sharing group. If you are not using group attach, N/A is shown in the report.

 

DB2 Sysid is the name of the DB2 subsystem to which CICS connects, as specified in the installed DB2CONN definition. If the sysid has changed, it is the last setting of sysid.

 

DB2 Release is the DB2 version and release for this DB2CONN. If the version and release have changed, it is the last setting of version and release.

 

TCB Limit is the TCBLIMIT value that was set in the DB2CONN. If the TCBLIMIT has changed, it is the last setting of TCBLIMIT. The TCB limit is the maximum number of TCBs that can be used by the CICS-DB2 attachment facility.

 

Current number of Connections is the current number of connections used by the CICS-DB2 attachment facility.

 

Peak number of Connections is the peak number of connections used by the CICS-DB2 attachment facility.

 

Peak number of tasks on the TCB Readyq is the peak number of CICS tasks queued waiting because the TCBLIMIT specified in the DB2CONN has been reached.

 

Pool Thread Plan name is the name of the plan used for the pool. If the plan name has changed, it is the last setting of plan name. If a dynamic plan exit is being used for the pool, the summary report shows 'N/A'.

 

Pool Thread Dynamic Planexit name is the name of the dynamic plan exit to be used for the pool. If the dynamic plan exit name has changed, it is the last setting of dynamic planexit name. If static plan is being used for the pool, the summary report shows 'N/A'.

 

Pool Thread Authtype is the type of id to be used for DB2 security checking for pool threads. If the pool thread authtype has changed, it is the last setting of pool thread authtype. If an Authid is being used for pool threads, the summary report shows 'N/A'.

 

Pool Thread Authid is the static id to be used for DB2 security checking for pool threads. If the pool thread authid has changed, it is the last setting of pool thread authid. If an Authtype is being used for pool threads, the summary report shows 'N/A'.

 

Pool Thread Accountrec setting is the frequency of DB2 accounting records to be produced for transactions using pool threads. If the pool thread accountrec setting has changed, it is the last setting of pool thread accountrec.

 

Pool Thread Threadwait setting is the setting for whether transactions should wait for a pool thread or be abended if the number of active pool threads reaches the pool thread limit. If the pool thread threadwait setting has changed, it is the last setting of pool thread threadwait.

 

Pool Thread Priority is the priority of the pool thread subtasks relative to the CICS main task (QR TCB). If the pool thread priority has changed, it is the last setting of pool thread priority. If CICS is connected to DB2 Version 6 or later, this field contains zero (representing not applicable), and the summary report shows 'N/A'.

 

Total number of calls using Pool Threads is the total number of SQL calls made using pool threads.

 

Total number of Pool Thread Signons is the total number of DB2 signons performed for pool threads.

 

Total number of Pool Thread Partial Signons is the total number of DB2 partial signons performed for pool threads.

 

Total number of Pool Thread Commits is the total number of two phase commits performed for units of work using pool threads.

 

Total number of Pool Thread Aborts is the total number of units of work using pool threads that were rolled back.

 

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

 

Total number of Pool Thread Reuses is the total number of times CICS transactions using the pool were able to reuse an already created DB2 thread. This count includes transactions that overflow to the pool to acquire a thread and reuse an existing thread.

 

Total number of Pool Thread Terminates is the total number of terminate thread requests made to DB2 for pool threads. This includes pool threads used by transactions that overflow to the pool.

 

Total number of Pool Thread Waits is the total number of times all available threads in the pool were busy and a transaction had to wait for a thread to become available. This count includes transactions that overflow to the pool to acquire a thread and have to wait for a pool thread.

 

Pool Thread Limit is the thread limit value for the pool. If the pool thread limit has changed, it is the last setting of pool thread limit.

 

Peak number of Pool Threads in use is the peak number of active pool threads.

 

Peak number of Pool tasks is the peak number of CICS tasks that have used a pool thread.

 

Total number of Pool tasks is the total number of completed tasks that have used a pool thread.

 

Peak number of tasks on the Pool Readyq is the peak number of CICS tasks that waited for a pool thread to become available.

 

Command Thread Authtype is the type of id to be used for DB2 security checking for command threads. If the command thread authtype has changed, it is the last setting of command thread authtype. If an Authid is being used for command threads, the summary report shows 'N/A'.

 

Command Thread Authid is the static id to be used for DB2 security checking for command threads. If the command thread authid has changed, it is the last setting of command thread authid. If an Authtype is being used for command threads, the summary report shows 'N/A'.

 

Total number of Command Thread Calls is the total number of DB2 commands issued through the DSNC transaction.

 

Total number of Command Thread Signons is the total number of DB2 signons performed for command threads.

 

Total number of Command Thread Terminates is the total number of terminate thread requests made to DB2 for command threads.

 

Total number of Command Thread Overflows is the total number of times a DSNC DB2 command resulted in a pool thread being used because the number of active command threads exceed the command thread limit.

 

Command Thread Limit is the maximum number of command threads allowed. If the command thread limit has changed, it is the last setting of command thread limit.

 

Peak number of Command Threads is the peak number of active command threads.

CICS DB2: Summary resource statistics

There are three sections in the DFHSTUP summary report for CICS DB2 resource statistics:

Summary statistics are not available online.

CICS DB2: Summary resource statistics - resource information

The resource information gives details of various attribute settings of each DB2ENTRY.

Table 26. CICS DB2: Summary resource statistics - resource information
DFHSTUP name Description
DB2Entry Name is the name of the installed DB2ENTRY.
Plan Name is the name of the plan used for this DB2ENTRY. If the plan name changed, it is the last setting of plan name. If a dynamic plan exit is being used for the DB2Entry, the summary report shows 'N/A'.
PlanExit Name is the name of the dynamic plan exit to be used for this DB2ENTRY. If the plan exit name has changed, it is the last setting of PlanExit name. If a static plan is being used for the DB2ENTRY, the summary report shows 'N/A'.
Auth Id is the static id to be used for DB2 security checking for this DB2ENTRY. If the Auth id changed, it is the last setting of Auth id. If an Authtype is being used for the DB2ENTRY, the summary report shows 'N/A'.
Auth Type is the type of id to be used for DB2 security checking for this DB2ENTRY. If the Auth type changed, it is the last setting of Auth type. If an Authid is being used for the DB2ENTRY, the summary report shows 'N/A'.
Account Records specifies the frequency of DB2 accounting records to be produced for transactions using this DB2ENTRY. If the frequency changed, it is the last frequency setting.
Thread Wait specifies whether transactions should wait for a thread, abend, or overflow to the pool, if the number of active threads for this DB2ENTRY exceeds its thread limit. If the threadwait changed, it is the last setting of threadwait.
Thread Prty is the priority of the DB2ENTRY thread subtasks relative to the CICS main task (QR TCB). If the priority changed, it is the last setting of priority. If CICS is connected to DB2 Version 6 or later, this field contains zero (representing not applicable), and the summary report shows 'N/A'.

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 27. 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.

 

CICS DB2: Summary resource statistics - performance information

The performance information gives details of thread information for each DB2ENTRY.

Table 28. CICS DB2: Summary resource statistics - performance information
DFHSTUP name Description
DB2ENTRY Name is the name of the installed DB2ENTRY

 

Thread Limit is the maximum number of threads allowed for the DB2ENTRY. If the value changed, it is the last setting of Thread limit.

 

Thread HWM is the peak number of active threads for this DB2ENTRY.

 

Pthread Limit is the maximum number of protected threads allowed for this DB2ENTRY. If the value changed, it is the last setting of Pthread limit.

 

Pthread HWM is the peak number of protected threads for this DB2ENTRY.

 

Task HWM is the peak number of CICS tasks that have used this DB2ENTRY.

 

Task Total is the total number of completed tasks that have used this DB2ENTRY.

 

Readyq HWM is the peak number of CICS tasks that waited for a thread to become available on this DB2ENTRY.

 

Related reference
Back to full list of statistics and DFHSTUP reports
Appendix A. CICS statistics tables
Interpreting these statistics
Interpreting CICS DB2 statistics
DFH0STAT reports for these statistics
DB2 Connection Report
DB2 Entries Report
[[ Contents Previous Page | Next Page Index ]]