Verifying That All RepAgents are Up

Use sp_who to view the Adaptive Server RepAgent thread status.

1. Log in to the primary Adaptive Server data server using isql.
2. 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.