Installing RTC with DB2

Hi everybody. Im new here in jazz.net. For a couple of weeks Ive been getting to know the Jazz platform, especially the RTC as part of an academic research focused on collaborative software development.
Last week I downloaded the 3.0 release and, based on an article about installing RTC wit a DB2 database (http://jazz.net/library/article/549), i got to work. however, I dealt with some issues that Im not sure Ive sorted out properly.

The first iisue was the table creation. Instead of using the following instructions

db2 create database JAZZ using codeset UTF-8 territory en PAGESIZE 16384

db2 create database CCM using codeset UTF-8 territory en PAGESIZE 16384

db2 create database DW using codeset UTF-8 territory en PAGESIZE 16384

I used

db2set DB2_OPTPROFILE=YES



db2 create database JAZZ using codeset UTF-8 territory en PAGESIZE 16384

db2 update db cfg for JAZZ using cur_commit disabled

db2 connect to JAZZ

db2 grant dbadm on database to user db2admin

db2 revoke connect on database from public

db2 terminate



db2 create database CCM using codeset UTF-8 territory en PAGESIZE 16384

db2 update db cfg for CCM using cur_commit disabled

db2 connect to CCM

*

*

*

db2stop force

db2start

so I avoid the case sensitivity error (I suppose it was only related with permissions)

the second issue I managed with was in the CCM teamserver.properties file (in the connection string more specifically). There was written a line like this

com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ:user=db2admin;password={password};

I replaced the JAZZ for the CCM database name as I encountered troubles during the execution of the repotools-ccm instruction (repotools-ccm -createTables -clean) and later in the ccm setup process. I think there is a mistake.

My last question is about the DW configuration: I didnt find the this lines commented in the teamserver.properties files:

com.ibm.team.datawarehouse.db.vendor = DB2

com.ibm.team.datawarehouse.db.jdbc.location=//localhost:50000/DW:user=db2admin;password={password};

com.ibm.team.datawarehouse.db.jdbc.password=password

However, I wrote them into the files (nothing wrong happened).

I would like someone to tell me whether or not Ive done well. If so, Id love to have contributed with the community. If not, I hope someone could help me. :?


Goodbye and thank you for your kind attention.