Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

DB2 connection issues...

I am currently trying to verify a completed set up and would like to have my test environment completed by Monday if possible. :-( I am working with a WebSphere (6.1.0.25) / DB2 (V9.5) set up and have the jazz admin console finally up and running. However, from said admin console, I see this message concerning my database connection:

CRJAZ1061l The database is responding, but the Jazz repository schemas and tables cannot be found. Check that the database JDBC location is correct. If this is a new database, stop the server and use the "repotools" command to create the tables.

From there, I decided to check all of the JDBC information to verify it's correctness. The DB is located on the same machine (localhost) and is called JAZZ. I can connect to it using the command line and the same user/password combination. However, when I run the "repotools -verify" function I get this message in the log:

2009-07-17 11:45:31,282 repotools -verify
2009-07-17 11:45:31,300 Repo Tools, Version 1.0 - I20080618-1642
2009-07-17 11:45:31,301 Provisioning using "./provision_profiles".
2009-07-17 11:45:50,780 Rational Jazz Team Server - Standard (60 day trial)
2009-07-17 11:45:50,815 Loading configuration from "file:teamserver.properties".
2009-07-17 11:45:55,716 Fulltext Index Location: workitemindex/fulltext_index/
2009-07-17 11:45:58,765 Initial database connection successful
Db Product Name: DB2/LINUX
Db Product Version: SQL09050
Db Name/Location: //localhost:50000/JAZZ:user=xxxxxxxx;password=xxxxxxxx;
2009-07-17 11:46:01,014 CRJAZ1204I The database "//localhost:50000/JAZZ:user=xxxxxxxx;
password=xxxxxxxx;" does not exist or the database user does not have the required
priveleges to access the database.

I'm not sure what else to try to fix this issue. Any assistance would be greatly appreciated.

0 votes



3 answers

Permanent link
boydm@us.ibm-dot-com.no-spam.invalid (boydm) wrote in news:h3qi6d$3qo$1
@localhost.localdomain:

I'm not sure what else to try to fix this issue. Any assistance would
be greatly appreciated.

you did a reportools -createTable right ?
just checking.

--
Christophe Elek
Jazz L3
IBM Software Group - Rational

0 votes


Permanent link
boydm@us.ibm-dot-com.no-spam.invalid (boydm) wrote in news:h3qi6d$3qo$1
@localhost.localdomain:

I'm not sure what else to try to fix this issue. Any assistance would
be greatly appreciated.

you did a reportools -createTable right ?
just checking.

--
Christophe Elek
Jazz L3
IBM Software Group - Rational


Yes, and when I look in the DB as that db2 user, I can see that the tables are present.

0 votes


Permanent link
boydm@us.ibm-dot-com.no-spam.invalid (boydm) wrote in news:h3qi6d$3qo$1
@localhost.localdomain:

I'm not sure what else to try to fix this issue. Any assistance would
be greatly appreciated.

you did a reportools -createTable right ?
just checking.

--
Christophe Elek
Jazz L3
IBM Software Group - Rational


Yes, and when I look in the DB as that db2 user, I can see that the tables are present.

Over the weekend, the issued seemed to be resolved. It looks as though it was a bad/corrupted export of the original database. Another export and re-import command seemed to do the trick. Thank you for your help and timely response.

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jul 17 '09, 3:05 p.m.

Question was seen: 5,477 times

Last updated: Jul 17 '09, 3:05 p.m.

Confirmation Cancel Confirm