The RMS monitors Adaptive Server Enterprise RepAgent threads. sp_help_rep_agent determines the state of RepAgent threads for each database that participates in replication. Table C-15 describes the RepAgent thread states.
State type |
Value |
Meaning |
Description |
---|---|---|---|
Normal |
8 |
ACTIVE |
The RepAgent thread is enabled and started. |
Error |
6 |
DISABLED |
The RepAgent thread is not enabled. |
7 |
SUSPENDED |
The RepAgent thread is enabled but stopped. |