Stopping connections to Adaptive Server
Select the Adaptive Server where you want to stop connections.
Select File | Connections | Stop.
You can select these options:
Ignore Transaction State When Stopping a Connection – OpenSwitch stops all connections to the Adaptive Server whether or not they are involved in an open transaction.
If you do not select this option, OpenSwitch stops connections as soon as they complete their current transaction.
Ignore Remote Adaptive Server Failures – if you select this option, and if an Adaptive Server actively being used by a stopped connection fails, the normal failover process proceeds for the connection as soon as you restart the connection.
If you do not select this option, and if an Adaptive Server actively being used by a stopped connection fails, an attempt is made to reestablish the connection silently without notifying a coordination module when you restart the connection.
You can also use the rp_stop registered procedure to stop connections. See rp_stop.
Click OK to save your options and stop all connections to the Adaptive Server.
Switching connections from Adaptive Server
You can switch all connections from one Adaptive Server to another Adaptive Server in the same pool. You cannot choose to which server you want to switch connections. Connections switch to servers according to the server order you specify when you add servers to pools. See “Adding Adaptive Servers to a pool”.
Select the Adaptive Server where you want to change the connections.
Select File | Connections | Switch.
You can select these options:
Grace Period (in seconds) – to specify the maximum number of seconds to wait before forcefully switching busy connections. A value of 0 indicates that OpenSwitch does not enforce a grace period.
Force switch – if you select this option, OpenSwitch forcefully switches all connections, even if the connections are currently busy, they are either actively in the middle of communicating with a remote server, or in the middle of processing open transactions.
If you do not select this option, OpenSwitch switches connections only if they are not busy.
You can also use the rp_switch registered procedure to switch connections. See rp_switch.
Click OK to save your options and switch all connections from the Adaptive Server.
Starting connections to Adaptive Server
You can use OSWM to start connections to a server.
Select the Adaptive Server where you want to change the connections.
Select File | Connections | Start.
Click OK to start the end user connections to the server that you previously stopped.
You can also use the rp_start registered procedure to start connections. See rp_start.
