Db2 Connect Server Tasklist Attributes
Use Db2 Connect Server Tasklist attributes to create situations that identify any process using too much CPU time or memory.
CPU Usage Per Process The percentage of time that a process used the CPU since the last update.
Db2 ID The Db2 subsystem ID.
Gateway Process ID The numerical ID that uniquely distinguishes a process while it runs.
Gateway Snapshot Time The date and time at which the database system monitor information was collected.
IP Address The current IP address.
Memory Usage by Process The current working set of a process, in kilobytes. The current working set is the number of pages currently resident in memory.
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.
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 database server nodes. This node name is determined based on the NNAME configuration parameter.
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.
Overall Process Time The sum of the times contained in the System Process Time and User Process Time columns.
Process Name The name of the process.
Process Owner Name The session ID that owns the process.
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 Status Shows whether the server is active or inactive.
Server Version The version of the server returning the information.
System Process Time The total system CPU time, in seconds and microseconds, used by the database manager agent process, the unit of work, or the statement.
Time Stamp The start time of this interval.
Time Zone Displacement The umber of hours that the local time zone is displaced from Greenwich Mean Time (GMT).
User Process Time The total user CPU time, in seconds and microseconds, used by the database manager agent process, the unit of work, or the statement.