A pool is a group of Adaptive Servers that you define within the OpenSwitch environment. A pool can contain one or more servers that OpenSwitch treats as a self-contained failover group, so all connections within the group fail over only to servers you define within the group. See “Defining pools” for more information.
A pool can optionally define the set of connections or connection attributes that it manages. You can use the user name, application name, or connection type to define this association between a connection and a pool.
Creating pools in OpenSwitch Manager
Create pools using OSWM, or by:
Using the OpenSwitch configuration tool during and after installation.
Manually editing the OpenSwitch configuration file. See “Defining a pool”.
Using the rp_pool_create registered procedure. See rp_pool_create.
Select the OpenSwitch server for which you want to create a pool.
Select File | New | Pool. You can also select the Pools folder and double-click the Add Pool icon in the Details pane on the right side of the Sybase Central window.
Provide the name of the new pool in an empty row of the Pool Name column. Select Pool | Add or click the Add (+) button in the toolbar to create a new row.
Select the status for the new pool: UP, DOWN, or LOCKED. Sybase recommends that you select the DOWN state for a new pool so that processes do not switch to the new pool immediately. Change the pool status to UP or LOCKED after you assign Adaptive Servers to the pools and verify the pool is ready to accept connections. See Table 7-7 for detailed descriptions of pool states.
Select the new pool and select Pool | Properties to display the Pool Parameters window. You can also right-click the pool and select Properties, or select the Properties button from the toolbar.
Select the Parameters tab. Select:
Relative Pool – to create the new pool relative to an existing pool. Select the existing pool.
Pool Position – to specify the position of the new pool relative to the existing pool: HEAD, TAIL, BEFORE, and AFTER. See Table 7-6 for more information on these options.
Pool Mode – to provide the routing and switching modes for the new pool: CHAINED or BALANCED. See Table 7-8 for more information on these modes.
WARNING! Be careful when you choose the pool parameters. You cannot change the pool parameters after you save the new pool.
Click OK to return to the Pool Editor window.
Select Pool | Add in the Pool Editor window to create additional pools. Follow step 3 to step 7 for each pool you want to create.
Select File | Save Pool to save the pool and not exit the Pool Editor window. To save the pool and exit the editor, select File | Save Pool and Close Editor.
After you create and save pools, you can assign pool connection attributes to each pool. See Adding pool attributes.
You can assign attributes to a pool that apply to all Adaptive Servers in the pool. You can assign pool connection attributes only to an existing pool.
Select the pool to which you want to add attributes.
Select File | Properties.You can also right-click the pool and select Properties, or select the Properties button from the toolbar.
Select the Connection Attributes tab.
Click the Add button to the right of the tab.
Select an attribute from the Attribute field and specify its value in the Value field:
username – to restrict access to connections initiated with the user name you specify.
appname – to restrict access to connections from the application you specify.
hostname – to restrict access to connections from the host you specify.
Select Apply and OK to save the connection attributes you specify.
You can also change or remove the pool connection attributes in the pool Properties window.
Viewing pool activity and status
You can use the Pool Properties window to view the pool configuration, pool status, and current activities that have an impact on the pool.
Select a pool.
Select File | Properties. You can also right-click the pool and select Properties, or select the Properties button from the toolbar.
Select the General tab to view:
Status – UP, DOWN, or LOCKED. See Table 7-7 for more information.
Routing Mode of Pool – BALANCED or CHAINED. See Table 7-8 for more information.
Adaptive Server Assigned to Pool – lists all the Adaptive Servers that you assign to this pool.
Processes Blocked on a Locked Pool – number of client connections that are currently blocked on a LOCKED pool.
Cache Interval (seconds) – number of seconds that an outgoing connection is maintained after a client, application, or user disconnects from an Adaptive Server. See “Connection pools and caching” and “Using connection caching” for more information.
Select the Connection Attributes tab to add pool attributes. See “Adding pool attributes” for more information.
Select the Server tab to view the status of the Adaptive Servers that you have configured for the pool. See “Server state” for more information.
Select the Pool Status tab to view or change the pool status in the Pool Status field—UP, DOWN, or LOCKED.
You can delete pools from the main Sybase Central window or the Pool Editor window.
WARNING! You cannot delete a pool that contains Adaptive Servers. The servers in the pool may have processes that are still running. If you attempt to delete a pool that contains Adaptive Servers, you see an error message.
Only after you verify there are no processes that are connected to the Adaptive Servers in the pool, can you remove the Adaptive Servers from the pool and delete the pool.
Select the pool you want to delete.
Select File | Properties. You can also right-click the pool and select Properties, or select the Properties button from the toolbar.
Select the Server tab and verify that there are no servers listed. If there are any servers, you cannot delete the pool.
Click OK to save your changes and return to the Sybase Central window.
Select Edit | Delete to display the Confirm Delete window.
Select Yes to confirm you want to delete the pool.
