Verifying that rs_username Login has Appropriate Permissions

Verify the Replication Agent login in Replication Server.

The Replication Server connect source lti command:
  • Verifies that the Replication Server database connection used by the Replication Agent exists in the primary Replication Server

  • Verifies that the login name specified in the Replication Agent rs_username parameter has permission to connect to the primary Replication Server as a data source

  • Returns a version string that shows the highest numbered version of LTL that the primary Replication Server supports

Refer to the Replication Agent Installation Guide > Installation and Setup Worksheet for the parameter values required for this task.

  1. Log in to the primary Replication Server with the Replication Agent user login name specified in the rs_username configuration parameter.
  2. Execute:
    connect source lti pds.pdb version
    where:
    • pds is the value specified for the Replication Agent rs_source_ds configuration parameter.

    • pdb is the value specified for the Replication Agent rs_source_db configuration parameter.

    • version is the proposed LTL version number.

    Enter 999 for the value of the LTL version number. Replication Server returns the highest numbered version of LTL that it supports.

  3. Disconnect from the primary Replication Server as rs_username, and then log in to the Replication Agent instance with the administrator login and invoke the resume command.

For more information about the connect source lti command, see the Replication Server Design Guide and Replication Agent Reference Manual.