sp_configrep

Description

Sets or returns information about ASE Replicator configuration parameters.

Syntax

sp_configrep [param [, value]]

Parameters

param

is the name of an ASE Replicator configuration parameter.

Table 4-4 lists all ASE Replicator configuration parameters.

Some configuration parameters (indicated by an asterisk) cannot be changed with the sp_configrep procedure. These parameters must be specified on the aserep command line when the ASE Replicator process is started.

**Table 4-4: ASE Replicator configuration parameters**
Parameter	Description
admin_port *	ASE Replicator client socket port number
ase_charset *	Adaptive Server default character set
ase_host *	Name of the host machine where Adaptive Server resides
ase_port *	Adaptive Server client socket port number
batch_size	Number of commands to batch
batch_timeout	Timeout limit for command batching
ddb_name *	Name of the Distribution Database
log_directory	Directory for system log files
log_trace_verbose	Enable or disable verbose trace message content
log_wrap	Number of 1K blocks before wrapping log files
monitor_delay	Sybase Central monitor ping interval, in seconds
queue_size	Maximum number of log operations kept in an internal queue
scan_sleep_increment	Number of seconds sleep time increases between empty log scans
scan_sleep_max	Maximum number of seconds between log scans
stat_trunc_interval	Number of days after which statistics are deleted from repository
stat_write_timeout	Frequency statistics are written to repository
status_monitoring	Enable or disable Sybase Central status monitoring
truncate_numops	Minimum number of replicated operations in stable queue before truncation occurs

See “ASE Replicator configuration parameters” for more detailed information about these 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_configrep log_wrap, "10"

Sets the ASE Replicator log_wrap configuration parameter to the value 10.

Usage

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

**Table 4-5: 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_configrep is invoked with no parameter (param) specified, it returns a list of all ASE Replicator configuration parameters, with information for each parameter.
When sp_configrep is invoked with a parameter (param) specified, but no value (value), it returns information for the specified parameter.
When sp_configrep is invoked with both a parameter (param) and value (value) specified, it sets the specified parameter to the specified value.
When you change the value of a dynamic parameter, the change occurs immediately after you invoke sp_configrep. To change the value of a static parameter, you must shut down and restart the ASE Replicator process after you set the value.
When the requested action occurs successfully, no results are returned.
When an error occurs, an error message is returned.