It's all about the answers!

Ask a question

Data warehouse tablespace usage - oracle

Norman Dignard (356693173) | asked Oct 27 '17, 9:54 a.m.
retagged Nov 03 '17, 1:39 a.m. by Minakshi Jaint (5113)

 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.  

In looking at the database space usage, nothing is being written to the DW tablespace.  I'm wondering if we messed up somewhere in our setup.  Has anyone else noted this ?

One answer

permanent link
Kenji Sarai (96029) | answered Oct 29 '17, 8:36 p.m.

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.

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.  

Norman Dignard commented Oct 30 '17, 8:09 a.m.

We do have dcc installed and DCC jobs do execute. The DW tablespace shows no growth . 

Kenji Sarai commented Oct 30 '17, 9:18 p.m.

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).

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.