It's all about the answers!

Ask a question

problems connecting RTC 2.0 beta to DB2


Jeff Taylor (7673) | asked Mar 23 '09, 11:16 a.m.
I am having some problems trying setup a DB2 database for RTC on RHEL 5.

I already saw the postings about removing fullyMaterializedLobData from the teamserver.properties file, and got past that point. Currently, I beleive that I am stuck with some other permissions issue.

Note: The documentation say to use "db2fenc1" to create the database with the "db2 create..." command. For some reason, I received an error about permissions. I was able to use "db2inst1" to run the "db2 create" command. I don't know if this would be related or not.

[root@wcary2nu server]# ./repotools.sh -createTables

Repo Tools, Version 2.0 M2 - I20090316-0438
Provisioning using "./provision_profiles".
Rational Jazz Team Server - Standard
Loading configuration from "file:teamserver.properties".
Attempting Initial Database Connection Using
Db Name/Location: //localhost:50001/JAZZ:user=xxxxxxxx;password=xxxxxxxx;
CRJAZ0503I Failed to connect to the database: "[ibm][db2][jcc][t4][2043][11550]
Exception java.net.ConnectException: Error opening socket to server localhost/12
7.0.0.1 on port 50,001 with message: Connection refused."
Db Name/Location: "//localhost:50001/JAZZ:user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ1093I Service failed to activate.
CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.r
db.IDatabaseStateService".
CRJAZ1203I Could not determine the database location.
CRJAZ1306I The service "com.ibm.team.repository.service.internal.rdb.IDatabaseSt
ateService" is not available.
Creating the tables for the database "//localhost:50001/JAZZ:user=xxxxxxxx;passw
ord=xxxxxxxx;" with indices.
CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.r
db.IDatabaseCreationService".
CRJAZ1309I The database connectivity service is not ready.
The database tables were not created.
[root@wcary2nu server]#


Here are the relevant lines from the teamserver.properties file:

com.ibm.team.repository.db.vendor = DB2

com.ibm.team.repository.db.jdbc.location=//localhost:50001/JAZZ:user=db2inst1;pa
ssword={password};
com.ibm.team.repository.db.jdbc.password=db2admin

# DB2 requires a path where the content tablespace should be created, examples f
or Win and Linux follow
com.ibm.team.repository.db.db2.content.tablespace.location=content_tablespace


More back ground information:

I create the following userids/groups for the installation

db2isnt1 (db2iadm1)

db2fenc1 (db2fadm1)
dasusr1 (dasadm1)


This is the response file from the DB2 installation:

[root@wcary2nu ~]# more db2exp.rsp

*-----------------------------------------------------
* Generated response file used by the DB2 Setup wizard
* generation time: 3/20/09 2:12 PM
*-----------------------------------------------------
* Product Installation
LIC_AGREEMENT = ACCEPT
PROD = UDB_EXPRESS_EDITION
FILE = /opt/ibm/db2/V9.5
INSTALL_TYPE = TYPICAL
*-----------------------------------------------
* Das properties
*-----------------------------------------------
DAS_CONTACT_LIST = LOCAL
* DAS user
DAS_USERNAME = dasusr1
DAS_UID = 5002
DAS_GROUP_NAME = dasadm1
DAS_HOME_DIRECTORY = /localdisk/home/dasusr1
* ----------------------------------------------
* Instance properties
* ----------------------------------------------
INSTANCE = inst1
inst1.TYPE = wse
* Instance-owning user
inst1.NAME = db2inst1
inst1.UID = 5004
inst1.GROUP_NAME = db2iadm1
inst1.HOME_DIRECTORY = /localdisk/home/db2inst1
inst1.AUTOSTART = YES
inst1.SVCENAME = db2c_db2inst1
inst1.PORT_NUMBER = 50001
inst1.CONFIGURE_TEXT_SEARCH = YES
inst1.TEXT_SEARCH_HTTP_SERVICE_NAME = db2j_db2inst1
inst1.TEXT_SEARCH_HTTP_PORT_NUMBER = 55001
* Fenced user
inst1.FENCED_USERNAME = db2fenc1
inst1.FENCED_UID = 5003
inst1.FENCED_GROUP_NAME = db2fadm1
inst1.FENCED_HOME_DIRECTORY = /localdisk/home/db2fenc1
* Contact properties
CONTACT = contact1
contact1.CONTACT_NAME = db2inst1
contact1.EMAIL = db2inst1@wcary2nu.ca.nortel.com
contact1.PAGER = false
contact1.NEW_CONTACT = YES
contact1.INSTANCE = inst1
*-----------------------------------------------
* Installed Languages
*-----------------------------------------------
LANG = EN
*-----------------------------------------------
* SA MP Base Component
*-----------------------------------------------
INSTALL_TSAMP = NO
[root@wcary2nu ~]#

                            

