rs_zeroltm

Resets the locator value for a database to zero (0). Use this stored procedure after you have used the Adaptive Server command dbcc settrunc to disable the secondary truncation point and truncate the logs, but before you restart Replication Server.

Syntax

rs_zeroltm data_server, database

Parameters

data_server – The data server with the database whose locator value you want to reset.
database – The database whose locator value you want to reset.

Examples

Example 1 – Resets the locator value to 0 for the TOKYO_DS data server and the pubs2 database.
```
rs_zeroltm TOKYO_DS, pubs2
```

Usage

Use this command for RepAgent-enabled databases.
Use dbcc settrunc to disable the secondary truncation point and truncate the log, before using rs_zeroltm.
The locator value for a replicated database is maintained by the Replication Server and stored in the rs_locater table. Its value normally matches that of the secondary truncation point stored in the Adaptive Server.

If the transaction log fills up, you may have to use the dbcc settrunc command to disable the secondary truncation point and truncate the log. dbcc settrunc resets the secondary truncation point, and the locator value and the secondary truncation point no longer match. Execute rs_zeroltm to bring the values back in sync: Setting the locator value to zero with rs_zeroltm tells Replication Server to get the new secondary truncation point from Adaptive Server and set the locator to that value.