It's all about the answers!

Ask a question

Has anyone been successful with RC4 and DB2 on Linux?


Bryan Miller - Integration Developer (4493531) | asked Jun 10 '08, 2:42 p.m.
Hello all,

I am on my fourth try of RTC on Linux using DB2. Has _anyone_ been able to get this combination to work correctly?

The response file provided for DB2 in RC4 is giving me fits with the size of the provided user names. I am unable to grant rights to DB2 users. If I install Jazz as root it sets the install directory tree to 700 and prevents other users from running anything in the install area (/opt/IBM/JazzServer). Yikes!

I am running RHEL 5 and RC4.

many thanks in advance,
Bryan

6 answers



permanent link
Dmitry Karasik (1.8k11) | answered Jun 10 '08, 2:42 p.m.
JAZZ DEVELOPER
On Tue, 10 Jun 2008 18:47:56 +0000, bmiller wrote:

Hello all,

I am on my fourth try of RTC on Linux using DB2. Has _anyone_ been able
to get this combination to work correctly?

Yes I have set it up that way.


The response file provided for DB2 in RC4 is giving me fits with the
size of the provided user names. I am unable to grant rights to DB2
users. If I install Jazz as root it sets the install directory tree to
700 and prevents other users from running anything in the install area
(/opt/IBM/JazzServer). Yikes!

Where did you get a response file? DB2 complains if you specify usernames
longer than 8 characters.

- Dmitry

permanent link
Dmitry Karasik (1.8k11) | answered Jun 10 '08, 2:42 p.m.
JAZZ DEVELOPER
On Tue, 10 Jun 2008 20:37:55 +0000, bmiller wrote:

I used my instance owner to create the
database they that user is unable to create tables (i.e. repotools.sh
-createTables).

Did you specify the instance owner userid and password in
teamserver.properties?

- Dmitry

permanent link
Bryan Miller - Integration Developer (4493531) | answered Jun 10 '08, 4:34 p.m.
On Tue, 10 Jun 2008 18:47:56 +0000, bmiller wrote:

Hello all,

I am on my fourth try of RTC on Linux using DB2. Has _anyone_ been able
to get this combination to work correctly?

Yes I have set it up that way.


The response file provided for DB2 in RC4 is giving me fits with the
size of the provided user names. I am unable to grant rights to DB2
users. If I install Jazz as root it sets the install directory tree to
700 and prevents other users from running anything in the install area
(/opt/IBM/JazzServer). Yikes!

Where did you get a response file? DB2 complains if you specify usernames
longer than 8 characters.

- Dmitry

The response file was re-added in RC4 (missing in Beta3). I simply used the one provided - hence my surprise at failure. It is found under db2/linux/db2exp-RTC.rsp.

Also, db2 under Linux requests three users (quite unlike Windows); DAS, Instance owner, and fenced user. I used my instance owner to create the database however that user is unable to create tables (i.e. repotools.sh -createTables).

I suspect there is a step missing from the "setting up a db2 database" section or else it is implied knowledge. Any and all thoughts welcome.

permanent link
Bryan Miller - Integration Developer (4493531) | answered Jun 11 '08, 12:35 a.m.
On Tue, 10 Jun 2008 20:37:55 +0000, bmiller wrote:

I used my instance owner to create the
database they that user is unable to create tables (i.e. repotools.sh
-createTables).

Did you specify the instance owner userid and password in
teamserver.properties?

- Dmitry

Yes, I did.

permanent link
Dmitry Karasik (1.8k11) | answered Jun 11 '08, 4:13 a.m.
JAZZ DEVELOPER
On Wed, 11 Jun 2008 04:37:50 +0000, bmiller wrote:

Did you specify the instance owner userid and password in
teamserver.properties?

Yes, I did.

So what is the error that you get when you run repotools -createTables?

- Dmitry

permanent link
Bryan Miller - Integration Developer (4493531) | answered Jun 11 '08, 9:49 a.m.
# ./repotools.sh -createTables
Repo Tools, Version 1.0 RC4 - I20080530-1457
Provisioning using "./provision_profiles".
Rational Jazz Team Server - Standard (Early Access)
Loading configuration from "file:teamserver.properties".
Fulltext Index Location: workitemindex/fulltext_index/
CRJAZ0503I Failed to connect to the database: " Exception java.net.ConnectException: Error opening socket to server localhost/127.0.0.1 on port 50,000 with message: Connection refused."
Db Name/Location: "//localhost:50000/JAZZDB:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx;"
CRJAZ0503I Failed to connect to the database: " Exception java.net.ConnectException: Error opening socket to server localhost/127.0.0.1 on port 50,000 with message: Connection refused."
Db Name/Location: "//localhost:50000/JAZZDB:fullyMaterializeLobData=false;user=xxxxxxxx;password=xxxxxxxx;"
Exception java.net.ConnectException: Error opening socket to server localhost/127.0.0.1 on port 50,000 with message: Connection refused.

When I run the "db2 get dbm cfg" I see

SVCENAME = db2c_db2instl

and checking /etc/services I see the port is 50001. I will update my properties file and try running it again.

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.