It's all about the answers!

Ask a question

Error Creating tables on DB2 db


Emilio Iglesias Martinez (1666) | asked Mar 09 '12, 7:04 a.m.
I'm trying to setup a Jazz installation using a DB2 database.
DB team claims to have provided me a user with full dbadmin rights, but i get the error provided below when I try to create the tables, be it with the setup wizard or with the repotools command.
It seems to complain about SYSPROC.SNAPSHOT_TBS_CFG
Can someone provide me a hint of what piece of configuration might be missing?
I assume it is an access rights issue on the DB2 side, but not sure exactly what is needed.

2012-03-09 11:00:37,881 Repo Tools

2012-03-09 11:00:37,884 java.version=1.5.0
2012-03-09 11:00:37,884 java.runtime.version=pap64devifx-20110209a (SR11 FP2 +IZ94331)
2012-03-09 11:00:37,891 Bereitstellung mit "./conf/jts/provision_profiles".
2012-03-09 11:00:38,006 repotools-jts -createtables
2012-03-09 11:00:38,008 Jazz Foundation - Core Libraries, Version 3.0.1 (RJF-I20110602-0017)

2012-03-09 11:00:38,037 CRJAZ1363I Die Konfiguration aus "file:conf/jts/teamserver.properties" wird geladen.
2012-03-09 11:00:39,164 CRJAZ1779I Dieser Server ist als JTS konfiguriert.
2012-03-09 11:00:39,166 CRJAZ1971I Der Server ist mit folgendem Merkmal konfiguriert:
ffentlicher URI: "https://b0d0kn02.emea.zurich.corp:9444/jts"
2012-03-09 11:00:40,417 CRJAZ1365I Der Server versucht, eine Verbindung zur Datenbank "//udb-do.rz.ch.zurich.com:51260/CHZDALMJ:user=xxxxxxxx;password=xxxxxxxx;" herzustellen.
2012-03-09 11:00:40,860 CRJAZ1364I Erfolgreiche Verbindung zur folgenden Datenbank:
Name des DB-Produkts: DB2/AIX64
Version des DB-Produkts: SQL09075
DB-URL: jdbc:db2://udb-do.rz.ch.zurich.com:51260/CHZDALMJ:user=xxxxxxxx;password=xxxxxxxx;
Name des JDBC-Treibers: IBM DB2 JDBC Universal Driver Architecture
Version des JDBC-Treibers: 3.57.82
2012-03-09 11:00:41,794 CRJAZ8192I: Position des Volltextindex: /opt/IBM/JazzTeamServer/server/conf/jts/indices/workitemindex/fulltext_index
2012-03-09 11:00:42,320 Die Tabellen fr die Datenbank "//udb-do.rz.ch.zurich.com:51260/CHZDALMJ:user=xxxxxxxx;password=xxxxxxxx;" werden mit Indizes erstellt.
2012-03-09 11:00:42,613 CRJAZ1245I Der Datenbankbenutzer besitzt nicht die erforderliche Berechtigung, um die angegebene Operation auszufhren. Stellen Sie anhand der Produktdokumentation des Datenbankanbieters oder zusammen mit Ihrem Datenbankadministrator sicher, dass der Benutzeraccount die geeignete Berechtigung fr das Lesen, Schreiben und Verwalten von Tabellen besitzt.
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-1092, SQLSTATE= , SQLERRMC=DALMJ, DRIVER=3.57.82
at com.ibm.db2.jcc.am.bd.a(bd.java:679)
at com.ibm.db2.jcc.am.bd.a(bd.java:60)
at com.ibm.db2.jcc.am.bd.a(bd.java:127)
at com.ibm.db2.jcc.am.km.b(km.java:2164)
at com.ibm.db2.jcc.am.km.c(km.java:2147)
at com.ibm.db2.jcc.t4.db.k(db.java:354)
at com.ibm.db2.jcc.t4.db.e(db.java:96)
at com.ibm.db2.jcc.t4.t.e(t.java:81)
at com.ibm.db2.jcc.t4.sb.j(sb.java:160)
at com.ibm.db2.jcc.am.km.hb(km.java:2113)
at com.ibm.db2.jcc.am.lm.b(lm.java:3589)
at com.ibm.db2.jcc.am.lm.Yb(lm.java:2130)
at com.ibm.db2.jcc.am.lm.execute(lm.java:2114)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.execute(PreparedStatementStatWrapper.java:51)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.execute(PreparedStatementErrLogWrapper.java:65)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.execute(PreparedStatementLeakWrapper.java:50)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.updateDatabaseConfig(Db2Provider.java:193)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.configureDb(Db2Provider.java:295)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDbForInitialization(Db2Provider.java:288)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy56.prepareDbForInitialization(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAllSchemas(AbstractDatabaseService.java:189)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.internalRebuildAllSchemas(DatabaseCreationService.java:114)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.access$0(DatabaseCreationService.java:112)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService$3.run(DatabaseCreationService.java:102)
at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.runWithResult(ConnectionRunnable.java:40)
at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.run(ConnectionRunnable.java:34)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:458)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:285)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:379)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy58.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:281)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:259)
at com.ibm.team.repository.service.internal.TransactionService.runExclusive(TransactionService.java:139)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy92.runExclusive(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.doRebuildSchemas(DatabaseCreationService.java:98)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.rebuildAllSchemas(DatabaseCreationService.java:89)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy114.rebuildAllSchemas(Unknown Source)
at com.ibm.team.repotools.commands.local.internal.CreateTablesCommand.createTables(CreateTablesCommand.java:89)
at com.ibm.team.repotools.commands.local.internal.CreateTablesCommand.execute(CreateTablesCommand.java:194)
at com.ibm.team.repotools.command.AbstractCommand.execute(AbstractCommand.java:64)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:736)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:811)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
at org.eclipse.equinox.launcher.Main.main(Main.java:1287)
2012-03-09 11:00:42,656 CRJAZ0258I Beim Abfragen der Tabellenbereichsgre trat ein Fehler auf.
com.ibm.team.repository.common.TeamRepositoryException: CRJAZ0258I Beim Abfragen der Tabellenbereichsgre trat ein Fehler auf.
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.shouldCreateNewTablespace(Db2Provider.java:467)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.shouldCreateNewDataTablespace(Db2Provider.java:448)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.createTablespaces(Db2Provider.java:337)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDbForInitialization(Db2Provider.java:291)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy56.prepareDbForInitialization(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAllSchemas(AbstractDatabaseService.java:189)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.internalRebuildAllSchemas(DatabaseCreationService.java:114)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.access$0(DatabaseCreationService.java:112)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService$3.run(DatabaseCreationService.java:102)
at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.runWithResult(ConnectionRunnable.java:40)
at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.run(ConnectionRunnable.java:34)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:458)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:285)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:379)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy58.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:281)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:259)
at com.ibm.team.repository.service.internal.TransactionService.runExclusive(TransactionService.java:139)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy92.runExclusive(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.doRebuildSchemas(DatabaseCreationService.java:98)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.rebuildAllSchemas(DatabaseCreationService.java:89)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy114.rebuildAllSchemas(Unknown Source)
at com.ibm.team.repotools.commands.local.internal.CreateTablesCommand.createTables(CreateTablesCommand.java:89)
at com.ibm.team.repotools.commands.local.internal.CreateTablesCommand.execute(CreateTablesCommand.java:194)
at com.ibm.team.repotools.command.AbstractCommand.execute(AbstractCommand.java:64)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:736)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:811)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
at org.eclipse.equinox.launcher.Main.main(Main.java:1287)
Caused by:
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-443, SQLSTATE=38553, SQLERRMC=SYSPROC.SNAPSHOT_TBS_CFG;SNAPSHOT_TBS_CFG;, DRIVER=3.57.82
at com.ibm.db2.jcc.am.bd.a(bd.java:679)
at com.ibm.db2.jcc.am.bd.a(bd.java:60)
at com.ibm.db2.jcc.am.bd.a(bd.java:127)
at com.ibm.db2.jcc.am.zl.b(zl.java:3760)
at com.ibm.db2.jcc.am.zl.a(zl.java:3742)
at com.ibm.db2.jcc.t4.db.a(db.java:792)
at com.ibm.db2.jcc.t4.db.m(db.java:762)
at com.ibm.db2.jcc.t4.db.i(db.java:245)
at com.ibm.db2.jcc.t4.db.c(db.java:53)
at com.ibm.db2.jcc.t4.t.c(t.java:44)
at com.ibm.db2.jcc.t4.sb.i(sb.java:147)
at com.ibm.db2.jcc.am.km.gb(km.java:1985)
at com.ibm.db2.jcc.am.lm.b(lm.java:3576)
at com.ibm.db2.jcc.am.lm.Vb(lm.java:654)
at com.ibm.db2.jcc.am.lm.executeQuery(lm.java:628)
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.internal.db2.Db2Provider.getTablespaceSize(Db2Provider.java:588)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.shouldCreateNewTablespace(Db2Provider.java:454)
... 67 more
2012-03-09 11:00:42,661 Die Datenbanktabellen wurde nicht erstellt.


