Shut down a group of OpenSwitch connections.
You can also use OpenSwitch Manager to terminate connections.
rp_kill [pool_name, srv_name, spid]
The name of the pool for which the connections should be shut down. Supplying only this argument causes all connections within pool_name to be shut down.
Shuts down connections to remote server srv_name. Supplying only this argument causes all connections to srv_name to be shut down.
Shuts down the connection identified within OpenSwitch by spid. If this argument is specified, pool_name and srv_name are ignored.
Shuts down the OpenSwitch connection represented by spid 8 (as identified by rp_who).
1> rp_kill NULL, NULL, 8 2> go
Shuts down all connections currently established to pool POOL_A.
1> rp_kill "POOL_A", NULL, NULL 2> go
Shuts down all connections currently established to pool POOL_A on server SYB_SERV2.
1> rp_kill "POOL_A", "SYB_SERV2", NULL 2> go
If no arguments are supplied to rp_kill, all connections are killed within OpenSwitch. Use this procedure with caution.
spid refers to the OpenSwitch process ID, not the process ID in the remote Adaptive Server.
To generate a report on the current connections, execute rp_who.
Shutting down a connection causes it to be forcibly removed from OpenSwitch. No messages are delivered to the client.
Indicates the number of OpenSwitch connections that were killed:
rp_kill: Killed n spids.
The pool name you supplied does not exist:
rp_kill: Invalid pool name 'pool_name'.
The server name you supplied does not exist or has not been defined within OpenSwitch:
rp_kill: Invalid server name 'srv_name'.
rp_cancel, rp_who, sp_who