Microservices Runtime JDBC Connection Pools Test

The function of the JDBC connection pool in webMethods Microservices Runtime Server is to efficiently manage database connections used by the microservices to interact with relational databases. The connection pool maintains a predefined minimum number of open JDBC connections ready to be used, which helps to reduce the overhead of establishing new database connections repeatedly. Using this test, you can figure out the number of connections that are available for use in the connection pool. This test also proactively alerts administrators on the status of whether the JDBC connection is up, indicating that the runtime obtains a valid database connection from the pool.

Target of the test : webMethods Microservices Runtime

Agent deploying the test : A remote agent

Outputs of the test : One set of results for each JDBC Connection pool in the target webMethods Microservices Runtime server.

Configurable parameters for the test

Parameter	Description
Test period	How often should the test be executed
Host	The IP address of the target for which the test is to be configured.
Port	The port number at which the specified target listens to. By default, this will be 5555.
User and Password	Specify the credentials of a user who has the right to execute API commands on the target and pull out metrics. The specified user is the User who should possess Administator privileges and should be associated with the Logon as a Service policy.
Confirm Password	Confirm the password by retyping it here.
SSL	Set this flag to Yes, if the target being monitored is SSL-enabled.

Measurements made by the test

Measurement	Description	Measurement Unit	Interpretation
Status	Indicates the status of this JDBC connection pool in webMethods Microservices Runtime server.		The values that this measure can report and their corresponding numeric values are discussed in the table below: Numeric Value Measure Value 0 Up 1 Down Note: By default, this measure reports the Measure Values discussed above to indicate the status of JDBC connection pool in webMethods Microservices Runtime server. In the graph of this measure however, states are represented using the numeric equivalents only.
Total connections	Indicates the total number of JDBC connections in this pool.	Number
Available connections	Indicates the number of JDBC connections that are active in this pool.	Number