The properties file we are using:

#Diese Konfigurationsaktualisierung wurde von "ADMIN" angefragt. Der alte Inhalt der Datei wurde nach "/opt/IBM/JazzTeamServer/server/conf/jts/teamserver-1330685399323bakup.properties" kopiert.
#Fri Mar 02 11:49:59 GMT+01:00 2012
com.ibm.team.repository.ws.allow.identity.assertion=false
com.ibm.team.repository.changeEvent.expirationDefault=1209600
com.ibm.team.fulltext.indexLocation=/opt/IBM/JazzTeamServer/server/conf/jts/indices/workitemindex
com.ibm.team.repository.web.suppressedPages={"com.ibm.team.repository.web.admin"\: ["com.ibm.team.repository.provision"]}
com.ibm.team.repository.web.helpuri=/clmhelp/index.jsp
com.ibm.team.jfs.index.root.directory=indices
com.ibm.team.repository.web.pageorder={"com.ibm.team.repository.web.admin"\: ["com.ibm.team.repository.server", "com.ibm.team.process.admin"], "com.ibm.team.process.web.projectArea"\: ["com.ibm.team.dashboard", "com.ibm.team.workitem", "com.ibm.team.apt", "com.ibm.team.scm", "com.ibm.team.reports"],"com.ibm.team.process.web.projectAreaList"\: ["com.ibm.team.repository.web.projectAreaList"]}
com.ibm.team.repository.changeEvent.expirationByCategory=SystemLog\:259200
com.ibm.team.repository.server.webapp.url=https\://xxx.xx.xx\:9444/jts


