rp_start

Description

Starts a group of previously stopped connections.

You can also use the OpenSwitch Manager to start connections to an Adaptive Server. See “Starting connections to Adaptive Server” for more information.

Syntax

rp_start pool_name, server, spid

Parameters

pool_name: Name of the pool in which to restart connections. If you do not supply a parameter, or use NULL, all pools are started.

server: Indicates that all connections using the remote server are to be started. If you do not supply a server name, or use NULL, all servers are started.

spid: The OpenSwitch process ID of the connection to be started. If you do not supply an argument, or use NULL, all connections are started.

Examples

Example 1

Starts previously stopped spid number 8.

rp_start NULL, NULL, 8

Example 2

Starts all connections that are currently using remote server SYB_SERV1.

rp_start NULL, "SYB_SERV1", NULL

Example 3

Starts all connections established through POOL_A.

rp_start "POOL_A", NULL, NULL

Example 4

Starts all connections established to SYB_SERV1 through POOL_A.

rp_start "POOL_A", "SYB_SERV1", NULL

Usage

Attempting to start a connection that was not previously stopped has no effect.

Messages

The pool_name does not exist. Use rp_pool_help to list valid pool names:
```
rp_start: Invalid pool name 'pool_name'.
```
The server does not exist:
```
rp_start: Invalid server name 'server'.
```
Use rp_server_status to list valid servers.

See also

rp_pool_help, rp_server_status, rp_stop, rp_who