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"

Start Database Manager Timestamp

 
Snapshot Information Level
Database Manager

 
API Structure(s)
sqlm_db2

 
Monitor Switch
Basic

Resettable

No

API Element Name
Element Type

db2start_time
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

Snapshot Information Level
Database Manager

API Structure(s)
sqlm_collected

Monitor Switch
Basic

Resettable 

No 

API Element Name
Element Type

server_nname
information

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.

If you are using the database system monitor APIs, note that the API constant SQLM_IDENT_SZ is used to define the length of this element. Only the first 8 characters are currently used.

Server Instance Name

 
Snapshot Information Level
Database Manager

 
API Structure(s)
sqlm_collected

 
Monitor Switch
Basic

Resettable

No

 
Event Type
Event Log Header

 
Event Record(s)
sqlm_event_log_header

API Element Name
Element Type

server_instance_name
information

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.

If you are using the database system monitor APIs, note that the API constant SQLM_IDENT_SZ is used to define the length of this element. Only the first 8 characters are currently used.

Database Manager Type at Monitored (Server) Node

 
Snapshot Information Level
Database Manager

 
API Structure(s)
sqlm_collected

 
Monitor Switch
Basic

Resettable

No

API Element Name
Element Type

server_db2_type
information 

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

 
Snapshot Information Level
Database Manager

 
API Structure(s)
sqlm_collected

 
Monitor Switch
Basic

Resettable

No 

Event Type
Database Manager

Event Record(s)
sqlm_event_log_header

API Element Name
Element Type

server_prdid
information

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

If you are using the database system monitor APIs, note that the API constant SQLM_IDENT_SZ is used to define the length of this element. Only the first 8 characters are currently used.

Server Version

 
Snapshot Information Level
Database Manager

 
API Structure(s)
sqlm_collected

 
Monitor Switch
Basic

Resettable

No

API Element Name
Element Type

server_version
information

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_VERSION1

Data was returned by DB2 Version 1

SQLM_VERSION2

Data was returned by DB2 Version 2

SQLM_VERSION5

Data was returned by DB2 Universal Database Version 5

Service Level

 
Snapshot Information Level
Database Manager

 
API Structure(s)
sqlm_db2

 
Monitor Switch
Basic

Resettable

No

API Element Name
Element Type

service_level
information

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 C. "DB2 Version 1 sqlestat Users" for more information on sqlestat equivalent data elements.

Server Operating System

 
Snapshot Information Level
Database

 
API Structure(s)
sqlm_dbase

 
Monitor Switch
Basic

Resettable

No

Event Type
Database

Event Record(s)
sqlm_db_event

API Element Name
Element Type

server_platform
information

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 C. "DB2 Version 1 sqlestat Users" for more information on sqlestat equivalent data elements.

Product Name

 
Snapshot Information Level
Database Manager

 
API Structure(s)
sqlm_db2

 
Monitor Switch
Basic

Resettable

No

API Element Name
Element Type

product_name
information

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 C. "DB2 Version 1 sqlestat Users" for more information on sqlestat equivalent data elements.

Product Identification

 
Snapshot Information Level
Database Manager

 
API Structure(s)
sqlm_db2

 
Monitor Switch
Basic

Resettable

No

API Element Name
Element Type

component_id
information

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 C. "DB2 Version 1 sqlestat Users" for more information on sqlestat equivalent data elements.

Status of DB2 Instance

 
Snapshot Information Level
Database Manager

 
API Structure(s)
sqlm_db2

 
Monitor Switch
Basic

Resettable

No

API Element Name
Element Type

db2_status
information

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.

[ DB2 List of Books | Search the DB2 Books ]