Oracle configuration with CLM
Procedure
- If you are installing all CLM applications, you must repeat the previous step 3 times to create a separate tablespace for JTS, CCM, and QM. In the Oracle Enterprise Manager Database Control, verify the tablespaces you created are displayed and accessible.
- Note: Do not create the data warehouse tablespace at this stage. The data warehouse tablespace is created during the server setup process.
???
Step 3 states JTS again. Is this an error? Was this Also, step 4 states that the data warehouse will be created later...We don't have consistent access to this Oracle admin, do we tell him to create a DB "space" now?
With DB2, we setup 4 DBs (JTS/DW/CCM/QM). The above instructions seem to state creation of JTS, then JTS (again), CCM and QM...and the datawarehouse to be created later...(which makes 5).
One answer
Sterling, you have to do the steps for JTS, CCM and QM - that means you do it three times. You have 3 databases (RM currently stores its data in the JTS DB). You will need an additional database for the data warehouse. Please see https://jazz.net/library/article/831 . It uses DB2 but essentially there is no difference in the concept.
Comments
Thanks Ralph,
It looks like the documentation for Oracle needs to be revisited. It also tells you to not create a database for the warehouse, that part will be done during setup. Then, it tells you before starting setup, you need to have created the database for the warehouse.
I'll create a WI.
All in case others find this topic in the forum, here is my work item:
https://jazz.net/jazz/web/projects/Jazz%20Collaborative%20ALM#action=com.ibm.team.workitem.viewWorkItem&id=242958