Display Configuration Parameter Settings

Use Adaptive Server stored procedures to display the settings of the RepAgent configuration parameters and other information on RepAgent multithreaded and multiple path status.

  • sp_config_rep_agent – specify only the database name to display the settings of parameters you set with sp_config_rep_agent
  • sp_help_rep_agent – to display additional information on the RepAgent status, specify:
    • send – displays the number of send buffers that you have allocated to RepAgent.
    • config – displays information on the RepAgent multiple path configuration parameters.
    • process – displays information about the multiple Rep Agent processes when you enable multithread rep agent.
  • sp_who – displays information on RepAgent processes and threads running in Adaptive Server

See Replication Server Administration Guide Reference Manual > Adaptive Server Commands and System Procedures for sp_config_rep_agent and sp_help_rep_agent.

See Adaptive Server Reference Manual: Procedures > System Procedures > sp_who.