You can add Adaptive Servers to pools and configure the servers for your OpenSwitch environment.
You can also use the rp_pool_addserver registered procedure to add and configure Adaptive Servers for a pool. See rp_pool_addserver.
Adding Adaptive Servers to a pool
Select the pool to which you want to add Adaptive Servers.
Select File | New | Server. You can also double-click the Add Adaptive Server icon in the Details pane.
Provide the name of the new server in an empty row of the Server Name column. Select Server | Add from the menu bar or click the Add (+) button in the toolbar to create a new row.
Select the status for the new server—UP, DOWN, or LOCKED. See “Server state” for a description of each state.
Sybase recommends that you select the DOWN state so that processes do not switch to the new server immediately. You can change the Adaptive Server status to UP or LOCKED after you assign Adaptive Servers to the pools and verify the pool is ready to accept connections.
Select the new server, then select Server | Properties.
Click the Adaptive Server Attributes tab. Select:
Relative Adaptive Server – to create the new server relative to an existing server. Select the existing server.
Position – to position the new server relative to the existing server: HEAD, TAIL, BEFORE, or AFTER. See Table 7-5 for descriptions of each position.
WARNING! Be careful when you choose the server attributes. You cannot change the server attributes after you save your new server.
Click OK to return to the Adaptive Server window for your pool.
Select Server | Add to add additional servers. Follow step 3 to step 7 for each server you want to add to the pool.
Select File | Save Adaptive Server to save the server and not exit the Adaptive Server Editor window. To save the server and exit the Adaptive Server Editor window, select File | Save Adaptive Server and Close Editor.
Select a server.
Select File | Properties.
Select the General tab to view these properties:
Status – UP, DOWN, or LOCKED. See “Server state” for more information.
High Availability Type – whether the OpenSwitch server is configured for high availability support.
Mutually Aware Cluster Table – whether the OpenSwitch server is configured for mutually-aware support. This field applies only if the OpenSwitch server is part of a mutually-aware cluster.
Connection Monitor User Name – the user name that the connection monitor (CMON) uses to connect to the Adaptive Server.
Deleting Adaptive Servers from a pool
You can delete Adaptive Servers from a pool. You must verify that there are no user connections for the Adaptive Server and that the server status is DOWN before you delete the server from the pool.
You can also use the rp_pool_remsever registered procedure to delete the server from the pool. See rp_pool_remserver for more information.
When you delete the server from the pool, the server still runs but does not accept user connections assigned through the pool.
Select the Adaptive Server you want to delete from the pool.
Select Edit | Delete. The Confirm Delete window displays.
Select Yes to delete the server from the pool.
