Managing the Size of the Document History Database
To keep the size of the document history database manageable, Integration Server periodically removes expired rows from the database. The length of time the document history database maintains information about a UUID varies per trigger and depends on the value of the trigger’s History time to live property.
Integration Server provides a scheduled service, namely the Message History Sweeper, that removes expired entries from the database. By default, the Message History Sweeper task executes every 10 minutes. You can change the frequency with which the task executes. For information about editing scheduled services, see
Scheduling a User Task. 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 use Integration Server Administrator to clear expired document history entries from the database immediately.
To clear expired entries from the document history database
1. Open Integration Server Administrator.
2. From the Settings menu in the Navigation panel, click Resources.
3. Click Exactly Once Statistics.
4. Click Remove Expired Document History Entries.