Configuration parameters allow you to adjust or “tune” the performance of ASE Replicator. See “ASE Replicator configuration parameters” for information about specific parameters.
Some configuration parameters (called connection configuration parameters) affect the behavior of ASE Replicator database connections. See “Configuring a database connection” for more information.
You can use sp_configrep to:
Change the value of a configuration parameter
Find the current value of a configuration parameter
Get information about configuration parameters
To change the value of an ASE Replicator configuration
parameter
Use sp_configrep with the name of the configuration parameter, and the value you want to set:
sp_configrep param, "value"
where param is the name of the ASE Replicator configuration parameter, and value is the value you want to set.
Numeric values are treated as strings, and they must
be enclosed in quotes.
To find the current value of an ASE Replicator configuration
parameter
Use sp_configrep with the name of the configuration parameter:
sp_configrep param
where param is the name of the ASE Replicator configuration parameter you want to find the value of.
To get information about all ASE Replicator configuration
parameters
Use sp_configrep with no parameter:
sp_configrep