7 answers



permanent link
Susan Wu (4712116) | answered Mar 23 '09, 12:43 p.m.
I am having some problems trying setup a DB2 database for RTC on RHEL 5.

I already saw the postings about removing fullyMaterializedLobData from the teamserver.properties file, and got past that point. Currently, I beleive that I am stuck with some other permissions issue.

Note: The documentation say to use "db2fenc1" to create the database with the "db2 create..." command. For some reason, I received an error about permissions. I was able to use "db2inst1" to run the "db2 create" command. I don't know if this would be related or not.

[root@wcary2nu server]# ./repotools.sh -createTables

Repo Tools, Version 2.0 M2 - I20090316-0438
Provisioning using "./provision_profiles".
Rational Jazz Team Server - Standard
Loading configuration from "file:teamserver.properties".
Attempting Initial Database Connection Using
Db Name/Location: //localhost:50001/JAZZ:user=xxxxxxxx;password=xxxxxxxx;
CRJAZ0503I Failed to connect to the database: "[ibm][db2][jcc][t4][2043][11550]
Exception java.net.ConnectException: Error opening socket to server localhost/12
7.0.0.1 on port 50,001 with message: Connection refused."
Db Name/Location: "//localhost:50001/JAZZ:user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ1093I Service failed to activate.
CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.r
db.IDatabaseStateService".
CRJAZ1203I Could not determine the database location.
CRJAZ1306I The service "com.ibm.team.repository.service.internal.rdb.IDatabaseSt
ateService" is not available.
Creating the tables for the database "//localhost:50001/JAZZ:user=xxxxxxxx;passw
ord=xxxxxxxx;" with indices.
CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.r
db.IDatabaseCreationService".
CRJAZ1309I The database connectivity service is not ready.
The database tables were not created.
[root@wcary2nu server]#


Here are the relevant lines from the teamserver.properties file:

com.ibm.team.repository.db.vendor = DB2

com.ibm.team.repository.db.jdbc.location=//localhost:50001/JAZZ:user=db2inst1;pa
ssword={password};
com.ibm.team.repository.db.jdbc.password=db2admin

# DB2 requires a path where the content tablespace should be created, examples f
or Win and Linux follow
com.ibm.team.repository.db.db2.content.tablespace.location=content_tablespace


More back ground information:

I create the following userids/groups for the installation

db2isnt1 (db2iadm1)

db2fenc1 (db2fadm1)
dasusr1 (dasadm1)


This is the response file from the DB2 installation:

[root@wcary2nu ~]# more db2exp.rsp

*-----------------------------------------------------
* Generated response file used by the DB2 Setup wizard
* generation time: 3/20/09 2:12 PM
*-----------------------------------------------------
* Product Installation
LIC_AGREEMENT = ACCEPT
PROD = UDB_EXPRESS_EDITION
FILE = /opt/ibm/db2/V9.5
INSTALL_TYPE = TYPICAL
*-----------------------------------------------
* Das properties
*-----------------------------------------------
DAS_CONTACT_LIST = LOCAL
* DAS user
DAS_USERNAME = dasusr1
DAS_UID = 5002
DAS_GROUP_NAME = dasadm1
DAS_HOME_DIRECTORY = /localdisk/home/dasusr1
* ----------------------------------------------
* Instance properties
* ----------------------------------------------
INSTANCE = inst1
inst1.TYPE = wse
* Instance-owning user
inst1.NAME = db2inst1
inst1.UID = 5004
inst1.GROUP_NAME = db2iadm1
inst1.HOME_DIRECTORY = /localdisk/home/db2inst1
inst1.AUTOSTART = YES
inst1.SVCENAME = db2c_db2inst1
inst1.PORT_NUMBER = 50001
inst1.CONFIGURE_TEXT_SEARCH = YES
inst1.TEXT_SEARCH_HTTP_SERVICE_NAME = db2j_db2inst1
inst1.TEXT_SEARCH_HTTP_PORT_NUMBER = 55001
* Fenced user
inst1.FENCED_USERNAME = db2fenc1
inst1.FENCED_UID = 5003
inst1.FENCED_GROUP_NAME = db2fadm1
inst1.FENCED_HOME_DIRECTORY = /localdisk/home/db2fenc1
* Contact properties
CONTACT = contact1
contact1.CONTACT_NAME = db2inst1
contact1.EMAIL = db2inst1@wcary2nu.ca.nortel.com
contact1.PAGER = false
contact1.NEW_CONTACT = YES
contact1.INSTANCE = inst1
*-----------------------------------------------
* Installed Languages
*-----------------------------------------------
LANG = EN
*-----------------------------------------------
* SA MP Base Component
*-----------------------------------------------
INSTALL_TSAMP = NO
[root@wcary2nu ~]#



