Db2 Database Usage Test

Monitoring the space usage of each of the databases on the Db2 UDB database server, and reporting whether any database is experiencing excessive space usage or insufficient space allocation is crucial for the performance evaluation. To monitor the space usage of all Db2 databases, and to shed light on those databases that are running short of space, eG Enterprise offers the Db2 Database Usage test.

This test auto-discovers all Db2 database instances, and for each database instance, reports the space usage. This way, the tests sheds light on those databases that are running short of space.

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 that is currently active

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 an SSL-enabled layer, 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

Total allocated size

Indicates the total amount of space allocated to this database.

GB

 

Used size

Indicates the amount of space that is currently used on this database.

GB

 

Free size

Indicates the amount of space that is currently available for use on this database.

GB

Ideally, the value of this measure should be high.

Used percentage

Indicates the percentage of space that is being utilized on this database.

Percent

A value close to 100% is a cause for concern.