com.ibm.team.datawarehouse.db.automatic.setup=false
#com.ibm.team.datawarehouse.db.vendor=DERBY
#com.ibm.team.datawarehouse.db.jdbc.location=conf/jts/derby/warehouseDB
#com.ibm.team.datawarehouse.db.net.port=1527

#com.ibm.team.repository.db.repoLockId=_O2jXsGRVEeGcAJxmc-GJiA
#com.ibm.team.repository.db.vendor=DERBY
#com.ibm.team.repository.db.jdbc.location=conf/jts/derby/repositoryDB


# 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=//xxxxx:51260/CHZDALMJ:user=dalmj;password={password};
com.ibm.team.repository.db.jdbc.password=xxxxx

# 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=DATA_16_TS1

# 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
#com.ibm.team.repository.db.db2.temp.tablespace.name=TEMPSPACE1

One answer



permanent link
Kim Soederhamn (1.5k24348) | answered Mar 27 '12, 9:14 a.m.
I'm trying to setup a Jazz installation using a DB2 database.
DB team claims to have provided me a user with full dbadmin rights, but i get the error provided below when I try to create the tables, be it with the setup wizard or with the repotools command.
It seems to complain about SYSPROC.SNAPSHOT_TBS_CFG
Can someone provide me a hint of what piece of configuration might be missing?
I assume it is an access rights issue on the DB2 side, but not sure exactly what is needed.

2012-03-09 11:00:37,881 Repo Tools

2012-03-09 11:00:37,884 java.version=1.5.0
2012-03-09 11:00:37,884 java.runtime.version=pap64devifx-20110209a (SR11 FP2 +IZ94331)
2012-03-09 11:00:37,891 Bereitstellung mit "./conf/jts/provision_profiles".
2012-03-09 11:00:38,006 repotools-jts -createtables
2012-03-09 11:00:38,008 Jazz Foundation - Core Libraries, Version 3.0.1 (RJF-I20110602-0017)

