Setting the Frequency of Secondary Truncation Point Requests

Set the frequency of truncation point request intervals for RepAgent.

1. Set the frequency of secondary truncation point requests from RepAgent to Replication Server:

    sp_config_rep_agent dbname, 'trunc point request interval', 'trunc_point_request_interval_value'

   The range of values for trunc_point_request_interval_value is from 1 second up to the value of MAXINT which is 2,147,483,647 seconds. The default is 10 seconds. The parameter is dynamic; you need not restart RepAgent.
2. See the NumberOfTruncPointRequested and NumberOfTruncPointMoved fields in the monRepScanners Adaptive Server monitoring table to track truncation point status.