System Monitor Guide and Reference

Server Identification and Status

The following elements provide identification and status information about the server:

• Start Database Manager Timestamp
• Configuration NNAME at Monitoring (Server) Node
• Server Instance Name
• Database Manager Type at Monitored (Server) Node
• Server Product/Version ID
• Server Version
• Service Level
• Server Operating System
• Product Name
• Product Identification
• Status of DB2 Instance
• Time Zone Displacement

Start Database Manager Timestamp

Description:  The date and time that the database manager was started using the db2start command.

Usage:  This element may be used with the "Snapshot Time" monitor element to calculate the elapsed time since the database manager was started up until the snapshot was taken.

Configuration NNAME at Monitoring (Server) Node

Description: The name of the node being monitored by the database system monitor.

Usage: This element can be used to identify 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.

Server Instance Name

Description:  The name of the database manager instance for which the snapshot was taken.

Usage:  If more than one instance of the database manager is present on the same system, this data item 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.

Database Manager Type at Monitored (Server) Node

Description:  Identifies the type of database manager being monitored.

Usage:  It contains one of the following types of configurations for the database manager:

API Symbolic Constant

Command Line Processor Output

sqlf_nt_server

Database server with local and remote clients

sqlf_nt_stand_req

Database server with local clients

The API symbolic constants are defined in the include file sqlutil.h.

Server Product/Version ID

Description:  The product and version that is running on the server.

Usage:  It is in the form PPPVVRRM, where:

PPP

is 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

Description:  The version of the server returning the information.

Usage:  This field identifies the level of the database server collecting database system monitor information. This allows applications to interpret the data based on the level of the server returning the data. Valid values are:

SQLM_DBMON_VERSION1

Data was returned by DB2 Version 1

SQLM_DBMON_VERSION2

Data was returned by DB2 Version 2

SQLM_DBMON_VERSION5

Data was returned by DB2 Universal Database Version 5

SQLM_DBMON_VERSION5_2

Data was returned by DB2 Universal Database Version 5.2

SQLM_DBMON_VERSION6

Data was returned by DB2 Universal Database Version 6

SQLM_DBMON_VERSION7

Data was returned by DB2 Universal Database Version 7

Service Level

Description:  This is the current corrective service level of the server.

Usage:  Used to provide information when requesting service or reporting a problem with DB2 on OS/2. This element will be blank for non-OS/2 systems.

Note:

This element is similar to the corr_serv_lvl field in the sqlestat output. See Appendix D, DB2 Version 1 sqlestat Users for more information on sqlestat equivalent data elements.

Server Operating System

Description:  The operating system running the database server.

Usage:  This element can be used for problem determination for remote applications. Values for this field can be found in the header file sqlmon.h.

Note:

This element is similar to the db_type field in the sqlestat output. See Appendix D, DB2 Version 1 sqlestat Users for more information on sqlestat equivalent data elements.

Product Name

Description:  Details of the version of the server that is running.

Usage:  Used to provide information when requesting service or reporting a problem with DB2 on OS/2. This element will be blank for non-OS/2 systems.

Note:

This element is similar to the product_name field in the sqlestat output. See Appendix D, DB2 Version 1 sqlestat Users for more information on sqlestat equivalent data elements.

Product Identification

Description:  Details of the type of the server that is running.

Usage:  Used to provide information when requesting service or reporting a problem with DB2 on OS/2. This element will be blank for non-OS/2 systems.

Note:

This element is similar to the component_id field in the sqlestat output. See Appendix D, DB2 Version 1 sqlestat Users for more information on sqlestat equivalent data elements.

Status of DB2 Instance

Description:  The current status of the instance of the database manager.

Usage:  You can use this element to determine the state of your database manager instance.

The value returned is always SQLM_DB2_ACTIVE.

Time Zone Displacement

Description:  Number of seconds that the local time zone is displaced from Greenwich Mean Time (GMT).

Usage:  All time reported by reported by the database system monitor is GMT, this displacement calculates the local time.