One source of disk-space problems - EVENTS table in DBDescription: space problems (IC using up 1.5GB in 8 hrs.)
Article ID: KB0084960
Updated On:
| Products | Versions |
|---|---|
| TIBCO InConcert | - |
| Not Applicable | - |
Description
Resolution:
To test the size of the events table, issue the command
SELECTcount( *) FROM EVENTS ;
This data is historical; this table can be truncated if the data is not being used for reports.
In TIBCO InConcert 6.0 and above Events can also turned off. See the Batch Registry documentation on "Update Event Type". Also in IC_HOME/utils there is a file ev-clr-all-record.btg of batch registry commands to clear all events.
You do not need to have the event turned on for a trigger to fire on that event.
To test the size of the events table, issue the command
SELECTcount( *) FROM EVENTS ;
This data is historical; this table can be truncated if the data is not being used for reports.
In TIBCO InConcert 6.0 and above Events can also turned off. See the Batch Registry documentation on "Update Event Type". Also in IC_HOME/utils there is a file ev-clr-all-record.btg of batch registry commands to clear all events.
You do not need to have the event turned on for a trigger to fire on that event.
Issue/Introduction
One source of disk-space problems - EVENTS table in DBDescription: space problems (IC using up 1.5GB in 8 hrs.)
Environment
Product: TIBCO InConcert
Version: All
OS: All
--------------------
Feedback
Yes
No
Powered by
