Operations Orchestration - Database cleanup?
After having an OO environment up and running for a year or so, the 'runstep_history' and 'property_history' tables in the database have grown to 38GB between them.
Data never seems to be purged from these tables.
These have become a bit difficult to query in OO or even directly to SQL.
I can't find any reference to any process to manage these tables in documentation or the OO Administration interface.
We don't need detail going back this far, and would much rather have a responsive interface.
Does anyone know if there is a supported process to archive off these history tables, or even better, a setting somewhere to define how long OO keeps this history?
Thanks in advance,
P.S. This thread has been moved from ITRC HP Software: Data Center Automation Center Forum to Operations Orchestration Support Forum - Forum Moderator
I found this package which seems to answer my question.
Happy to hear anyone else's experience with this, but this should allow me to fix the problem.
I am seeing the same issue but we use an Oracle database. I received the scripts for purging the Oracle db but I keep running into errors and the documentation is not helping. I believe that there are some syntax issues with the naming of the tables between the scripts, as if they were never tested. I'm curious if you had any luck with the scripts you found for MSSQL?