Setting the Secondary Truncation Point

Reestablish the secondary truncation before restarting a RepAgent.

1. Log in to the Adaptive Server that contains the database for which to reestablish the secondary truncation point.
2. Execute dbcc settrunc(ltm,valid) to reestablish the secondary truncation point.
   For example, to reestablish the secondary truncation point in the Parts database:

   > use Parts
   > go
   > dbcc settrunc(ltm, valid)
   > go

3. Verify that the secondary truncation point has been enabled:

   > use Parts
   > go
   > dbcc gettrunc
   > go

   The output should show 1 in the ltm_trunc_state column.

4. Reset the locater for the database in the rs_locater table.
5. Resume the Replication Server to restart the RepAgent.