20.3.6 Checking the state of the connection pool
You can reference the states of the connection pools that are used in a cluster connection pool with the following two methods:
-
Reference the resource adapter names and the state of the member connection pools for all the deployed resource adapters using the cjlistrar command.
-
Reference the member connection pool information using the cjlistpool command.
Reference the member connection pool information and lock/ suspend/ restart the member connection pool as and when required. For details on defining the state of the connection pool, see 20.1.4 Connection pool clustering operations.
- Organization of this subsection
(1) Checking the state of the connection pool
The resource adapter names and the state of the resource adapters are displayed for all the deployed resource adapters. The state of the connection pool is also displayed if the resource adapter is a member resource adapter of a cluster connection pool.
Execute the following command to reference the state of a connection pool:
- Execution format
cjlistrar [server-name] [-nameserver provider-URL] -clusterpool
- Example of execution
cjlistrar MyServer -clusterpool
For details on the cjlistrar command, see cjlistrar (list resource adapters) in the uCosminexus Application Server Command Reference Guide.
(2) Referencing the member connection pool information
The connection pool information is displayed. The information about the member connection pool is also displayed if the resource adapter is a member resource adapter of the cluster connection pool.
Execute the following command to reference the connection pool information for all the resource adapters:
- Execution format
cjlistpool [server-name] [-nameserver provider-URL] -resall
- Example of execution
cjlistpool MyServer -resall
Execute the following command for displaying the connection pool information for a specific resource adapter:
- Execution format
cjlistpool [server-name] -resname resource-adapter-display-name
- Example of execution
cjlistpool MyServer -resname DB_Connector_for_Oracle_ClusterPool_Member
The connection pool information for the resource adapter is displayed.
For details on the cjlistpool command, see cjlistpool (list connection pools) in the uCosminexus Application Server Command Reference Guide.
- Note:
-
You cannot execute the cjlistpool command for a root resource adapter.