Hi Erich,
I would advise you to plan carefully to add a new data warehouse. It may require significant amount of H/W resource and job running time if there are millions of data in CCM, QM, RM. Here are the answers for your questions:
- DCC is the application to collect data into the data warehouse. In order to take advantage of having data warehouse, you need another application for report creation such as Report Builder (/rs), Birt, or Cognos BI. Report Builder is a part of CLM package, so this is the standard choice.
- It is highly recommended to set up DCC (and RS) in the separate server if you do not want to sacrifice the performance for CCM, RM, QM. Please see the CLM system requirements, estimate how many resources (by number of users, number of data, frequency of DCC job...) are required for report server, then determine the H/W spec.
- You will need to setup DCC and data warehouse which can be running on WAS and DB2 respectively. You can set up new database "DW" either on existing DB2 or new DB2 (recommend the latter as the reason above). The setup wizard (/jts/setup) will help you create a database schema for DW.
- You can add DCC application from IM's Configure menu by ticking Data Collection Component. No need to add a new installer as DCC is a part of CLM installation package in 6.0.x. Then run JTS setup wizard to register application and configure data warehouse. If you install DCC in the separate machine, then copy the CLM installer to this machine, and install WAS, DB2, and CLM (DCC application only). Read the instruction below and understand how to run setup wizard for the new application installed in separate machine.
https://jazz.net/help-dev/clm/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_wizard.html