2012-03-09 11:00:38,037 CRJAZ1363I Die Konfiguration aus "file:conf/jts/teamserver.properties" wird geladen.
2012-03-09 11:00:39,164 CRJAZ1779I Dieser Server ist als JTS konfiguriert.
2012-03-09 11:00:39,166 CRJAZ1971I Der Server ist mit folgendem Merkmal konfiguriert:
ffentlicher URI: "https://b0d0kn02.emea.zurich.corp:9444/jts"
2012-03-09 11:00:40,417 CRJAZ1365I Der Server versucht, eine Verbindung zur Datenbank "//udb-do.rz.ch.zurich.com:51260/CHZDALMJ:user=xxxxxxxx;password=xxxxxxxx;" herzustellen.
2012-03-09 11:00:40,860 CRJAZ1364I Erfolgreiche Verbindung zur folgenden Datenbank:
Name des DB-Produkts: DB2/AIX64
Version des DB-Produkts: SQL09075
DB-URL: jdbc:db2://udb-do.rz.ch.zurich.com:51260/CHZDALMJ:user=xxxxxxxx;password=xxxxxxxx;
Name des JDBC-Treibers: IBM DB2 JDBC Universal Driver Architecture
Version des JDBC-Treibers: 3.57.82
2012-03-09 11:00:41,794 CRJAZ8192I: Position des Volltextindex: /opt/IBM/JazzTeamServer/server/conf/jts/indices/workitemindex/fulltext_index
2012-03-09 11:00:42,320 Die Tabellen fr die Datenbank "//udb-do.rz.ch.zurich.com:51260/CHZDALMJ:user=xxxxxxxx;password=xxxxxxxx;" werden mit Indizes erstellt.
2012-03-09 11:00:42,613 CRJAZ1245I Der Datenbankbenutzer besitzt nicht die erforderliche Berechtigung, um die angegebene Operation auszufhren. Stellen Sie anhand der Produktdokumentation des Datenbankanbieters oder zusammen mit Ihrem Datenbankadministrator sicher, dass der Benutzeraccount die geeignete Berechtigung fr das Lesen, Schreiben und Verwalten von Tabellen besitzt.
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-1092, SQLSTATE= , SQLERRMC=DALMJ, DRIVER=3.57.82
at com.ibm.db2.jcc.am.bd.a(bd.java:679)
at com.ibm.db2.jcc.am.bd.a(bd.java:60)
at com.ibm.db2.jcc.am.bd.a(bd.java:127)
at com.ibm.db2.jcc.am.km.b(km.java:2164)
at com.ibm.db2.jcc.am.km.c(km.java:2147)
at com.ibm.db2.jcc.t4.db.k(db.java:354)
at com.ibm.db2.jcc.t4.db.e(db.java:96)
at com.ibm.db2.jcc.t4.t.e(t.java:81)
at com.ibm.db2.jcc.t4.sb.j(sb.java:160)
at com.ibm.db2.jcc.am.km.hb(km.java:2113)
at com.ibm.db2.jcc.am.lm.b(lm.java:3589)
at com.ibm.db2.jcc.am.lm.Yb(lm.java:2130)
at com.ibm.db2.jcc.am.lm.execute(lm.java:2114)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.stat.PreparedStatementStatWrapper.execute(PreparedStatementStatWrapper.java:51)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.errlog.PreparedStatementErrLogWrapper.execute(PreparedStatementErrLogWrapper.java:65)
at com.ibm.team.repository.service.internal.db.jdbcwrappers.leak.PreparedStatementLeakWrapper.execute(PreparedStatementLeakWrapper.java:50)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.updateDatabaseConfig(Db2Provider.java:193)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.configureDb(Db2Provider.java:295)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDbForInitialization(Db2Provider.java:288)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy56.prepareDbForInitialization(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAllSchemas(AbstractDatabaseService.java:189)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.internalRebuildAllSchemas(DatabaseCreationService.java:114)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.access$0(DatabaseCreationService.java:112)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService$3.run(DatabaseCreationService.java:102)
at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.runWithResult(ConnectionRunnable.java:40)
at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.run(ConnectionRunnable.java:34)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:458)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:285)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:379)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy58.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:281)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:259)
at com.ibm.team.repository.service.internal.TransactionService.runExclusive(TransactionService.java:139)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy92.runExclusive(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.doRebuildSchemas(DatabaseCreationService.java:98)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.rebuildAllSchemas(DatabaseCreationService.java:89)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy114.rebuildAllSchemas(Unknown Source)
at com.ibm.team.repotools.commands.local.internal.CreateTablesCommand.createTables(CreateTablesCommand.java:89)
at com.ibm.team.repotools.commands.local.internal.CreateTablesCommand.execute(CreateTablesCommand.java:194)
at com.ibm.team.repotools.command.AbstractCommand.execute(AbstractCommand.java:64)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:736)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:811)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
at org.eclipse.equinox.launcher.Main.main(Main.java:1287)
2012-03-09 11:00:42,656 CRJAZ0258I Beim Abfragen der Tabellenbereichsgre trat ein Fehler auf.
com.ibm.team.repository.common.TeamRepositoryException: CRJAZ0258I Beim Abfragen der Tabellenbereichsgre trat ein Fehler auf.
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.shouldCreateNewTablespace(Db2Provider.java:467)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.shouldCreateNewDataTablespace(Db2Provider.java:448)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.createTablespaces(Db2Provider.java:337)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.prepareDbForInitialization(Db2Provider.java:291)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy56.prepareDbForInitialization(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.AbstractDatabaseService.internalCreateAllSchemas(AbstractDatabaseService.java:189)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.internalRebuildAllSchemas(DatabaseCreationService.java:114)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.access$0(DatabaseCreationService.java:112)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService$3.run(DatabaseCreationService.java:102)
at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.runWithResult(ConnectionRunnable.java:40)
at com.ibm.team.repository.service.internal.rdb.ConnectionRunnable.run(ConnectionRunnable.java:34)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$Transaction.run(RepositoryDatabase.java:458)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase$1.run(RepositoryDatabase.java:285)
at com.ibm.team.repository.service.internal.rdb.ConnectionPoolService.withCurrentConnection(ConnectionPoolService.java:379)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy58.withCurrentConnection(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runTransaction(RepositoryDatabase.java:281)
at com.ibm.team.repository.service.internal.rdb.RepositoryDatabase.runExclusive(RepositoryDatabase.java:259)
at com.ibm.team.repository.service.internal.TransactionService.runExclusive(TransactionService.java:139)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy92.runExclusive(Unknown Source)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.doRebuildSchemas(DatabaseCreationService.java:98)
at com.ibm.team.repository.service.internal.rdb.DatabaseCreationService.rebuildAllSchemas(DatabaseCreationService.java:89)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy114.rebuildAllSchemas(Unknown Source)
at com.ibm.team.repotools.commands.local.internal.CreateTablesCommand.createTables(CreateTablesCommand.java:89)
at com.ibm.team.repotools.commands.local.internal.CreateTablesCommand.execute(CreateTablesCommand.java:194)
at com.ibm.team.repotools.command.AbstractCommand.execute(AbstractCommand.java:64)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.run(RepositoryToolsApplication.java:736)
at com.ibm.team.repotools.rcp.internal.RepositoryToolsApplication.start(RepositoryToolsApplication.java:811)
at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:194)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)
at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:368)
at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:179)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:559)
at org.eclipse.equinox.launcher.Main.basicRun(Main.java:514)
at org.eclipse.equinox.launcher.Main.run(Main.java:1311)
at org.eclipse.equinox.launcher.Main.main(Main.java:1287)
Caused by:
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-443, SQLSTATE=38553, SQLERRMC=SYSPROC.SNAPSHOT_TBS_CFG;SNAPSHOT_TBS_CFG;, DRIVER=3.57.82
at com.ibm.db2.jcc.am.bd.a(bd.java:679)
at com.ibm.db2.jcc.am.bd.a(bd.java:60)
at com.ibm.db2.jcc.am.bd.a(bd.java:127)
at com.ibm.db2.jcc.am.zl.b(zl.java:3760)
at com.ibm.db2.jcc.am.zl.a(zl.java:3742)
at com.ibm.db2.jcc.t4.db.a(db.java:792)
at com.ibm.db2.jcc.t4.db.m(db.java:762)
at com.ibm.db2.jcc.t4.db.i(db.java:245)
at com.ibm.db2.jcc.t4.db.c(db.java:53)
at com.ibm.db2.jcc.t4.t.c(t.java:44)
at com.ibm.db2.jcc.t4.sb.i(sb.java:147)
at com.ibm.db2.jcc.am.km.gb(km.java:1985)
at com.ibm.db2.jcc.am.lm.b(lm.java:3576)
at com.ibm.db2.jcc.am.lm.Vb(lm.java:654)
at com.ibm.db2.jcc.am.lm.executeQuery(lm.java:628)
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.internal.db2.Db2Provider.getTablespaceSize(Db2Provider.java:588)
at com.ibm.team.repository.jdbcdriver.internal.db2.Db2Provider.shouldCreateNewTablespace(Db2Provider.java:454)
... 67 more
2012-03-09 11:00:42,661 Die Datenbanktabellen wurde nicht erstellt.


