Is it possible to purge data from workitem_snapshot tables?
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.
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.
One answer
BIRT reports can be CPU consuming and you might be able to improve that by improving the BIRT reports. I have heard there are efficient ways and inefficient ways to work in BIRT.
I don't see the dependency between the BIRT reports and the table. I am not sure if trying to fix the problem this way would be helpful.
In general as a user you should never ever ever perform any write or delete operations on the RTC and other CCM Databases, unless requested to do so by IBM support, if you don't intent to wreck your CLM development environment or want to restore from a backup.
You might want to contact support to discuss this and ask if there are possible ways to compact the data.
I don't see the dependency between the BIRT reports and the table. I am not sure if trying to fix the problem this way would be helpful.
In general as a user you should never ever ever perform any write or delete operations on the RTC and other CCM Databases, unless requested to do so by IBM support, if you don't intent to wreck your CLM development environment or want to restore from a backup.
You might want to contact support to discuss this and ask if there are possible ways to compact the data.