Truncating an Adaptive Server Log

Truncate the database log when it is too full to allow Adaptive Server to continue processing updates.

Adaptive Server uses truncation points to ensure that only transactions processed by the RepAgent are truncated. A secondary truncation point marks the place in the primary database log up to which the RepAgent has processed transactions. The RepAgent periodically updates the secondary truncation point to reflect transactions successfully passed to the Replication Server. Adaptive Server does not truncate the log past the secondary truncation point. See Replication Server Administration Guide Volume 1.

At times you may need to truncate the log beyond the secondary truncation point. For example, if the RepAgent cannot access the Replication Server and the log fills, you may want to truncate the log at the secondary truncation point rather than extending the log or preventing clients from updating the primary database. Truncating the log can cause inconsistencies between the primary and replicate databases.

  1. Verify that the secondary truncation point is set for the database.
  2. Turn off the secondary truncation point in the database.
  3. Dump the database log. See the Adaptive Server Enterprise Reference Manual.
  4. Set the secondary truncation point.
Related reference
Log Truncation Problems