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
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
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
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.
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
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.
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!