If the customer has enabled nightly purging in CC, then CC will purge the partitions for the following tables as part of the purge process:
If the client does not enable the nightly purge then the DBA is responsible for cleaning these up using the following links:
they are listed in the doc link:
Sample commands to drop the partition can be found here:
The DBA should also refer the appropriate database documentation to manage the partitions.
This link provides the details of CC database partitioning.
Maintaining IBM Control Center Summarization Table Data
There are 5 tables that hold summarization data for IBM Control Center (ICC) that you must "maintain" because if you do not, they will grow indefinitely. And know that besides removing data from them on a periodic basis, you must also ensure their indices are maintained regularly, as with all the ICC database tables, to keep performance of ICC as good as possible.
The 5 tables are:
If you're not using DVGs (data visibility groups) in ICC, no data will be written to CC_PROCESS_DVG or CC_FILE_TRANSFER_DVG, which leaves only three tables for you to maintain but I'll cover what you need to do though as if you had DVGs...
First pick a date that represents the oldest summarization data you want to keep. Say it was May 19th, 2017
ROLL_UP is pretty straight forward to "truncate" because DATE_TIME, the column you need to reference in SQL, is just a "varchar" kind of column (as opposed to a "date" type, so SQL to truncate it would just be, for example:
DELETE FROM ROLL_UP WHERE DATE_TIME < '2017-05-20'
The other SQL you'll need to run is slightly "trickier" as you need to convert a string to a date in either Oracle, DB2, or MSSQL SQL, which I must leave to you... But other than that, the SQL is very straight forward
Perform this SQL in this order
DELETE FROM CC_PROCESS_DVG WHERE PROCESS_ID IN (SELECT PROCESS_ID FROM CC_PROCESS WHERE STARTED < your date)
DELETE FROM CC_PROCESS WHERE STARTED < your date
DELETE FROM CC_FILE_TRANSFER_DVG WHERE FILE_TRANSFER_ID IN (SELECT FILE_TRANSFER_ID FROM CC_FILE_TRANSFER WHERE STARTED < your date)
DELETE FROM CC_FILE_TRANSFER WHERE STARTED < your date
Rebuild indexes periodically.
Rebuild these indexes at least every week for the following main tables: