How to purge the deleted objects from the TIBCO Business Events (BE) backend datastore table without restarting the Cache Servers an Inference Agents?
book
Article ID: KB0084460
calendar_today
Updated On:
Products
Versions
TIBCO BusinessEvents Enterprise Edition
-
Not Applicable
-
Description
Resolution: A better approach to this is available, since BE 3.0.1 HF2 release.
When a cache server was restarted, it performed automatic cleanup of the entries in the DeletedEntities table. This activity could sometimes affect performance.
Cleanup of deleted entities at cache server startup is now optional. You can do the following instead, to help reduce startup time:
1. Set the following property to false: be.engine.cluster.cleanup (It is true by default.) When set to false, cleanup of deleted entities is skipped.
2. The OracleDeployment utility now generates the following script: xxx_delete.sql
Run this script to delete the entities in the DeletedEntities table from the backing store. You can run the script even when the system is running.
Issue/Introduction
How to purge the deleted objects from the TIBCO Business Events (BE) backend datastore table without restarting the Cache Servers an Inference Agents?