Verify the Mirror Replication Agent instance installation

This section describes the required steps to verify an Mirror Replication Agent instance:

StepsTo verify the Mirror Replication Agent installation

  1. Using dsedit, update the Replication Server interfaces file to include an entry for the Mirror Replication Agent location.

    NoteYou can use any Tabular Data Stream™ (TDS) client utility (isql, isqlApp, or SQLAdvantage) that you prefer.

  2. Verify the connection to the Mirror Replication Agent:

    1. Open a command window in the $SYBASE directory of your Replication Server installation.

    2. Set the environment variables by sourcing the SYBASE.csh file.

    3. Use isql to log in to Mirror Replication Agent:

      isql –Usa –P –Smyma
      
  3. Verify the Mirror Replication Agent connection to Replication Server:

    1. Enter this command:

      test_connection RS
      
      go
      
    2. This output appears:

       Type Connection ---- ---------- RS   succeeded(1 row affected)
      
    3. If the result indicates a failure, either the server is not responding, or the connection properties (host, port, user, or password) are incorrect.Verify the host and port configuration values, and manually log in to the Replication Server as the configured user to determine which property is incorrectly defined.

      For additional information, refer to the Mirror Activator Administration Guide, Chapter 2, “Setup and Configuration,” in the section titled, “Testing network connectivity.”

  4. Verify the Mirror Replication Agent connection to the primary ASE database:

    1. Enter this command:

      test_connection PDSgo
      

      This output appears:

      Type Connection ---- ---------- PDS  succeeded(1 row affected)
      
    2. If the result indicates a failure:

      • The server is not responding, or

      • The connection properties host, port, pds_database_name, user, or password are incorrect.

      Check the host and port configuration values, and manually log in to the primary ASE database as the configured user (pds_username in the $SYBASE/MA-15_0/init/myma.rs) to find which property is incorrectly defined.

      For more information about connection failures, see the Mirror Replication Agent Administration Guide section titled, “Testing network connectivity.”