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 signons
performed for pool threads.
|
| Total number of Pool Thread Partial Signons | The total number of DB2 partial
signons 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 signons
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. |