This subsection describes the procedure for connection pool clustering. By manually stopping and restarting some of the connection pools when you handle the errors occurring in a database and when you perform database maintenance, you can perform database maintenance without stopping the entire system. To perform database maintenance by manually stopping and restarting some of the connection pools:
You check the connection pool state before and after you perform maintenance for a database in a cluster configuration.
For details on the connection pool states, see 3.17.4(3) States of the connection pool.
You check the connection pool state with the cjlistrar command.
The format and example of execution of the cjlistrar command are as follows:
cjlistrar server-name -clusterpool |
This section describes the procedure for suspending the connection pool.
You can suspend a connection pool with the cjsuspendpool command. When you execute the cjsuspendpool command, the connection pool is blocked and suspended and the connection requests are no longer received.
You can execute the cjsuspendpool command when the status of the connection pool is as follows:
For details on how to check the state of the connection pool, see (1) Checking the connection pool state.
The format and example of execution of the cjsuspendpool command are as follows:
cjsuspendpool server-name -resname display-name-of-member-resource-adapter-to-be-suspended |
This section describes the procedure for restarting the connection pool.
You can restart the connection pool with the cjresumepool command. When you execute the cjresumepool command, the connection pool status changes to Manual Restarting and the restart processing is executed. When the restart processing finishes, the connection pool status changes to Start and the connection requests are received.
You can execute the cjresumepool command when the state of the connection pool is as follows:
For details on how to check the state of the connection pool, see (1) Checking the connection pool state.
The format and example of execution of the cjresumepool command are as follows:
cjresumepool server-name -resname display-name-of-member-resource-adapter-to-be-restarted |
cjresumepool MyServer -resname DB_Connector_for_Oracle_ClusterPool_Member
Note that after you execute the cjresumepool command, you must check the status of the connection pool to check whether the restart processing was executed correctly. For details on how to check the state of the connection pool, see (1) Checking the connection pool state.