RTC V3.0.1 with DB2 issue
![]()
I'm installing RTC 3.0.1 on AIX6 with DB2 9.7.0.4 and ran into the following during the DB2 configuration for JTS,
In my conf/jts/teamserver.properties I have: com.ibm.team.repository.db.vendor = DB2 com.ibm.team.repository.db.jdbc.location=//myhost.ibm.com:50000/JTS:user=db2inst1;password={password}; but when I run repotools-jts.sh I get the following error: # ./repotools-jts.sh -createTables -clean Repo Tools Provisioning using "./conf/jts/provision_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. CRJAZ1971I The server is configured with: Public URI: "https://myhost.ibm.com:9443/jts" CRJAZ1365I The server is attempting to connect to the following database: "//myhost.ibm.com:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;" CRJAZ0503I The server was unable to connect to the following database: "//myhost.ibm.com:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;" Exception: " Exception java.net.ConnectException: Error opening socket to server myhost.ibm.com/9.23.17.12 on port 50,000 with message: A remote host refused an attempted connect operation.. ERRORCODE=-4499, SQLSTATE=08001" CRJAZ1093I The following service class was not activated: "com.ibm.team.repository.service.internal.schemagen.PersistentMappingService" CRJAZ0503I The server was unable to connect to the following database: "//myhost.ibm.com:50000/JTS:user=xxxxxxxx;password=xxxxxxxx;" Exception: " Exception java.net.ConnectException: Error opening socket to server myhost.ibm.com/9.23.17.12 on port 50,000 with message: A remote host refused an attempted connect operation.. ERRORCODE=-4499, SQLSTATE=08001" CRJAZ1728E An unexpected error has been detected. See the log file "/opt/IBM/JazzTeamServer/server/repotools-jts_createTables.log" for more details. The databases I created following the previous step in the dos are: db2 create database JTS using codeset UTF-8 territory en PAGESIZE 16384 db2 create database CCM using codeset UTF-8 territory en PAGESIZE 16384 |
4 answers
![]()
Ralph Schoon (63.3k●3●36●46)
| answered Jun 19 '11, 4:59 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER I'm installing RTC 3.0.1 on AIX6 with DB2 9.7.0.4 and ran into the following during the DB2 configuration for JTS, Hi Rachel, this could be a common issue with DB2 9.7. The issue is described in the installation instructions. If you installed DB2 9.7 and you created the database as another user than the user db2admin, you must grant dbadm authority to that user using the following command sequence. If you are not sure about the installed DB2 version run the command db2 in the command window and check the version information in the first lines of the output. db2 connect to <databaseName> db2 grant dbadm on database to user db2admin db2 disconnect <databaseName> This needs to be done for all databases. Otherwise the tables can not be created. |
![]()
Ralph Schoon (63.3k●3●36●46)
| answered Jun 20 '11, 3:56 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER I'm installing RTC 3.0.1 on AIX6 with DB2 9.7.0.4 and ran into the following during the DB2 configuration for JTS, Hi Rachel, this could be a common issue with DB2 9.7. The issue is described in the installation instructions. If you installed DB2 9.7 and you created the database as another user than the user db2admin, you must grant dbadm authority to that user using the following command sequence. If you are not sure about the installed DB2 version run the command db2 in the command window and check the version information in the first lines of the output. db2 connect to <databaseName> db2 grant dbadm on database to user db2admin db2 disconnect <databaseName> This needs to be done for all databases. Otherwise the tables can not be created. Actually looking at it again this rather seems to be an issue with the database setup or service. Either the port 50000 is not correct or the database is not started. |
![]()
It turns out that port 50000 is not correct, DB2 9.7 use 60000 as the default port on my server. I changed the properties file and I can create the table now. Thanks for your great help! |
![]()
Ralph Schoon (63.3k●3●36●46)
| answered Jun 20 '11, 11:55 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Glad you got it working. |
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.