Removing Expired Entries from the Document History Database

Trading Networks 10.3 | Administering and Monitoring B2B Transactions | Integration Server Administrator's Guide | Using a Document History Database with Exactly-Once Processing | Removing Expired Entries from the Document History Database

Clearing Expired Entries from the Document History Database

To keep the size of the document history database manageable, Integration Server periodically removes expired rows from the database. The value of the trigger's History time to live property determines how long the document history database maintains an entry for a processed document or message.

Integration Server provides a scheduled service to remove expired entries from the database. By default, the Message History Sweeper task executes every 10 minutes. You can change the frequency with which the service executes. For information about editing scheduled services, see Scheduling Services.

Note:
The watt.server.idr.reaperInterval property determines the initial execution frequency for the Message History Sweeper task. After you define a JDBC connection pool for Integration Server to use to communicate with the document history database, change the execution interval by editing the scheduled service.

You can also clear all expired entries from the database at any time. For more information, see Clearing Expired Entries from the Document History Database.