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 the Replication Server 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.