Do we have any documentation regarding the possible status of the instances inside this table? I want to create an Oracle procedure to automate the clean up of the tables… I want to program this script only to delete the instanceIDs that have status completed in Monitor.
Regards,
Kleber Ferreira
Additional doubt:
In order to get a best performance in my company database, we find out that the field called contextid, inside of WMProcessStep is not part of any index.
As we have a problem opening an instance pipeline in Monitor (the oracle database stopped to answer the clients requests), we are considering to create an additional index to this table. The index will be the contextID itself.
Any suggestion about this problem?
Regards,
Kleber Ferreira
There are archive services provided by wM in WmMonitor/pub/monitor/archive and you can archive right from the lower left hand side of the WmMonitor page. We however found that if you are trying to archive large amounts of data, these are pretty inefficient. Because of confidentialilty reasons I can not share the source code of the stored procs we wrote, but I can tell you that we set the debug level to 10 on the IS and then ran the supplied archives to view the sql that was executed. Then we tuned those statements.
We also added an index for contextid and did not experience any problems. Additionally we have one for audittimestamp and another with the columns (instanceid, instanceiteration, stepid, and stepiteration). I can’t remember if either of these were supplied by wM or not however.
Good luck!
Tim