Tuxedo PIA Database Connections Test

If the Tuxedo application server is unable to connect to the database owing to the absence of adequate connections in the connection pool, then critical server operations may fail. Using the Tuxedo PIA Database Connections test, administrators can periodically monitor the usage of each connection pool in every logical group configured in an application server domain, and promptly detect when a pool runs short of connections. This way, the test provides useful pointers to resizing connection pools.

Target of the test : A Tuxedo Application Server

Agent deploying the test : An internal agent

Outputs of the test : One set of results for every connection pool of each logical group in the application server domain being monitored.

First-level descriptor: Group name. Application servers in a domain are logically divided into groups.

Second-level descriptor: Connection pool

Configurable parameters for the test

Parameter	Description
Test period	How often should the test be executed
Host	The host for which the test is to be configured.
Port	The port number at which the specified Host listens to. By default, this will be 12345.
PSAdmin Home	To collect metrics from a Tuxedo application server, this test runs PeopleSoft Server Administration (PSADMIN) commands on the target server. The first step towards this is to launch the psadmin.exe. To enable the test to run the psadmin.exe, you need to configure the test with the full path to the directory in which the psadmin.exe resides. Therefore, in the PSAdmin Home text box, specify the location of the psadmin.exe. Typically, this will be the install directory of the Tuxedo application server. For instance, on Windows, your specification can be C:\ps\appsrv and on Unix, your specification can be: opt/ps/appsrv.
Domain	An application server Domain is the collection of server processes, supporting processes, and resource managers that enable connections to the database. A single application server machine can support multiple application server domains running on it. A server process is executable code that receives incoming transaction requests. The server process carries out a request by making calls to a service. Using a managed Tuxedo application server, you can monitor only those server processes and transactions that pertain to a single domain. This is why, the eG agent needs to be explicitly configured with the application server Domain it needs to monitor.

Measurements made by the test

Measurement	Description	Measurement Unit	Interpretation
Max connection pool size	Indicates the maximum number of connections in this pool.	Number
Current connection pool size	Indicates the current size of this pool.	Number
Used connections	Indicates the number of used connections relative to the size of the pool.	Number
Free connections	Indicates the percentage of unused connections in this pool.	Percent	A high value is desired for this measure. If the value is low, it indicates abnormal usage of the connection pool. You may want to consider resizing the pool, so that sufficient connections are always available in the pool.