DB2 Connection Report

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.

Figure 123. The DB2 Connection Report
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
Table 247. Fields in the DB2 Connection Report
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

Start of changeCurrent number of ConnectionsEnd of change Start of changeThe current number of connections in use by the CICS DB2 attachment facility.

Source field: D2G-TCB-CURRENT

End of change
Start of changePeak number of ConnectionsEnd of change Start of changeThe peak number of connections used by the CICS DB2 attachment facility.

Source field: D2G-TCB-HWM

End of change
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

Related reference
Back to full list of DFH0STAT reports
The DFH0STAT reports
Interpreting these statistics
Interpreting CICS DB2 statistics
Full listing and DFHSTUP reports for these statistics
CICS DB2 statistics

[[ Contents Previous Page | Next Page Index ]]