Data warehouse tablespace usage - oracle
We're now running 602 using oracle as a back end. In our initial setup (3.x) we created all the required user accounts and tablespaces including one for DW.
One answer
Hi Norman,
DW is the database for data warehouse, and it is used for reporting applications such as BIRT, Jazz Reporting Service, Cognos BI (Rational Insight). Some of them are displayed in CLM dashboard as mentioned as DW reports in below link.
https://www.ibm.com/support/knowledgecenter/SSYMRC_6.0.2/com.ibm.team.reports.doc/topics/r_report_templates_oob.html
In order to load data into DW, ETL job (one of them below) must be installed and executed.
- Java ETL in RRDI (version 3.x)
- Data Collection Component (version 6.0.2)
- Data Manager ETL in Rational Insight (optional, if you have one)
So if you have not configured any of them, then there in no data in DW. DW is optional for reporting. You cannot view the DW reports as above link, but no other impact on CLM main functionality.
Comments
We do have dcc installed and DCC jobs do execute. The DW tablespace shows no growth .
Check the dcc log files in [JazzTeamServer]\server\logs. You can see how many records are inserted / updated into data warehouse in dcc_etl.log and many other dcc_etl_*.log.
Also go to https://[server]:[port]/dcc/admin, click Database Connection, and verify if the database set here is DW (what you are monitoring now).