Use sp_who to view the Adaptive Server RepAgent thread status.
-
Log in to the primary Adaptive Server data server using isql.
-
Run sp_who to verify that the RepAgent is active.
See Adaptive Server Enterprise > Reference Manual: Procedures > System Procedures > sp_who.
If the RepAgent is down, one of these can be the cause of its failure:
-
The Adaptive Server log is corrupt.
-
The Adaptive Server log is full.
-
The RepAgent set an illegal truncation point.
-
The RepAgent used an incorrect primary Replication
Server login.
-
text, unitext,
or image columns have inconsistent replication
status.
-
Incorrect replication system configuration.