Check status and operation

Replication Server provides several admin commands that you can use to check on its status and operation.

StepsChecking the status and operation of the Replication Server

  1. Log in to the Replication Server with a user login that has “sa” permission.

  2. Use the following command to check the current status of the Replication Server:

    admin health
    

    This command returns the current status of the Replication Server, as shown in the following example:

    Mode         Quiesce     Status
    -------       -------     ------
    NORMAL        FALSE      HEALTHY
    

    If the Replication Server status is SUSPECT, use the admin who_is_down command to check for Replication Server threads that may be down or attempting to connect to other servers.

  3. Use the following command to check the current status of the Replication Server primary database connection (the connection from the Replication Agent to the primary Replication Server):

    admin show_connections
    

    You can also use the admin who, dsi command to get more information about the Replication Agent connection in the primary Replication Server.

    NoteUse the admin show_connections or admin who, dsi command output to verify that the primary data server and primary database names are correct for the Replication Agent connection in the primary Replication Server.

See the Replication Server Reference Manual for more information about the admin show_connections and admin who commands.