Hello,

According to my understanding, you are able to create the Jazz database within DB2 by using the "db2inst1" ID and its corresponding password is "db2iadm1"? But in your teamserver.properties file, you have the following set, which does not match with the id's password.

com.ibm.team.repository.db.jdbc.password=db2admin

I would try change it to the following, then try the repotools createtable command to see if it will work:

com.ibm.team.repository.db.jdbc.password=db2iadm1

Hope this helps,

Susan

permanent link
Susan Wu (4712116) | answered Mar 23 '09, 12:44 p.m.
I am having some problems trying setup a DB2 database for RTC on RHEL 5.

I already saw the postings about removing fullyMaterializedLobData from the teamserver.properties file, and got past that point. Currently, I beleive that I am stuck with some other permissions issue.

Note: The documentation say to use "db2fenc1" to create the database with the "db2 create..." command. For some reason, I received an error about permissions. I was able to use "db2inst1" to run the "db2 create" command. I don't know if this would be related or not.

[root@wcary2nu server]# ./repotools.sh -createTables

Repo Tools, Version 2.0 M2 - I20090316-0438
Provisioning using "./provision_profiles".
Rational Jazz Team Server - Standard
Loading configuration from "file:teamserver.properties".
Attempting Initial Database Connection Using
Db Name/Location: //localhost:50001/JAZZ:user=xxxxxxxx;password=xxxxxxxx;
CRJAZ0503I Failed to connect to the database: "[ibm][db2][jcc][t4][2043][11550]
Exception java.net.ConnectException: Error opening socket to server localhost/12
7.0.0.1 on port 50,001 with message: Connection refused."
Db Name/Location: "//localhost:50001/JAZZ:user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ1093I Service failed to activate.
CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.r
db.IDatabaseStateService".
CRJAZ1203I Could not determine the database location.
CRJAZ1306I The service "com.ibm.team.repository.service.internal.rdb.IDatabaseSt
ateService" is not available.
Creating the tables for the database "//localhost:50001/JAZZ:user=xxxxxxxx;passw
ord=xxxxxxxx;" with indices.
CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.r
db.IDatabaseCreationService".
CRJAZ1309I The database connectivity service is not ready.
The database tables were not created.
[root@wcary2nu server]#


Here are the relevant lines from the teamserver.properties file:

com.ibm.team.repository.db.vendor = DB2

com.ibm.team.repository.db.jdbc.location=//localhost:50001/JAZZ:user=db2inst1;pa
ssword={password};
com.ibm.team.repository.db.jdbc.password=db2admin

# DB2 requires a path where the content tablespace should be created, examples f
or Win and Linux follow
com.ibm.team.repository.db.db2.content.tablespace.location=content_tablespace


More back ground information:

I create the following userids/groups for the installation

db2isnt1 (db2iadm1)

db2fenc1 (db2fadm1)
dasusr1 (dasadm1)


This is the response file from the DB2 installation:

[root@wcary2nu ~]# more db2exp.rsp

