View RepAgent Information

Use sp_help_rep_agent at Adaptive Server to monitor the RepAgent.

sp_help_rep_agent displays information about:

Recovery – status and other information when you are restoring a database.
Configuration parameters – the current settings for RepAgent configuration parameters for both single and multiple replication paths.
Process – information about the RepAgent process, including state, sleep status, number of unsuccessful connection retries (if any), and the number of the last error message, for both single and multiple replication paths.
Send buffers - the number of send buffers that you have allocated to RepAgent.
Scanned transactions – information about the current batch of log transactions: start, end, and current markers; the number of records in the batch; and the oldest transaction.
Security – the current settings of the network-based security mechanism.
All – all of the above information.

sp_help_rep_agent [dbname[, 'recovery' | 'config' | 'process' | 'send' | 'scan' | 'security' | 'all']]

dbname is the name of the database for which the RepAgent is enabled.

You can view current status information for one or all options, for example:

To display information about the RepAgent process, log in to Adaptive Server and enter:
```
sp_help_rep_agent pubs2, 'process'
```
To display information about the RepAgent log scanning, enter:
```
sp_help_rep_agent pubs2, 'scan'
```

See Replication Server Reference Manual > Adaptive Server Commands and System Procedures for detailed syntax, usage information, and example output for sp_help_rep_agent.