You can monitor the RepAgent by using sp_help_rep_agent at Adaptive Server. 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’s configuration parameters.
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.
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.
Log in to Adaptive Server and execute sp_help_rep_agent at the isql prompt:
sp_help_rep_agent [dbname[, 'recovery' | 'config' | 'process' | 'scan' | 'security' | 'all']]
dbname is the name of the database for which the RepAgent is enabled.
Refer to Chapter 5, “Adaptive Server Commands and System Procedures,” in the Replication Server Reference Manual for detailed syntax and usage information about sp_help_rep_agent.
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 the Replication Server Reference Manual for examples of sp_help_rep_agent output.
