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:
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:
I assume that when configuring the RTC server for DB2, I should use the three databases as follows:
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:
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
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