Has anyone been successful with RC4 and DB2 on Linux?

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

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

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.

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.

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

# ./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.