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

Questions on RTC 3.0 Databases

In RTC 2.0, I only had to create one database for the RTC server. But in configuring the RTC 3.0 RC1 server, I find that the RTC server now uses multiple databases. Could someone describe what the various databases are used for?

For the default Derby configuration, there are four databases:

  server/conf/ccm/teamserver.properties

com.ibm.team.repository.db.jdbc.location=conf/ccm/derby/repositoryDB
com.ibm.team.datawarehouse.db.jdbc.location=conf/ccm/derby/warehouseDB
server/conf/jts/teamserver.properties
com.ibm.team.repository.db.jdbc.location=conf/jts/derby/repositoryDB
com.ibm.team.datawarehouse.db.jdbc.location=conf/jts/derby/warehouseDB


From the DB2 configuration instructions, I see that I need to create three databases: JAZZ, CCM, and DW. However, the commented out DB2 configuration in server/conf/ccm/teamserver.properties and conf/jts/derby/repositoryDB only reference the JAZZ database:

  server/conf/ccm/teamserver.properties

#com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ:user=db2admin;password={password};
#com.ibm.team.datawarehouse.db.jdbc.location=//localhost:50000/JAZZ:user=db2admin;password={password};
server/conf/jts/teamserver.properties
#com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ:user=db2admin;password={password};
#com.ibm.team.datawarehouse.db.jdbc.location=//localhost:50000/JAZZ:user=db2admin;password={password};


I assume that when configuring the RTC server for DB2, I should use the three databases as follows:

  server/conf/ccm/teamserver.properties

com.ibm.team.repository.db.jdbc.location=//localhost:50000/CCM:user=db2admin;password={password};
com.ibm.team.datawarehouse.db.jdbc.location=//localhost:50000/DW:user=db2admin;password={password};
server/conf/jts/teamserver.properties
com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ:user=db2admin;password={password};
com.ibm.team.datawarehouse.db.jdbc.location=//localhost:50000/DW:user=db2admin;password={password};

Also, should I use the same database, DW, for the both the CCM and JTS data warehouse? Or do I need different databases as in the case for Derby?

The DB2 configuration instructions say to run the following scripts to create tables in the JTS and CCM databases:

  repotools-jts -createTables -clean

repotools-ccm -createTables -clean


However, there's no mention of a script for creating tables in the DW database. Do I need to do anything to initialize the DW database?

Thanks,
Geoff Alexander

0 votes



One answer

Permanent link
That's an interesting one. I hadn't noticed an issue. Maybe their just messing with our heads :lol:

0 votes

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.

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
× 10,938

Question asked: Oct 25 '10, 12:40 p.m.

Question was seen: 5,572 times

Last updated: Oct 25 '10, 12:40 p.m.

Confirmation Cancel Confirm