Db Connection Test

The Db Connection test measures the availability and responsiveness of the MaxDB server. For this test to run, make sure that the sapdbc.jar file (see page is copied to the /opt/egurkha/lib directory of the external agent host.

Target of the test : A MaxDB server

Agent deploying the test : An external agent

Outputs of the test : One set of results for the MaxDB server being monitored.

Configurable parameters for the test
Parameter Description

Test Period

How often should the test be executed.

Host

The host name of the server for which the test is to be configured.

Port

The port number to which the server is listening.

DatabaseName

The test connects to a database on MaxDB and extracts performance statistics from the system tables in the database. Therefore, provide the name of a database in the DatabaseName text box.

Username

Since users with the SYSDBA privilege alone are allowed access to system tables, specify the name of such a user against Username.

Password

Provide the Password that corresponds to the specified Username.

Confirm Password

Confirm the password by retyping it here.

Measurements made by the test
Measurement Description Measurement Unit Interpretation

Database availability

Indicates whether the database connection is available or not.

Percent

The value 100 indicates availability, the value 0 indicates non-availability.

Response time

Indicates the time taken to execute a simple load database query.

Secs

A sudden increase in response time is indicative of a bottleneck at the database server.