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.
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.
3 answers
boydm@us.ibm-dot-com.no-spam.invalid (boydm) wrote in news:h3qi6d$3qo$1
@localhost.localdomain:
you did a reportools -createTable right ?
just checking.
--
Christophe Elek
Jazz L3
IBM Software Group - Rational
@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
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.
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.