This section contains the following 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.
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
|
![]() ![]() |
D2G_TCB_CURRENT | ![]() ![]() ![]() Reset characteristic: not reset
![]() |
![]() ![]() |
D2G_TCB_HWM | ![]() ![]() ![]() Reset characteristic: reset to current value (D2G_TCB_CURRENT)
![]() |
![]() ![]() |
D2G_TCB_FREE | ![]() Reset characteristic: not reset
![]() |
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 |
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:
The resource information gives details of various attribute settings of each DB2ENTRY.
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
|
The request information gives details of how many requests of various types have been performed against each DB2ENTRY.
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
|
The performance information gives details of Thread information for each DB2ENTRY.
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)
|
Summary statistics are not available online.
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. |
There are three sections in the DFHSTUP summary report for CICS DB2 resource statistics:
Summary statistics are not available online.
The resource information gives details of various attribute settings of each DB2ENTRY.
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'. |
The request information gives details of how many requests of various types have been performed against each DB2ENTRY.
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.
|
The performance information gives details of thread information for each DB2ENTRY.
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.
|