DB2 Connection report
The DB2® Connection report shows information and statistics about DB2 Connection resource definitions, which define the connection between CICS® and DB2 for a CICS region. The report also includes statistics about pool threads, DSNC commands, and tasks that wait for a TCB or pool thread.
This report is produced using a combination of the EXEC CICS INQUIRE DB2CONN and EXEC CICS COLLECT STATISTICS DB2CONN commands. The statistics data is mapped by the DFHD2GDS DSECT.
| Field Heading | Description |
|---|---|
| DB2 Connection Name | The name of the installed DB2CONN. Source field: D2G-DB2CONN-NAME |
| DB2 Group Id | 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. Source field: D2G-DB2-GROUP-ID |
| Resync Group Member | If you are using group attach, specifies
whether CICS attempts to resynchronize with the last
connected DB2 data-sharing group member if outstanding
units of work are being held. Source field: D2G-RESYNCMEMBER |
| DB2 Sysid | The name of the DB2 subsystem
to which the CICS DB2 attachment is connected or will
connect. If you are using group attach and the CICS DB2 attachment
is connected or waiting to connect, this is the member of the data-sharing
group of DB2 subsystems that has been chosen from the
group. Source field: D2G-DB2-ID |
| DB2 Release | The version and release level of
the DB2 subsystem to which CICS is
currently connected. Source field: D2G-DB2-RELEASE |
| DB2 Connection Status | The current status of the CICS-DB2
Connection. Source field: EXEC CICS INQUIRE DB2CONN CONNECTST |
| DB2 Connect Date and Time | The date and time that the CICS connected
to the DB2 subsystem. Source field: D2G-CONNECT-TIME-LOCAL |
| DB2 Connection Error | Specifies how CICS reports
back to an application that issues an SQL request that CICS is
not connected to DB2. Source field: EXEC CICS INQUIRE DB2CONN CONNECTERROR |
| DB2 Standby Mode | Specifies the action to be taken
by the CICS-DB2 attachment if the DB2 subsystem
is not active when an attempt to start the connection from CICS to DB2 is
made. Source field: EXEC CICS INQUIRE DB2CONN STANDBYMODE |
| DB2 Pool Thread Plan Name | The name of the plan used for the
pool. Source field: D2G-POOL-PLAN-NAME |
| DB2 Pool Thread Dynamic Plan Exit Name | The name of the dynamic plan exit
used for pool threads. Source field: D2G-POOL-PLANEXIT-NAME |
| Dynamic Plan Exit Concurrency Status | Specifies whether the dynamic plan
exit used for pool threads is defined as QUASIRENT or THREADSAFE.
Source field: EXEC CICS INQUIRE PROGRAM CONCURRENCY |
| Pool Thread Authtype | The type of ID to be used for security
checking when using pool threads. Source field: D2G-POOL-AUTHTYPE |
| Command Thread Authtype | The type of ID to be used for security
checking when using command threads. Source field: D2G-COMD-AUTHTYPE |
| Pool Thread Authid | The ID to be used for security checking
when using pool threads. Source field: D2G-POOL-AUTHID |
| Command Thread Authid | The ID to be used for security checking
when using command threads. Source field: D2G-COMD-AUTHID |
| Signid for Pool/Entry/Command Threads | The authorization ID to be used by the CICS-DB2 attachment when
signing on to DB2 for
pool threads and DB2
entry threads when Pool Thread Authtype is SIGNID and for command threads
when Command Thread Authtype is SIGNID. Source field: EXEC CICS INQUIRE DB2CONN SIGNID |
| Create Thread Error | Specifies the action to be taken
when a create thread error occurs. Source field: EXEC CICS INQUIRE DB2CONN THREADERROR |
| Message TD Queue 1 | The name of the first transient data
queue to which unsolicited messages from the CICS-DB2 attachment are
sent. Source field: EXEC CICS INQUIRE DB2CONN MSGQUEUE1 |
| Protected Thread Purge Cycle | The length of time (mm:ss) of the
protected thread purge cycle. Source field: EXEC CICS INQUIRE DB2CONN PURGECYCLEM and PURGECYCLES |
| Message TD Queue 2 | The name of the second transient
data queue to which unsolicited messages from the CICS-DB2 attachment
are sent. Source field: EXEC CICS INQUIRE DB2CONN MSGQUEUE2 |
| Deadlock Resolution | The action to be taken for a transaction
using a pool thread that has been selected by DB2 as
victim of a deadlock resolution. Source field: EXEC CICS INQUIRE DB2CONN DROLLBACK |
| Message TD Queue 3 | The name of the third transient data
queue to which unsolicited messages from the CICS-DB2 attachment are
sent. Source field: EXEC CICS INQUIRE DB2CONN MSGQUEUE3 |
| Non-Terminal Intermediate Syncpoint | Specifies whether non-terminal transactions
release threads for reuse at intermediate sync points. Source field: EXEC CICS INQUIRE DB2CONN NONTERMREL |
| Pool Thread Wait Setting | Specifies whether transactions should
wait for a pool thread or be abended if the number of active pool
threads reaches the pool thread limit. Source field: D2G-POOL-THREADWAIT |
| Statistics TD Queue | The name of the transient data queue
for the CICS-DB2 attachment statistics produced when the CICS-DB2
attachment is shut down. Source field: EXEC CICS INQUIRE DB2CONN STATSQUEUE |
| Pool Thread Priority | 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'. Source field: D2G-POOL-PRIORITY |
| DB2 Accounting records by | Specifies the frequency of DB2 accounting
records to be produced for transactions using pool threads. Source field: D2G-POOL-ACCOUNTREC |
| Current TCB Limit | The maximum number of TCBs that can
be used by the CICS DB2 attachment facility. Source field: D2G-TCB-LIMIT |
| Thread Reuselimit | The number of times a thread can
be reused before being terminated. Source field: D2G-REUSELIMIT |
| Current number of Connections | The current number of connections
in use by the CICS DB2 attachment facility. Source field: D2G-TCB-CURRENT |
| Peak number of Connections | The peak number of connections used
by the CICS DB2 attachment facility. Source field: D2G-TCB-HWM |
| Current number of free Connections | The number of free connections available
for use with CICS open TCBs. Source field: D2G-TCB-FREE |
| Current number of tasks on TCB Readyq | The number of CICS tasks
queued waiting because the TCBLIMIT specified in the DB2CONN has been
reached. Source field: D2G-TCB-READYQ-CURRENT |
| Peak number of tasks on TCB Readyq | The peak number of CICS tasks
queued waiting because the TCBLIMIT specified in the DB2CONN has been
reached. Source field: D2G-TCB-READYQ-PEAK |
| Pool Thread Limit | The maximum number of pool threads
allowed. Source field: D2G-POOL-THREAD-LIMIT |
| Number of Calls using Pool Threads | The number of SQL calls made using
pool threads. Source field: D2G-POOL-CALLS |
| Current number of Pool Threads | The current number of active pool
threads. Source field: D2G-POOL-THREAD-CURRENT |
| Number of Pool Thread Signons | The number of DB2 signons
performed for pool threads. Source field: D2G-POOL-SIGNONS |
| Peak number of Pool Threads | The peak number of active pool threads.
Source field: D2G-POOL-THREAD-HWM |
| Number of Pool Thread Partial Signons | The number of DB2 partial
signons performed for pool threads. Source field: D2G-POOL-PARTIAL-SIGNONS |
| Number of Pool Thread Waits | 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. Source field: D2G-POOL-THREAD-WAITS |
| Number of Pool Thread Commits | The number of two phase commits performed
for units of work using pool threads. Source field: D2G-POOL-COMMITS |
| Number of Pool Thread Aborts | The number of units of work using
pool threads that were rolled back. Source field: D2G-POOL-ABORTS |
| Current number of Pool Tasks | The current number of CICS tasks
using pool threads. Source field: D2G-POOL-TASK-CURRENT |
| Number of Pool Thread Single Phase | 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. Source field: D2G-POOL-SINGLE-PHASE |
| Peak number of Pool Tasks | The peak number of CICS tasks
using pool threads. Source field: D2G-POOL-TASK-HWM |
| Number of Pool Thread Reuses | 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. Source field: D2G-POOL-THREAD-REUSE |
| Current Total number of Pool Tasks | The current total number of tasks
that have used a pool thread. Source field: D2G-POOL-TASK-TOTAL + D2G-POOL-TASK-CURRENT |
| Number of Pool Thread Terminates | The number of terminate thread requests
made to DB2 for pool threads. This includes pool threads
used by transactions that overflow to the pool. Source field: D2G-POOL-THREAD-TERM |
| Current number of Tasks on Pool Readyq | The current number of CICS tasks
waiting for a pool thread to become available. Source field: D2G-POOL-READYQ-CURRENT |
| Times reuselimit hit by a pool thread | The number of times the reuselimit
has been reached by a pool thread. Source field: D2G_POOL_REUSELIMIT_COUNT |
| Peak number of Tasks on Pool Readyq | The peak number of CICS tasks
that waited for a pool thread to become available. Source field: D2G-POOL-READYQ-HWM |
| Current number of DSNC Command threads | The current number of active command
threads servicing DB2 commands issued using the DSNC
transaction. Source field: D2G-COMD-THREAD-CURRENT |
| Number of DSNC Command Calls | The number of DB2 commands
issued using the DSNC transaction. Source field: D2G-COMD-CALLS |
| Peak number of DSNC Command threads | The peak number of command threads
servicing DSNC DB2 commands. Source field: D2G-COMD-THREAD-HWM |
| Number of DSNC Command Signons | The number of DB2 signons
performed for DSNC DB2 commands. Source field: D2G-COMD-SIGNONS |
| DSNC Command Thread Limit | The maximum number of command threads
allowed for DSNC DB2 commands. Source field: D2G-COMD-THREAD-LIMIT |
| Number of DSNC Command Thread Terminates | The number of terminate thread requests
made to DB2 for command threads. Source field: D2G-COMD-THREAD-TERM |
| Number of DSNC Command Thread Overflows | The number of times a DSNC DB2 command
resulted in a pool thread being used because of the active number
of command threads exceeding the command thread limit. Source field: D2G-COMD-THREAD-OVERF |