Hi,
I am trying to configure the DB2 with RTC 3.0.1 but not able to do so. Steps I followed:
1. I have done the setup with Derby and tomcat and checked everything works fine. during the setup i created user called dw for datawearhosue as well.

2. I installed the DB2 and created the Database (CCM,JTS, QM, DW). Works OK

3. I edited the teamserver.properties file and looks like below

========================

# DB2 configuration
#

# Comment out the above lines, uncomment the following five database properties
# and customize the example database location to use DB2.
# NOTE THAT EVERY APPLICATION INSTANCE AND JAZZ TEAM SERVER REQUIRES ITS OWN UNIQUE DATABASE.
com.ibm.team.repository.db.vendor = DB2
com.ibm.team.repository.db.jdbc.location=//mapanda3:50000/JTS:user=db2admin;password={password};
com.ibm.team.repository.db.jdbc.password=db2admin

# DB2 requires a path where the content tablespace should be created, examples for Win and Linux follow
com.ibm.team.repository.db.db2.content.tablespace.location=content_tablespace

# Configure the size of the tablespace to be created, in 16K pages.
# This is a hard limit and will need to be raised for a production database.
# Your DB2 DBA will need to monitor the utilization of the CONTENTS tablespace and grow it as needed.
# Defaulting to 250,000 pages, or 4GB.
#com.ibm.team.repository.db.db2.content.tablespace.numpages=250000


# Comment out the Derby datawarehouse properties, uncomment the following
# five lines and customize the location to use DB2 for managing datawarehouse.
com.ibm.team.datawarehouse.db.vendor = DB2
com.ibm.team.datawarehouse.db.jdbc.location=//mapanda3:50000/DW:user=db2admin;password={password};
com.ibm.team.datawarehouse.db.jdbc.password=db2admin
# The path where the warehouse tablespace should be created
com.ibm.team.datawarehouse.db.base.folder = /jazzdw
# The database user for whom proper permissions will be granted
com.ibm.team.datawarehouse.report.user = RPTUSER

#
# Oracle configuration
#

# Comment out above lines, uncomment the following lines and customize example location to use Oracle
# Note: Oracle location URLs can take several forms. The examples here will work under most circumstances.
# Please consult the Oracle JDBC documentation for more details.
# NOTE THAT EVERY APPLICATION INSTANCE AND JAZZ TEAM SERVER REQUIRES ITS OWN UNIQUE ORACLE USER or DATABASE
#com.ibm.team.repository.db.vendor = ORACLE
# localhost connection strings should not include preceding //
#com.ibm.team.repository.db.jdbc.location=thin:jazzDBuser/{password}@localhost:1521/ORCL
# non-localhost connection strings MUST include preceding //
#com.ibm.team.repository.db.jdbc.location=thin:jazzDBuser/{password}@//oracleserver.example.com:1521/ORCL
#com.ibm.team.repository.db.jdbc.password=jazzDBpswd

#com.ibm.team.datawarehouse.db.vendor = ORACLE
# localhost connection strings should not include preceding //
#com.ibm.team.datawarehouse.db.jdbc.location=thin:jazzDBuser/{password}@localhost:1521/ORCL
# non-localhost connection strings MUST include preceding //
#com.ibm.team.datawarehouse.db.jdbc.location=thin:jazzDBuser/{password}@//oracleserver.example.com:1521/ORCL
#com.ibm.team.datawarehouse.db.jdbc.password=jazzDBpswd
# The path where the warehouse tablespace should be created
#com.ibm.team.datawarehouse.db.base.folder = /jazzdw
# The database user for whom proper permissions will be granted
#com.ibm.team.datawarehouse.report.user = RPTUSER

# Sql Server configuration
#

# Comment out above lines, uncomment the following six lines and customize example location to use Sql Server
# NOTE THAT EVERY APPLICATION INSTANCE AND JAZZ TEAM SERVER REQUIRES ITS OWN UNIQUE DATABASE
#com.ibm.team.repository.db.vendor = SQLSERVER
#com.ibm.team.repository.db.jdbc.location=//localhost:1433;databaseName=jazz;user=jazzDBuser;password={password}
#com.ibm.team.repository.db.jdbc.password=jazzDBpswd

#com.ibm.team.datawarehouse.db.vendor = SQLSERVER
#com.ibm.team.datawarehouse.db.jdbc.location=//localhost:1433;databaseName=jazz;user=jazzDBuser;password={password}
#com.ibm.team.datawarehouse.db.jdbc.password=jazzDBpswd
# The path where the warehouse tablespace should be created
#com.ibm.team.datawarehouse.db.base.folder = /jazzdw
# The database user for whom proper permissions will be granted
#com.ibm.team.datawarehouse.report.user = RPTUSER

#
# DB2i configuration
#

# Comment out above lines, uncomment the following six lines and customize example location to use DB2i
# NOTE THAT EVERY APPLICATION INSTANCE AND JAZZ TEAM SERVER REQUIRES ITS OWN UNIQUE DATABASE
#com.ibm.team.repository.db.vendor = DB2i
#com.ibm.team.repository.db.jdbc.location=//hostname;hold statements=true;metadata source=1;user=jazzDBuser;password={password};
#com.ibm.team.repository.db.jdbc.password=jazzDBpswd

