didnt know you had posted here before contacting me,


anyway looking at your logs we found two issues


Jazz Foundation - Jazz Team Server, Version 1.0.0.2 (I20091211-0451)
Rational Team Concert, Version 2.0.0.2 (I20091211-0451)

Rational Jazz Team Server for RAM - Enterprise
CRJAZ1363I Loading configuration from "file:/apps/AppServer/profiles/Saphire/config/cells/sapphire1Node01Cell/RTC/server1/v2002/jazz/server/conf/jazz/teamserver.db2.linux.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: //sapphire2.pssc.mop.fr.ibm.com:60000/RAMRTCDB:user=xxxxxxxx;password=xxxxxxxx;
CRJAZ1364I Initial database connection successful
Db Product Name: DB2/AIX64
Db Product Version: SQL09073
Db URL: jdbc:db2://sapphire2.pssc.mop.fr.ibm.com:60000/RAMRTCDB
Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
Jdbc Driver Version: 3.53.70
CRJAZ8192I: Fulltext Index Location: /apps/AppServer/profiles/Saphire/config/cells/sapphire1Node01Cell/RTC/server1/v2002/jazz/server/workitemindex/fulltext_index
CRJAZ8190E: The fulltext index location property (indexLocation) should point to an absolute directory but is currently set to 'workitemindex'
Creating the tables for the database "//sapphire2.pssc.mop.fr.ibm.com:60000/RAMRTCDB:user=xxxxxxxx;password=xxxxxxxx;" with indices.
CRJAZ0258I Error querying tablespace size.
The database tables were not created.


repotools creates another log file (repotools_createTables.log) where additional details are there

The file has this error



Caused by:
com.ibm.db2.jcc.b.SqlException: DB2 SQL Error: SQLCODE=-443, SQLSTATE=38553, SQLERRMC=SYSPROC.SNAPSHOT_TBS_CFG;SNAPSHOT_TBS_CFG;, DRIVER=3.53.70
at com.ibm.db2.jcc.b.bd.a(bd.java:679)
at com.ibm.db2.jcc.b.bd.a(bd.java:60)
at com.ibm.db2.jcc.b.bd.a(bd.java:127)
at com.ibm.db2.jcc.b.ul.b(ul.java:3712)
at com.ibm.db2.jcc.b.ul.a(ul.java:3694)
at com.ibm.db2.jcc.t4.db.a(db.java:730)
at com.ibm.db2.jcc.t4.db.m(db.java:719)
at com.ibm.db2.jcc.t4.db.i(db.java:244)
at com.ibm.db2.jcc.t4.db.c(db.java:52)
at com.ibm.db2.jcc.t4.t.c(t.java:44)
at com.ibm.db2.jcc.t4.sb.i(sb.java:153)
at com.ibm.db2.jcc.b.fm.db(fm.java:1974)
at com.ibm.db2.jcc.b.gm.e(gm.java:3311)
at com.ibm.db2.jcc.b.gm.Qb(gm.java:576)
at com.ibm.db2.jcc.b.gm.executeQuery(gm.java:550)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.executeQuery(PreparedStatementStatWrapper.java:57)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.executeQuery(PreparedStatementErrLogWrapper.java:75)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.executeQuery(PreparedStatementLeakWrapper.java:54)
at com.ibm.team.repository.jdbcdriver.intern



That error means that the user does not have privileges to query the routine SYSPROC.SNAPSHOT_TBS_CFG


1. can you find out from the DBA what privilege you need to access this routine.

2. Also this error is coming from RTC ,


According to this page on RTC


http://publib.boulder.ibm.com/infocenter/rtc/v2r0m0/topic/com.ibm.team.install.doc/topics/t_s_server_installation_setup_db2.html

"Confirm that the user specified in teamserver.properties has DBADM authority over the database.
Note: SYSADM authority is insufficient to run repotools -createTables. For more information, see t_create_db2_db_as_dbadm.html."


3. Another option is to post on the jazz.net forum for RTC http://jazz.net/forums/viewforum.php?f=1
They may be able to answer why this happened

I already see a post similar to this on their forum

http://jazz.net/forums/viewtopic.php?p=38147


However, it has no replies