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.
| 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. |
| 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. |
