JDBC MultiPools

 

Create a JDBC MultiPool

1. Click to expand the JDBC node.

2. Click the MultiPools node. The MultiPools table displays in the right pane showing all the MultiPools defined in your domain.

3. Click the Create a New JDBC MultiPool text link. A dialog displays in the right pane showing the tabs associated with configuring a new MultiPool.

4. Enter a value in the Name attribute field. Click either the Load Balancing or the High Availability checkbox to chose how you want the connection pools to be selected from the MultiPool.

5. Click Create to create a MultiPool instance with the name you specified in the Name field. The new instance is added under the MultiPools node in the left pane.

6. On the Pools tab do the following:

   1. Select the connection pools from the Pool List in the Available column that you want to assign to the MultiPool.

   2. Click the mover control to move the connection pools you selected to the Chosen column.

7. Click Apply to save your assignments.

Clone a JDBC MultiPool

1. Click to expand the JDBC node.

2. Click the MultiPools node. The MultiPools table displays in the right pane showing all the MultiPools defined in your domain.

3. Click the Clone icon in the row of the MultiPool you want to clone. A dialog displays in the right pane showing the tabs associated with cloning a MultiPool.

4. Enter a value in the Name attribute field. Click the Load Balance and the High Avail checkboxes to enable load balancing and high availability respectively.

5. Click Create to create a MultiPool instance with the name you specified in the Name field. The new instance is added under the MultiPools node in the left pane.

Delete a JDBC MultiPool

1. Click to expand the JDBC node.

2. Click the MultiPools node. The MultiPools table displays in the right pane showing all the MultiPools defined in your domain.

3. Click the Delete icon in the row of the MultiPool you want to delete. A dialog displays in the right pane asking you to confirm your deletion request.

4. Click Yes to delete the MultiPool. The MultiPool icon under the MultiPools node is deleted.

Monitor All Instances of a JDBC MultiPool

1. Click to expand the JDBC node.

2. Click the MultiPools node. The MultiPools table displays in the right pane showing all the MultiPools defined in the domain.

3. Click the Monitor All Instances icon in the row of the MultiPool you want to monitor. A dialog displays in the right pane showing all instances of the MultiPool deployed across the connection-pool domain.

Assign a JDBC MultiPool

1. Click the instance node in the left pane under MultiPools for the MultiPool you want to assign. A dialog displays in the right pane showing the tabs associated with this instance.

2. Click the Targets tab.

3. Complete the following steps for the Servers tab:

   1. Select the server in the Available column to which you want to assign the MultiPool.

   2. Click the mover control to move the target you selected to the Chosen column.

   3. Click Apply to save your assignments.

Configuration

Pools

Notes

For more information about Multi Pools, see the Administration Guide.