ChannelDB2

RTC 3.0 Install howto

Installation is bit more difficult than in previous version (see my blog post). Manual page is here.

Download Jazz server and install it using IBM Installation Manager.

Enable query hinting in DB2:
db2set DB2_OPTPROFILE=YES


We need to create 2 databases.
db2 create database jazz1 using codeset utf-8 territory en pagesize 16 k
DB20000I Příkaz CREATE DATABASE byl úspěšně dokončen.
db2 create database jazz2 using codeset utf-8 territory en pagesize 8 k
DB20000I Příkaz CREATE DATABASE byl úspěšně dokončen.


Grant admin rights to selected database user (needed only for DB2 9.7)
db2 connect to jazz1
db2 grant dbadm on database to db2admin
db2 connect to jazz2
db2 grant dbadm on database to db2admin


Then we have to edit database configuration files. They are in [Install location]/server/conf/ ccm and jts subdirectory. Database JAZZ1 is for ccm and database JAZZ2 is for jts,
edit file teamserver.properties in each subdirectory. Comment Apache Derby configuration and edit prepared DB2 configuration. Be sure to use correct database JAZZX for each.

com.ibm.team.repository.db.vendor = DB2
com.ibm.team.repository.db.jdbc.location=//localhost:50000/JAZZ2:user=db2admin;password={password};
com.ibm.team.repository.db.jdbc.password=db2password
com.ibm.team.repository.db.db2.content.tablespace.location=content_tablespace.DB


Create database tables. These scripts are in [install location]/server:
repotools-jts.bat -createTables
repotools-ccm.bat -createTables

Read correct procedure for data backups.

Views: 294

Comment

You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

Featured Downloads

Try BLU Acceleration on Cloud

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service