Db2 Connect Server at Thread Level attributes
Use the Db2 Connect Server at Thread Level attributes to create situations to monitor all connected gateways of a Db2 subsystem.
Ace Address The Db2 thread ACE address for internal use.
Application ID The ID that is generated when the application connects to the database at the database manager or when Distributed Database Connection Services (DDCS) receives a request to connect to a DRDA database.
Application Name The name of the application running at the client as known to the database manager or Db2 Connect. Together with the Application ID counter, it can be used to relate data items with your application.
Authorization ID The authorization ID.
Authid (Unicode) The authorization ID.
Corrid The correlation ID.
Db2 Connect Server at Thread Level Attributes Identifies the connection of an application to a Db2 system.
It is an alphanumeric text string, with a maximum length of eight characters.
Db2 ID The Db2 subsystem ID.
Gateway Snapshot Time The date and time at which the database system monitor information was collected.
Inbound Number of Bytes Received The number of bytes received by the Db2 Connect gateway from the client, excluding communication protocol overhead, for example, TCP/IP or SNA headers.
Inbound Number of Bytes Sent The number of bytes sent by the Db2 Connect gateway to the client, excluding communication protocol overhead, for example, TCP/IP or SNA headers.
IP Address The current IP address.
Most Recent Unit of Work Elapsed Time The elapsed execution time of the most recently completed unit of work. It indicates time that it takes for units of work to complete.
MVSID The MVS system identifier.
Name The name in the database manager configuration file at the client node. It identifies the client node that is running the application.
Node Name The name of the node being monitored by the database system monitor. It identifies the database server node you are monitoring.
Node Number The number assigned to the node in the file with filename db2nodes and file type cfg (db2nodes.cfg).
Originating System ID The managed system name of the agent. It is an alphanumeric text string, with a maximum of 32 characters; for example, DB91:SYS1:DB2.
Outbound Application ID Is generated when the application connects to the DRDA host database. It is used to connect the Db2 Connect gateway to the host, while the application ID is used to connect a client to the Db2 Connect gateway.
Outbound Application ID (Internal) Is generated when the application connects to the DRDA host database. It is used to connect the Db2 Connect gateway to the host, while the application ID is used to connect a client to the Db2 Connect gateway.
Outbound Number of Bytes Received The number of bytes received by the Db2 Connect gateway from the host, excluding communication protocol overhead, for example, TCP/IP or SNA headers.
Outbound Number of Bytes Sent The number of bytes sent by the Db2 Connect gateway to the host, excluding communication protocol overhead, for example, TCP/IP or SNA headers.
Plan The plan name.
Server Instance Name The name of the database manager instance for which the snapshot was taken. If a system contains more than one instance of the database manager, this name is used to uniquely identify the instance for which the snapshot call was issued. Along with configuration NNAME at monitoring (server) node, this information can be useful if you are saving your monitor output in a file or database for later analysis, and you need to differentiate the data from different instances of the database manager.
Server Product Version ID The product and version that is running on the server in the form pppvvrrm.
- 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
Server Version The version of the server that is returning the information.
Time Stamp The start time of this interval.
Time Zone Displacement The number of hours that the local time zone is displaced from Greenwich Mean Time (GMT).
Uniqueness Value The instance number: When concatenated with the fully qualified network name, it uniquely identifies a distributed thread (Field name: QWHSLUUV).
Uniqueness Value 2 The Db2 thread uniqueness value. For internal use.