Viewing configuration parameter values

To view a list of default, current, and runtime configuration parameter values for a particular RepAgent, log in to Adaptive Server and execute sp_config_rep_agent without options. For example:

sp_config_rep_agent pubs2

If you do not specify a database name, sp_config_rep_agent displays configuration values for all RepAgent-enabled databases.

To view values for a specific parameter, include the parameter name. For example:

sp_config_rep_agent pubs2, ‘scan batch size’

See “sp_config_rep_agent” in the Reference Manual for output examples.

Refer to Chapter 5, “Adaptive Server Commands and System Procedures,” in the Replication Server Reference Manual for more information about sp_config_rep_agent.