It's all about the answers!

Ask a question

Error creating Table Schemas


Scott Davis (1145) | asked Nov 13 '12, 9:10 a.m.
I could use a hint. I have been given a new V10 DB2 so wanted to install from scrath CLM 4.0. I created the JTS,CCm.... databases. I granted dbadm to my USERID to the DBs, sysadm and sysctl to the USERID ( Sames steps I did installing RTC 3.0 ). When I try and create the JTS tables ( random being first ) I can't create the schemas :

2012-11-12 09:58:51,759 CRJAZ1363I Loading the configuration from "file:/etc/rtcz400/jts/teamserver.properties".
2012-11-12 09:58:51,949 CRJAZ1779I This server is configured as a JTS.
2012-11-12 09:58:54,082 CRJAZ1365I The server is attempting to connect to the following database: "//wtsc47.itso.ibm.com:38400/DB0R:user=xxxxxxxx;password=xxxxxxxx;"
2012-11-12 09:58:55,048 CRJAZ1364I The connection to the following database was successful:
 Db Product Name: DB2
  Db Product Version: DSN10015
  Db URL: jdbc:db2://wtsc47.itso.ibm.com:38400/DB0R:user=xxxxxxxx;password=xxxxxxxx;
  Jdbc Driver Name: IBM DB2 JDBC Universal Driver Architecture
  Jdbc Driver Version: 3.63.131
2012-11-12 09:58:55,099 CRJAZ1093I The following service class was not activated: "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService"
com.ibm.team.repository.common.transport.TeamServiceRegistryException: CRJAZ1092I The service class "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService" failed during activation.

Then a bunch of java traces and then

Caused by: java.lang.RuntimeException: CRJAZ0820I Failed to create the system schema.
    at com.ibm.team.repository.service.internal.schemagen.PersistentMappingService.reset(PersistentMappingService.java:125)
    at com.ibm.team.repository.service.internal.schemagen.PersistentMappingService.activate(PersistentMappingService.java:91)
    at com.ibm.team.repository.service.AbstractService.bindRequiredServices(AbstractService.java:191)
    at com.ibm.team.repository.common.transport.internal.registry.AbstractActivationManagerOwner.bindRequiredServices(AbstractActivationManagerOwner.java:252)
    ... 100 more
Caused by: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-805, SQLSTATE=51002, SQLERRMC=DB0R.NULLID.SYSSTAT.5359534C564C3031;DISTSERV;04, DRIVER=3.63.131


No one else here in the forum seems to have had a schema problem, anybody have a clue or hint ?

One answer



permanent link
Scott Davis (1145) | answered Nov 15 '12, 8:51 a.m.
It turns out that the DB2 System on z had not run the jdbc Binder Utility when set up.

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.