Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Oracle configuration with CLM

Questions
Tags
Users
Badges
Sterling Ferguson-II
(1.6k●14●288●273) edited
Nov 28 '12, 4:19 p.m.

Procedure

  1. As a system administrator, create a database with UTF8 encoding for the Jazz Team Server and all applications.
  2. Open an SQL *Plus window, and create the database tablespaces: 
    CREATE TABLESPACE <jts user tablespace> 
DATAFILE '<path and name of .dbf file>' 
SIZE 1G AUTOEXTEND ON EXTENT MANAGEMENT LOCAL AUTOALLOCATE;		
		
		
    CREATE TEMPORARY TABLESPACE <jts user temp tablespace> 
TEMPFILE '<path and name of the temp .dbf file>' 
SIZE 20M AUTOEXTEND ON EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;
  3. 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.
  4. 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).

0 votes

1 answer
5,212 views
0 votes

One answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.1k●3●36●48) Nov 29 '12, 3:26 a.m.
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.

0 votes

Comments
Sterling Ferguson-II
Nov 29 '12, 8:30 a.m.

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.

Sterling Ferguson-II
Nov 29 '12, 6:07 p.m.

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

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,520
× 6,132

Question asked: Nov 28 '12, 3:36 p.m.

Question was seen: 5,212 times

Last updated: Nov 29 '12, 6:07 p.m.

Confirmation Cancel Confirm