The properties file we are using:

#Diese Konfigurationsaktualisierung wurde von "ADMIN" angefragt. Der alte Inhalt der Datei wurde nach "/opt/IBM/JazzTeamServer/server/conf/jts/teamserver-1330685399323bakup.properties" kopiert.
#Fri Mar 02 11:49:59 GMT+01:00 2012
com.ibm.team.repository.ws.allow.identity.assertion=false
com.ibm.team.repository.changeEvent.expirationDefault=1209600
com.ibm.team.fulltext.indexLocation=/opt/IBM/JazzTeamServer/server/conf/jts/indices/workitemindex
com.ibm.team.repository.web.suppressedPages={"com.ibm.team.repository.web.admin"\: ["com.ibm.team.repository.provision"]}
com.ibm.team.repository.web.helpuri=/clmhelp/index.jsp
com.ibm.team.jfs.index.root.directory=indices
com.ibm.team.repository.web.pageorder={"com.ibm.team.repository.web.admin"\: ["com.ibm.team.repository.server", "com.ibm.team.process.admin"], "com.ibm.team.process.web.projectArea"\: ["com.ibm.team.dashboard", "com.ibm.team.workitem", "com.ibm.team.apt", "com.ibm.team.scm", "com.ibm.team.reports"],"com.ibm.team.process.web.projectAreaList"\: ["com.ibm.team.repository.web.projectAreaList"]}
com.ibm.team.repository.changeEvent.expirationByCategory=SystemLog\:259200
com.ibm.team.repository.server.webapp.url=https\://*.xx.xx\:9444/jts


