Db2 Database Status Test

If a user complaints of problems while accessing a database, the knowledge of the current state of that database will enable administrators to promptly diagnose the reason for such an occurrence. The Db2 Database Status test helps administrators to track the status of the database easily.

This test auto-discovers all the databases on a Db2 UDB server and reports the current state of each database, thereby enabling administrators to easily troubleshoot issues related to database access.

Target of the test : A DB2 database server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for every database on the DB2 database server.

Configurable parameters for the test
Parameter	Description
Test Period	How often should the test be executed.
Host	Specify the IP address of the DB2 server in this text box.
Port	Specify the port at which the target host is listening. The default port is 50000.
Username, Password and Confirm Password	To monitor Db2 UDB database server, the eG agent should be configured with the credentials of a user with any of the following privileges SYSADM or SYSCTRL or SYSMAINT or SYSMON. Specify the credentials of such a user in the User and Password text boxes. Confirm the Password by retyping it in the Confirm Password text box.
Database	The test uses a database on the monitored Db2 UDB server. Specify the name of the database in the Database text box.
Include DB	Specify the list of databases that you wish to monitor in a comma-seperated list in the Include DB text box. By default this is set to ALL.
Exclude DB	Specify the list of databases that you wish to exclude from monitoring in a comma-seperated list in the Exclude DB text box. By default this is set to NONE.
SSL	If the IBM Db2 UDB being monitored is SSL-enabled, then set the SSL flag to Yes. If not, then set the SSL flag to No.
Trust Store file name	The trust store file contains certificates from trusted Certificate Authorities (CAs). These certificates are used by eG agent to verify the authenticity of servers hosting DB2 UDB and establish a secure connection with the server using SSL. Specify the filename for Trust store file in Trust Store file name text box.
Trust Store Password	The trust store password is the passphrase or key used to encrypt and decrypt the trust store file. This password is required by the eG Agent when it needs to access the trust store file to establish secure connections. Specify the password in Trust Store password text box.
Confirm Password	Confirm the Password by retyping it in the Confirm Password text box.

Measures made by the test:

Measurement

Description

Measurement Unit

Interpretation

Status

Indicates the current status of this database.

These measure values and their corresponding numeric values are listed in the table below:

Measure value	Numeric value
ACTIVE	0
ACTIVE STANDBY	1
STANDBY	2
QUIESCE PEND	3
QUIESCED	4
ROLLFWD	5

Note:

By default, this measure reports the Measure values to indicate current status of each database. However, the graph of this measure is represented using the numeric equivalents only.