Db2 Connect/Gateway Statistics
This panel shows statistics details about a selected Db2 Connect gateway.
________________ ZDBCD VTM O2 V550./C SZ91 07/31/13 17:06:43 2
> Help PF1 Back PF3 Up PF7 Down PF8
>
> DB2 Connect/Gateway: Enter a selection letter on the top line.
>
> *-DB2 Connect/Gateway Statistics B-Tasks List C-Performance
> D-Package Statistics
===============================================================================
> DB2 Connect/Gateway Statistics
DBCS
+ Name: IBM-590C1A11DE1 IP Addr: 9.76.24.33 Srv Inst Name:DB2
+ Gateway Snapshot Time:2013-07-31-17.03.26.974000
>
dbcd
+
+ DB2 Connect Information DB2 Connect Agents
+ ----------------------------------------- -----------------------------
+ Name =IBM-590C1A11DE1 Registered = 20
+ IP Address =9.76.24.33 Max Registered = 20
+ Node Name =N/P Wait For Token = 0
+ Node Number = 0 Max Wait Token = 0
+ Srv Product/Version ID =SQL09010 From Pool = 16160
+ Srv Instance Name =DB2 Create Empty Pool = 21
+ Srv Version = 7 Stolen = 0
+ Time Zone Displacement =- 7h 0mn Idle = 3
+ Server Status =ACTIVE Max Coordinating = 20
+ Max Overflow = 0
+ Inactive DRDA = N/P
+ Connection Switch = 0
+ Private Memory =25231360
+
+ Connections Sorts
+ --------------------------------------- -----------------------------
+ Current = 2 Sort Heap Allocated = 0
+ Attempted = 35
+ Wait for Host Reply = 0
+ Wait Client Send Request = 2
+ Remote Connection = 2
+ Remote Conn Executing in DBM = 0
=============================================================================== Fields
- Name
- Shows the name in the database manager configuration file at the client node. It identifies the client node that is running the application.
- IP Addr
- Shows the current IP address.
- Srv Inst Name
- Shows the name of the database manager instance for which the snapshot was taken.
- Gateway Snapshot Time
- Shows the date and time when the snapshot of displayed data was taken.
Db2 Connect information:
- Name
- Shows the name in the database manager configuration file at the client node. It identifies the client node that is running the application.
- IP Address
- Shows the current IP address.
- Node Name
- Shows the name of the node being monitored by the database system monitor. It identifies the database server node being monitored.
- Node Number
- Shows the number assigned to the node in the db2nodes.cfg file.
- Srv Product/Version ID
- Shows the product and version that is
running on the Db2 data server in the
form pppvvrrm, where:
- ppp stands for SQL
- vv identifies a 2-digit version number (with high-order 0 in the case of a 1-digit version)
- rr identifies a 2-digit release number (with high-order 0 in the case of a 1-digit release)
- m identifies a 1-digit modification level
- Srv Instance Name
- Shows the name of the database manager instance for which the snapshot was taken.
- Srv Version
- Shows the version of the Db2 data server returning the information.
- Time Zone Displacement
- Shows the number of hours and minutes that the local time zone is displaced from Greenwich Mean Time (GMT).
- Server Status
- Shows whether the Db2 data server is active or inactive.
Connections:
- Current®
- Shows the number of applications that are currently connected to the database.
- Attempted
- Shows the total number of current connections initiated from remote clients to the instance of the database manager that is being monitored.
- Wait for Host Reply
- Shows the current number of connections to the host databases that are handled by the Db2 Connect gateway and are waiting for a reply from the host.
- Wait for Client Send Request
- Shows the current number of connections to the host databases that are handled by the Db2 Connect gateway and are waiting for the client to send a request.
- Remote Connection
- Shows the current number of connections initiated from remote clients to the instance of the database manager that is being monitored.
- Remote Conn Executing In DBM
- Shows the number of remote applications that are currently connected to a database and are processing a unit of work within the database manager instance being monitored.
Db2 Connect Agents:
- Registered
- Shows the number of agents that are registered in the database manager instance that is being monitored.
- Max Registered
- Shows the maximum number of agents that the database manager has registered at the same time since it was started.
- Wait for Token
- Shows the number of agents waiting for a token so they can perform a transaction in the database manager.
- Max Wait for Token
- Shows the maximum number of agents that have been waiting for a token at the same time since the database manager was started.
- From Pool
- Shows the maximum number of agents that have been waiting for a token at the same time since the database manager was started.
- Create Empty Pool
- Shows the number of agents created because the agent pool was empty.
- Stolen
- Shows the number of times that agents are stolen from an application.
- Idle
- Shows the number of agents in the agent pool that are currently unassigned to an application.
- Max Coordinating
- Shows the maximum number of coordinating agents working at one time.
- Max Overflow
- Shows the number of times a request to create a new agent was received when the MAXAGENTS configuration parameter had already been reached.
- Inactive DRDA
- Shows the number of connections made by a subagent to the database at the node.
- Connection Switch
- Shows the number of times that an agent from the agent pool was primed with a connection and was stolen for use with a different DRDA database.
- Private Memory
- Shows the amount of private memory that the instance of the database manager has committed at the time of the snapshot.
Sorts:
- Sort Heap Allocated
- Shows the total number of allocated pages of sort heap space for all sorts at the level chosen and at the time of the snapshot was taken.