#com.ibm.team.datawarehouse.db.vendor = DB2i
#com.ibm.team.datawarehouse.db.jdbc.location=//hostname;hold statements=true;metadata source=1;user=jazzDBuser;password={password};
#com.ibm.team.datawarehouse.db.jdbc.password=jazzDBpswd
# The database user for whom proper permissions will be granted
#com.ibm.team.datawarehouse.report.user = RPTUSER

#
# DB2z configuration
#
# NOTE THAT EVERY APPLICATION INSTANCE AND JAZZ TEAM SERVER REQUIRES ITS OWN UNIQUE DATABASE

#com.ibm.team.repository.db.vendor = db2z
# Location name of the DB2z sub-system.
# ipAddress, ipPort and location be obtained by running the DB2 command -DISPLAY DDF
#com.ibm.team.repository.db.jdbc.location=//ipAddress:ipPort/location:user=jazzDBuser;password={password};
#com.ibm.team.repository.db.jdbc.password=jazzDBpswd
# DB2z repository Database name - must be unique for each database in the same DB2z subsystem
#com.ibm.team.repository.db.db2.dsn.dbname=JAZZDB
#DB2z schema prefix - must be unique for each database in the same DB2z subsystem
#com.ibm.team.repository.db.schemaPrefix=xx

#com.ibm.team.datawarehouse.db.vendor = db2z
#com.ibm.team.datawarehouse.db.jdbc.location=//ipAddress:ipPort/location:user=jazzDBuser;password={password};
#com.ibm.team.datawarehouse.db.jdbc.password=jazzDBpswd
# The database user for whom proper permissions will be granted
#com.ibm.team.datawarehouse.report.user = RPTUSER
#com.ibm.team.datawarehouse.db.db2.dsn.dbname=RIDW

#
# J2EE database connection example
#
#com.ibm.team.repository.db.type = J2EE
#com.ibm.team.repository.db.vendor=<VENDOR>
#com.ibm.team.repository.db.j2ee.dataSource = /jdbc/jazz

# Setting this value to 'true' opens a wide security hole. Only set it to 'true'
# in development time, when security isn't important and the developer
# doesn't wish to spend time configuring true J2EE authentication.
com.ibm.team.repository.ws.allow.identity.assertion = false

# Used for product packaging
com.ibm.team.repository.web.pageorder = {"com.ibm.team.repository.web.admin": \
, \
"com.ibm.team.process.web.projectArea": \
,\
"com.ibm.team.process.web.projectAreaList": \
}

com.ibm.team.repository.web.suppressedPages = {"com.ibm.team.repository.web.admin": \
}

com.ibm.team.repository.web.helpuri = /clmhelp/index.jsp

#
# Freshness specification, in seconds, for ChangeEvent scrubbing. Items older than this are
# deleted from the database. For the itemTypes WorkItem and BuildResult (as specified in
# "changeEvent.expirationByType") freshness spec is 60 days and 2 days, respectively. The
# default age, (as specified in "changeEvent.expirationDefault") is 14 days.
#
# All times must be represented in seconds.
#
# Values for the "changeEvent.expirationByType" and "changeEvent.expirationByCategory"
# properties are space-delimited. Each value is a tuple of
# itemType shortName or longName, separated by ':', followed by a maxage
# value in seconds. Whitespace is not allowed between the itemType, ':', and
# maxage value. For "expirationByCategory", "itemType" is replaced by a category
# string, as would be found in the category field of ChangeEvent.
#
com.ibm.team.repository.changeEvent.expirationDefault = 1209600
#com.ibm.team.repository.changeEvent.expirationByType = com.ibm.team.workitem.WorkItem:5184000 com.ibm.team.build.BuildResult:172800
com.ibm.team.repository.changeEvent.expirationByCategory = SystemLog:259200

# Fulltext index location
com.ibm.team.fulltext.indexLocation=c:/Progra~1/IBM/JazzTeamServer/server/conf/jts/indices/workitemindex.

# Location of JFS index root directory
com.ibm.team.jfs.index.root.directory=c:/Progra~1/IBM/JazzTeamServer/server/conf/jts/indices
==========================

After that i also tried with following commands
db2 connect to <database>
db2 grant dbadm on database to user db2admin
db2 disconnect <database>

and all above was successful.

I am able to create the repotools-jts -createTables but not the warehouse

C:\Program Files\IBM\JazzTeamServer\server>repotools-jts -createWarehouse
Repo Tools
Provisioning using "C:\Program Files\IBM\JazzTeamServer\server\conf\jts\provisio
n_profiles".
Jazz Foundation - Core Libraries, Version 3.0.1 (RJF-I20110602-0017)

CRJAZ1363I Loading the configuration from "file:conf/jts/teamserver.properties".

CRJAZ1779I This server is configured as a JTS.
CRJAZ1781W The Public URI Root has not been set. Use the server setup wizard to
enter the public URI. This property is required to enforce consistent URL mana
gement in the application. The public URI represents the URL that all clients m
ust use to access the application.
CRJAZ1365I The server is attempting to connect to the following database: "//map
anda3:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ1364I The connection to the following database was successful:
Db Product Name: DB2/NT
Db Product Version: SQL09070
Db URL: jdbc:db2://mapanda3:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.57.82
CRJAZ8192I: Fulltext Index Location: C:\Program Files\IBM\JazzTeamServer\server\
conf\jts\indices\workitemindex\fulltext_index
CRJAZ1728E An unexpected error has been detected. See the log file "C:\Program F
iles\IBM\JazzTeamServer\server\repotools-jts_createWarehouse.log" for more detai
ls.




Where is the issue??????