Resetting the Database Log Locater

Reset the locater to 0x0 to direct RepAgent to begin scanning the log from the truncation point.

  1. Update the rs_locater table in the Replication Server System Database (RSSD) for the Replication Server controlling the database using the Adaptive Server stored procedure rs_zeroltm:
    rs_zeroltm data_server, database
    where data_server and database are the respective Adaptive Server and database whose locater value you want to reset. For example, to reset the locater for the MYDS Adaptive Server and the Parts database, execute:
    rs_zeroltm MYDS, Parts