sp_configreplicateconn

Description

Sets or returns information about replicate connection configuration parameters.

Syntax

sp_configreplicateconn conn_name [, param [, value]]

Parameters

conn_name

is the name of a replicate database connection. Connection names must be specified in the form ds.db, where:

ds is the name of the data server on which the replicate database resides.
db is the name of the replicate database.

param

is the name of an ASE Replicator connection configuration parameter.

Table 4-6 lists the ASE Replicator replicate connection configuration parameters:

**Table 4-6: Replicate connection configuration parameters**
Parameter	Description
gen_id	Database generation ID (first two bytes in the connection’s locator value)
queue_size	Maximum number of log operations kept in an internal queue

See “Connection configuration parameters” for more detailed information about these connection configuration parameters.

value: is the value to which the configuration parameter (param) is set. Numeric values are treated as strings and must be enclosed in quotes.

Examples

Example 1

sp_configreplicateconn "boulder.doc", queue_size, "100"

Sets the value of the queue_size configuration parameter to 100 for the replicate connection to the database doc on the data server boulder.

Usage

When listing information about connection configuration parameters, the following result set is returned:

**Table 4-7: ASE Replicator configuration parameter information**
Column	Datatype	Description
parameter_name	varchar(128)	Name of the configuration parameter
default_value	varchar(255)	Default value of the parameter
legal_values	varchar(255)	Legal values of the parameter
description	varchar(255)	Description of the parameter

When sp_configreplicateconn is invoked with a connection name (conn_name) specified, but no parameter (param), it returns the values of all connection configuration parameters for the specified connection.
When sp_configreplicateconn is invoked with a connection name (conn_name) and a parameter (param) specified, but no value (value), it returns the value of the specified parameter for the specified connection.
When sp_configreplicateconn is invoked with a connection name (conn_name), a parameter (param), and a value (value) specified, it sets the specified parameter to the specified value for the specified connection.
When the requested action occurs successfully, no results are returned.
When an error occurs, an error message is returned.