CICS Db2: Summary global statistics
Shows summary information and statistics about CICS® Db2®. Summary statistics are unavailable online.
| DFHSTUP name | Description |
|---|---|
| DB2® Connection Name | The name of the installed DB2CONN. |
| Total DB2 Connection time | 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 | 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 | 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 | 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 | 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 | The current number of connections used by the CICS-Db2 attachment facility. |
| Peak number of Connections | The peak number of connections used by the CICS-Db2 attachment facility. |
| Peak number of tasks on the TCB Readyq | The peak number of CICS tasks queued waiting because the TCBLIMIT specified in the DB2CONN has been reached. |
| Pool Thread Plan name | 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 | 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 | 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 | 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 | 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 | 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 | 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 | The total number of SQL calls made using pool threads. |
| Total number of Pool Thread Signons | The total number of Db2 sign-ons performed for pool threads. |
| Total number of Pool Thread Partial Signons | The total number of Db2 partial sign-ons performed for pool threads. |
| Total number of Pool Thread Commits | The total number of two phase commits performed for units of work using pool threads. |
| Total number of Pool Thread Aborts | The total number of units of work using pool threads that were rolled back. |
| Total number of Pool Thread Single Phases | 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 | 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 | 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 | 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 | 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 | The peak number of active pool threads. |
| Peak number of Pool tasks | The peak number of CICS tasks that have used a pool thread. |
| Total number of Pool tasks | The total number of completed tasks that have used a pool thread. |
| Peak number of tasks on the Pool Readyq | The peak number of CICS tasks that waited for a pool thread to become available. |
| Command Thread Authtype | 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 | 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 | The total number of Db2 commands issued through the DSNC transaction. |
| Total number of Command Thread Signons | The total number of Db2 sign-ons performed for command threads. |
| Total number of Command Thread Terminates | The total number of terminate thread requests made to Db2 for command threads. |
| Total number of Command Thread Overflows | 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 | 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 | The peak number of active command threads. |