Figure 123 shows the format of the DB2® Connection Report. 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. The field headings and contents are described in Table 247.
Applid IYK2Z1V1 Sysid CJB3 Jobname CI07CJB1 Date 12/17/2004 Time 09:58:11 CICS 6.4.0 PAGE 2
DB2 Connection
DB2 Connection Name. . . . . . . . . . . : DB3A
DB2 Group ID . . . . . . . . . . . . . . : DFP2 Resync Group Member. . . . . . . . . . . : YES
DB2 Sysid. . . . . . . . . . . . . . . . : DFP2
DB2 Release. . . . . . . . . . . . . . . : 7.1.0
DB2 Connection Status. . . . . . . . . . : CONNECTED DB2 Connect Date and Time . . . : 12/17/2004 09:57:09.69560
DB2 Connection Error . . . . . . . . . . : SQLCODE
DB2 Standby Mode . . . . . . . . . . . . : RECONNECT
DB2 Pool Thread Plan Name. . . . . . . . :
DB2 Pool Thread Dynamic Plan Exit Name . : DSNCUEXT
Pool Thread Authtype . . . . . . . . . . : USERID Command Thread Authtype. . . . . . . . . : N/A
Pool Thread Authid . . . . . . . . . . . : Command Thread Authid. . . . . . . . . . : CBAKER
Signid for Pool/Entry/Command Threads. . : IYK2Z1V1
Create Thread Error. . . . . . . . . . . : N906D Message TD Queue 1. . . . . . . . . . . : CDB2
Protected Thread Purge Cycle . . . . . . : 00.30 Message TD Queue 2. . . . . . . . . . . : CSSL
Deadlock Resolution. . . . . . . . . . . : ROLLBACK Message TD Queue 3. . . . . . . . . . . :
Non-Terminal Intermediate Syncpoint. . . : RELEASE
Pool Thread Wait Setting . . . . . . . . : WAIT Statistics TD Queue . . . . . . . . . . : CDB2
Pool Thread Priority . . . . . . . . . . : N/A DB2 Accounting records by . . . . . . . : NONE
Current TCB Limit. . . . . . . . . . . . : 12
Current number of Connections. . . . . . : 0 Current number of free Connections. . . : 0
Peak number of Connections . . . . . . . : 0
Current number of tasks on TCB Readyq. . : 0
Peak number of tasks on TCB Readyq . . . : 0
Pool Thread Limit. . . . . . . . . . . . : 3 Number of Calls using Pool Threads. . . . . : 0
Current number of Pool Threads . . . . . : 0 Number of Pool Thread Signons . . . . . . . : 0
Peak number of Pool Threads. . . . . . . : 0 Number of Pool Thread Partial Signons . . . : 0
Number of Pool Thread Waits. . . . . . . : 0 Number of Pool Thread Commits . . . . . . . : 0
Number of Pool Thread Aborts. . . . . . . . : 0
Current number of Pool Tasks . . . . . . : 0 Number of Pool Thread Single Phase. . . . . : 0
Peak number of Pool Tasks. . . . . . . . : 0 Number of Pool Thread Reuses. . . . . . . . : 0
Current Total number of Pool Tasks . . . : 0 Number of Pool Thread Terminates. . . . . . : 0
Current number of Tasks on Pool Readyq . : 0
Peak number of Tasks on Pool Readyq. . . : 0
Current number of DSNC Command threads . : 0 Number of DSNC Command Calls. . . . . . . . : 0
Peak number of DSNC Command threads. . . : 0 Number of DSNC Command Signons. . . . . . . : 0
DSNC Command Thread Limit. . . . . . . . : 1 Number of DSNC Command Thread Terminates. . : 0
Number of DSNC Command Thread Overflows . . : 0
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 will attempt 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 |
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 will be 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 will be 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 will be sent.
Source field: EXEC CICS INQUIRE DB2CONN MSGQUEUE3 |
Non-Terminal Intermediate Syncpoint | specifies whether non-terminal transactions
will release threads for reuse at intermediate syncpoints.
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 |
![]() ![]() |
![]() Source field: D2G-TCB-CURRENT ![]() |
![]() ![]() |
![]() 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 |
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 |