Our vBulletin migration is complete.
Welcome vBulletin users! All content and user information from the Micro Focus Forums (vBulletin) site has been migrated to this site. READ MORE.

Who Me Too'd this topic

Who Me Too'd this topic

Contributor.. mbrockbernd Contributor..
Contributor..
298 views

how to cleanup event database omi 10.xx

I want to clean up the event database but I can not find the tables in the database we have omi version 10.12

I use Internal Change Request QCCR1A14629:

OMi does not provide a tool to purge the event tables in the database. You can use opr-close-events and opr-archive-events but this may take a
long time if there are lots of events in the database (Internal Change Request QCCR1A146296).
Note 1: often the problems are not the number of entries in ALL_EVENTS but rather the HISTORY_LINE and EVENT_PROPERTY_CHANGE entries, so the "small" solution is to just cleanup those two tables

I want to use truncate table EVENT_PROPERTY_CHANGE;
commit; delete from HISTORY_LINE;
I can not find the above table in omi 10.x.
Which table should I use?

Who Me Too'd this topic
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.