When a RepAgent starts, it uses a locater to determine where to begin scanning the database log. The locater for a database log is stored in the rs_locater table in the RSSD of the Replication Server that controls the database.
This locater is different from the RSI locater. See “Invalid RSI locater” for more information
about the RSI locater.
The locater points to a record on a page in the database log. If the truncation point for the database is turned off, you or Adaptive Server may truncate the page the locater points to, invalidating the locater. When the locater is invalid, the RepAgent writes error message 9215 (see “9215: log truncated (ASE 624)”) to the Adaptive Server error log.
To recover, reset the locater to 0x0. This directs the RepAgent to begin scanning the log from the truncation point.
To reset the locater, update the rs_locater table in the 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
