How to purge the deleted objects from the TIBCO Business Events (BE) backend datastore table without restarting the Cache Servers an Inference Agents?

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?