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

Error installation Rational Insight - DB alias "RIDW&qu

Questions
Tags
Users
Badges
FU YONG
(46●7●2) May 27 '10, 5:38 a.m.
Dear all,

During the installation of Rational Insight 1.0.0.2 on windows xp, an error was reported as "error in creating database"

A detailed log file records it as:
SQL1005N The database alias "RIDW" already exists in either the local database directory or system database directory.

This system has DB2 9.1 installed previously, and there was no database either named or aliased as "RIDW".

Some actions were taken to attempt solving such problem as suggested by the following link:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.messages.sql.doc/doc/msql01005n.html

* Drop the database using the alias name.
* Uncatalog the alias.
* Catalog the alias into the system database directory. Drop the database using the same alias.

However, it does not indicate the existence of a database named or aliased as "RIDW" when doing drop or uncatalog. Re-installing the RI while ensuring no "RIDW"'s existence in DB2 did not help too.

Anyone has an idea what could be the possible cause?

Thanks.

Fu Yong

0 votes

3 answers
8,782 views
0 votes

3 answers

Permanent link
Benjamin Silverman
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (4.1k●6●10) May 28 '10, 4:51 p.m.
I haven't seen DB2 throw an error like that when the database does not truly exist. What happens when you enter db2 connect to RIDW from a db2cmd prompt? Does it throw an error like this: 

SQL1013N  The database alias name or database name "RIDW" could not be found.

SQLSTATE=42705


If not, you may want to check your DB2 client configuration to make sure 1) There is no database catalogged as RIDW, and 2) that the database really does not exist. Although it sounds like you have already done this.

You could always attempt to create the database manually to see if you get the same error by using a simple command like this. If it creates, drop it and try again.

db2 create database RIDW

Or, you could always just give the database a different name when you create it through the install wizard. It does not have to be called RIDW.

Hope it helps,

0 votes

Permanent link
FU YONG
(46●7●2) May 30 '10, 10:05 p.m.
I haven't seen DB2 throw an error like that when the database does not truly exist. What happens when you enter db2 connect to RIDW from a db2cmd prompt? Does it throw an error like this: 

SQL1013N  The database alias name or database name "RIDW" could not be found.

SQLSTATE=42705


If not, you may want to check your DB2 client configuration to make sure 1) There is no database catalogged as RIDW, and 2) that the database really does not exist. Although it sounds like you have already done this.

You could always attempt to create the database manually to see if you get the same error by using a simple command like this. If it creates, drop it and try again.

db2 create database RIDW

Or, you could always just give the database a different name when you create it through the install wizard. It does not have to be called RIDW.

Hope it helps,


Hi bsilverm,

Thanks for your help.

That seemed to be a strange problem, luckily it was solved by performing a clean installation while ensuring the database really dos not exist or cataloged. To get to this point, quite a number of attempts were actually experimented.

Regards,

Fu Yong

0 votes

Permanent link
Fred Bickford
(16●2●2●1) Sep 30 '11, 10:19 a.m.
Just an FYI to the thread...(since I ran into this and myself today and had to fix it)

https://jazz.net/forums/viewtopic.php?p=65842#65842

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.

Ask a question
Guidelines
FAQ
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: May 27 '10, 5:38 a.m.

Question was seen: 8,782 times

Last updated: May 27 '10, 5:38 a.m.

Confirmation Cancel Confirm