Scrubbing the data warehouse (DCC) database
Is there a way to delete data warehouse entries in the DCC database older than a defined age, maybe older than two years?
We have the data warehouse in place since seven years or so anrd it is still growing, holding sprint metrics from 2014 no one cares about.
Or is there any enhancement request regarding this topic?
I've read the workaround of killing the tables and to force a re-index, as this will analyze only the data of the last two years, but based on the amount of data it is no option for us.
greetings georg.
One answer
When Insight was supported, it came with a data warehouse pruning tool that did exactly what you're looking for. I'm not sure how this is released now that Insight is no longer available though.
-bash-4.1$ cd /opt/IBM/RRDI/setup/tool/dw_pruning/
-bash-4.1$ ./pruneDataMart.sh
./pruneDataMart.sh <dbserver> <dbport> <dbname> <dbtype> <dbuser> <dbpassword> <pruneBeforeDate>
./pruneDataMart.sh <dbserver> <dbport> <dbname> <dbtype> <dbuser> <dbpassword> <pruneBeforeDate> <generate report>
DB2 LUW e.g ./pruneDataMart.sh localhost 50000 RIDW DB2 db2admin mypassword "2008-12-31"
DB2 LUW e.g ./pruneDataMart.sh localhost 50000 RIDW DB2 db2admin mypassword "2008-12-31" report
Oracle e.g ./pruneDataMart.sh localhost 1521 RIDW Oracle ora_dba mypassword "2008-12-31"
Oracle e.g ./pruneDataMart.sh localhost 1521 RIDW Oracle ora_dba mypassword "2008-12-31" report
DB2AS400 e.g ./pruneDataMart.sh localhost 446 RIDW DB2AS400 db2admin mypassword "2008-12-31"
DB2AS400 e.g ./pruneDataMart.sh localhost 446 RIDW DB2AS400 db2admin mypassword "2008-12-31" report
DB2Z e.g ./pruneDataMart.sh localhost 3500 RIDW DB2Z db2admin mypassword "2008-12-31"
DB2Z e.g ./pruneDataMart.sh localhost 3500 RIDW DB2Z db2admin mypassword "2008-12-31" report
Comments
Georg Kellner
Feb 17 '20, 9:50 a.m.I've raised a RFE.
http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=140285