*-----------------------------------------------------
* Generated response file used by the DB2 Setup wizard
* generation time: 3/20/09 2:12 PM
*-----------------------------------------------------
* Product Installation
LIC_AGREEMENT = ACCEPT
PROD = UDB_EXPRESS_EDITION
FILE = /opt/ibm/db2/V9.5
INSTALL_TYPE = TYPICAL
*-----------------------------------------------
* Das properties
*-----------------------------------------------
DAS_CONTACT_LIST = LOCAL
* DAS user
DAS_USERNAME = dasusr1
DAS_UID = 5002
DAS_GROUP_NAME = dasadm1
DAS_HOME_DIRECTORY = /localdisk/home/dasusr1
* ----------------------------------------------
* Instance properties
* ----------------------------------------------
INSTANCE = inst1
inst1.TYPE = wse
* Instance-owning user
inst1.NAME = db2inst1
inst1.UID = 5004
inst1.GROUP_NAME = db2iadm1
inst1.HOME_DIRECTORY = /localdisk/home/db2inst1
inst1.AUTOSTART = YES
inst1.SVCENAME = db2c_db2inst1
inst1.PORT_NUMBER = 50001
inst1.CONFIGURE_TEXT_SEARCH = YES
inst1.TEXT_SEARCH_HTTP_SERVICE_NAME = db2j_db2inst1
inst1.TEXT_SEARCH_HTTP_PORT_NUMBER = 55001
* Fenced user
inst1.FENCED_USERNAME = db2fenc1
inst1.FENCED_UID = 5003
inst1.FENCED_GROUP_NAME = db2fadm1
inst1.FENCED_HOME_DIRECTORY = /localdisk/home/db2fenc1
* Contact properties
CONTACT = contact1
contact1.CONTACT_NAME = db2inst1
contact1.EMAIL = db2inst1@wcary2nu.ca.nortel.com
contact1.PAGER = false
contact1.NEW_CONTACT = YES
contact1.INSTANCE = inst1
*-----------------------------------------------
* Installed Languages
*-----------------------------------------------
LANG = EN
*-----------------------------------------------
* SA MP Base Component
*-----------------------------------------------
INSTALL_TSAMP = NO
[root@wcary2nu ~]#



Hello,

According to my understanding, you are able to create the Jazz database within DB2 by using the "db2inst1" ID and its corresponding password is "db2iadm1"? But in your teamserver.properties file, you have the following set, which does not match with the id's password.

com.ibm.team.repository.db.jdbc.password=db2admin

I would try change it to the following, then try the repotools createtable command to see if it will work:

com.ibm.team.repository.db.jdbc.password=db2iadm1

Hope this helps,

Susan

permanent link
Jeff Taylor (7673) | answered Mar 23 '09, 1:24 p.m.


...you have the following set, which does not match with the id's password.

com.ibm.team.repository.db.jdbc.password=db2admin

I would try change it to the following, then try the repotools createtable command to see if it will work:

com.ibm.team.repository.db.jdbc.password=db2iadm1

Hope this helps,

Susan


I just tried that, but it did not help. Same error message...

permanent link
Susan Wu (4712116) | answered Mar 23 '09, 5:10 p.m.


...you have the following set, which does not match with the id's password.

com.ibm.team.repository.db.jdbc.password=db2admin

I would try change it to the following, then try the repotools createtable command to see if it will work:

com.ibm.team.repository.db.jdbc.password=db2iadm1

Hope this helps,

Susan


I just tried that, but it did not help. Same error message...

Have you already created the Jazz database, from the DB2 Command Window with the above ID? and can you access the Jazz db from DB2 with this ID? On linux, the create db command from DB2 command window would be:

db2 create database JAZZ using codeset UTF-8 territory en

Susan

permanent link
Jeff Taylor (7673) | answered Mar 24 '09, 8:53 a.m.

Have you already created the Jazz database, from the DB2 Command Window with the above ID? and can you access the Jazz db from DB2 with this ID? On linux, the create db command from DB2 command window would be:

db2 create database JAZZ using codeset UTF-8 territory en

Susan


Thanks... I guess I forgot to restart the database. After running db2start, I was able to sort out the rest.

permanent link
Daniel Toczala (88211514) | answered Mar 27 '09, 11:00 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
I saw the same thing, and removing the "fullyMaterializeLobData=false" from the file worked for me.

I am working now, and have filed a work item (https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=76379) for this.

permanent link
Dilawar Singh (11) | answered May 26 '09, 5:50 a.m.
JAZZ DEVELOPER
You need to change the port number 50001 to 50000 as it is the default port for DB2 on Linux. You need to also remove "fullyMaterializeLobData=false;" from teamserver.properties file for DB2.

I am having some problems trying setup a DB2 database for RTC on RHEL 5.

I already saw the postings about removing fullyMaterializedLobData from the teamserver.properties file, and got past that point. Currently, I beleive that I am stuck with some other permissions issue.

