Delete Exceptions by Range

Use stored procedures to delete transactions in the RSSD exceptions log by range instead of individually.

With the rs_delexception stored procedure, you can specify only one transaction to delete from the exceptions log. With Replication Server 15.6, you can use rs_delexception_id, rs_delexception_date, and rs_delexception_range to specify a range of transactions to delete.

When you specify a range of transactions, Replication Server conserves resources and improves performance by creating only one temporary table for the range of transactions instead of a table for each transaction.

• rs_delexception_id
  Deletes a range of transactions identified by transaction ID in the exceptions log in the rs_exceptscmd, rs_exceptshdr, and rs_systext system tables.
• rs_delexception_date
  Deletes a range of transactions identified by transaction date in the exceptions log in the rs_exceptscmd, rs_exceptshdr, and rs_systext system tables.
• rs_delexception_range
  Deletes a range of transactions identified by originating site or user , or destination site in the exceptions log in the rs_exceptscmd, rs_exceptshdr, and rs_systext system tables.