com.ibm.team.datawarehouse.db.automatic.setup=false
#com.ibm.team.datawarehouse.db.vendor=DERBY
#com.ibm.team.datawarehouse.db.jdbc.location=conf/jts/derby/warehouseDB
#com.ibm.team.datawarehouse.db.net.port=1527

#com.ibm.team.repository.db.repoLockId=_O2jXsGRVEeGcAJxmc-GJiA
#com.ibm.team.repository.db.vendor=DERBY
#com.ibm.team.repository.db.jdbc.location=conf/jts/derby/repositoryDB


# 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=//xxxxx:51260/CHZDALMJ:user=dalmj;password={password};
com.ibm.team.repository.db.jdbc.password=xxxxx

# 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=DATA_16_TS1

# 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
#com.ibm.team.repository.db.db2.temp.tablespace.name=TEMPSPACE1



Hi,

Though its in german I concur with you it looks like an access problem.

It also looks a bit odd that you do not have the extra slahes (escape chars) in your settings - I suspect you wrote them into your teamserver.properties manually not using the jts/setup. They should look like:

//udb-do.rz.ch.zurich.com\:51260;databaseName\=CHZDALMJ;user\=dalmj;password\={password}

If that don't work then try installing a DB2 connect client on you machine to validate your access to the specified database:port. this will also install drivers on your machine so you shouldnt have a problem with missing or wrong drivers.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.