Note: The documentation say to use "db2fenc1" to create the database with the "db2 create..." command. For some reason, I received an error about permissions. I was able to use "db2inst1" to run the "db2 create" command. I don't know if this would be related or not.

[root@wcary2nu server]# ./repotools.sh -createTables

Repo Tools, Version 2.0 M2 - I20090316-0438
Provisioning using "./provision_profiles".
Rational Jazz Team Server - Standard
Loading configuration from "file:teamserver.properties".
Attempting Initial Database Connection Using
Db Name/Location: //localhost:50001/JAZZ:user=xxxxxxxx;password=xxxxxxxx;
CRJAZ0503I Failed to connect to the database: "[ibm][db2][jcc][t4][2043][11550]
Exception java.net.ConnectException: Error opening socket to server localhost/12
7.0.0.1 on port 50,001 with message: Connection refused."
Db Name/Location: "//localhost:50001/JAZZ:user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ1093I Service failed to activate.
CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.r
db.IDatabaseStateService".
CRJAZ1203I Could not determine the database location.
CRJAZ1306I The service "com.ibm.team.repository.service.internal.rdb.IDatabaseSt
ateService" is not available.
Creating the tables for the database "//localhost:50001/JAZZ:user=xxxxxxxx;passw
ord=xxxxxxxx;" with indices.
CRJAZ1141I Failed to get the service "com.ibm.team.repository.service.internal.r
db.IDatabaseCreationService".
CRJAZ1309I The database connectivity service is not ready.
The database tables were not created.
[root@wcary2nu server]#


Here are the relevant lines from the teamserver.properties file:

com.ibm.team.repository.db.vendor = DB2

com.ibm.team.repository.db.jdbc.location=//localhost:50001/JAZZ:user=db2inst1;pa
ssword={password};
com.ibm.team.repository.db.jdbc.password=db2admin

# DB2 requires a path where the content tablespace should be created, examples f
or Win and Linux follow
com.ibm.team.repository.db.db2.content.tablespace.location=content_tablespace


More back ground information:

I create the following userids/groups for the installation

db2isnt1 (db2iadm1)

db2fenc1 (db2fadm1)
dasusr1 (dasadm1)


This is the response file from the DB2 installation:

[root@wcary2nu ~]# more db2exp.rsp

*-----------------------------------------------------
* Generated response file used by the DB2 Setup wizard
* generation time: 3/20/09 2:12 PM
*-----------------------------------------------------
* Product Installation
LIC_AGREEMENT = ACCEPT
PROD = UDB_EXPRESS_EDITION
FILE = /opt/ibm/db2/V9.5
INSTALL_TYPE = TYPICAL
*-----------------------------------------------
* Das properties
*-----------------------------------------------
DAS_CONTACT_LIST = LOCAL
* DAS user
DAS_USERNAME = dasusr1
DAS_UID = 5002
DAS_GROUP_NAME = dasadm1
DAS_HOME_DIRECTORY = /localdisk/home/dasusr1
* ----------------------------------------------
* Instance properties
* ----------------------------------------------
INSTANCE = inst1
inst1.TYPE = wse
* Instance-owning user
inst1.NAME = db2inst1
inst1.UID = 5004
inst1.GROUP_NAME = db2iadm1
inst1.HOME_DIRECTORY = /localdisk/home/db2inst1
inst1.AUTOSTART = YES
inst1.SVCENAME = db2c_db2inst1
inst1.PORT_NUMBER = 50001
inst1.CONFIGURE_TEXT_SEARCH = YES
inst1.TEXT_SEARCH_HTTP_SERVICE_NAME = db2j_db2inst1
inst1.TEXT_SEARCH_HTTP_PORT_NUMBER = 55001
* Fenced user
inst1.FENCED_USERNAME = db2fenc1
inst1.FENCED_UID = 5003
inst1.FENCED_GROUP_NAME = db2fadm1
inst1.FENCED_HOME_DIRECTORY = /localdisk/home/db2fenc1
* Contact properties
CONTACT = contact1
contact1.CONTACT_NAME = db2inst1
contact1.EMAIL = db2inst1@wcary2nu.ca.nortel.com
contact1.PAGER = false
contact1.NEW_CONTACT = YES
contact1.INSTANCE = inst1
*-----------------------------------------------
* Installed Languages
*-----------------------------------------------
LANG = EN
*-----------------------------------------------
* SA MP Base Component
*-----------------------------------------------
INSTALL_TSAMP = NO
[root@wcary2nu ~]#

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.