It's all about the answers!

Ask a question

[closed] Is it possible to purge data from workitem_snapshot tables?


Steve Mills (5111) | asked Jul 13 '16, 4:17 p.m.
closed Jul 14 '16, 12:23 a.m. by Donald Nong (14.5k614)
   We are constantly dealing with high CPU consumption on our DB2 database and are tracking most of the long running DB processes to our BIRT reports.  We have data in these table dating back to 2009 and see table scans of over 600,000,000 rows.

Is there a way we can purge data out of these tables that are older than some predefined or supplied date?  I can't see how we would ever need to report on records that are more than 2 or 3 years old.

We are currently running RTC 5.0.2 iFix15.

The question has been closed for the following reason: "Duplicate Question" by dnong Jul 14 '16, 12:23 a.m.