Impact of Removing the data warehouse set up in production evironment
hi,
We are using RTC CCM application from last 5-6 years. We have a DB2 10.1 data warehouse system. We need to migrate the DB2 10.1 to 11.1 but we are having space issues in the server hence not able to take the backup.
So our team has decided to shutdown the data warehouse.What will be the impact of removing this old data warehouse system.
Accepted answer
Hi Aastha,
If you are using reports including ones in dashboard, these report will no longer display the result. Here is the list of pre-defined reports.
https://jazz.net/help-dev/clm/topic/com.ibm.team.reports.doc/topics/r_report_templates_oob.html
The ones with DW are BIRT-based which are retrieving data from data warehouse. So they will be no longer available. Also other type of reports below will be affected too:
- Cognos-based (or Business intelligence) reports which are created in Rational Insight or RRDI
- JRS (or Report Builder) reports
Note: these reports might be imported into CCM dashboard.
The below are not affected because they are not retrieving data from data warehouse:
- Document-style (or RRDG, Live report) report which is created in Rational Publishing Engine
- Reports using LQE data source
Comments
Thank you so much for quick response. I have to upgrade my data warehouse which is running on DB2 10.1 to DB2 11.1 . Can I reproduce the data warehouse with database and tablespaces backup ? In case I my upgrade fails is there a way I can create data warehouse again?
You can recreate a new data warehouse easily, even if you lose the old one. Just run a full ETL job (data collection job) to load data into new data warehouse.