Responds to spid waiting for coordination module response.
rp_set_srv spid, srv_name
The OpenSwitch process identifier of the connection waiting for a response from a coordination module.
The name of the remote server to which the connection, represented by spid, should be switched. Passing a server name of NULL or “” causes the spid to switch to the next available server according to the mode of the pool to which it belongs.
Connects spid 8 to SYB_SERV3.
rp_set_srv 8, "SYB_SERV3"
Connects spid 8 to the next available server in its pool.
rp_set_srv 8, ""
When a connection requests a server name from a coordination module, for any reason (including a login attempt or a failure detected from an existing server), the failing connection issues an np_req_srv notification procedure call that is detected by the coordination module (see “np_req_srv”). The requesting connection suspends until the coordination module responds with a call to rp_set_srv, rp_switch, or rp_kill.
rp_set_srv is intended for use by the coordination module to set the server for a spid through cm_set_srv, but an administrator can also manually set the server for a spid if the spid is at a “SERVER REQ” state. This can happen if COORD_MODE is set to ALWAYS and no coordination module is running.
You can list the set of spids awaiting a response from the coordination module using the Open Server built-in registered procedure sp_ps. These spids display a sleep_label of “SERVER REQ”.
Calling rp_req_srv on a spid that is not actively waiting for a response from a coordination module has no effect.
rp_kill, rp_switch
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
