It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×1,230

question asked: May 27 '10, 5:38 a.m.
question was seen: 8,645 times
last updated: May 27 '10, 5:38 a.m.

Related questions

Error installation Rational Insight - DB alias "RIDW&qu

0
FU YONG (46●7●2) | asked 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

3 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Benjamin Silverman (4.1k●6●10) | answered May 28 '10, 4:51 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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
permanent link
FU YONG (46●7●2) | answered 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
permanent link
Fred Bickford (16●2●2●1) | answered 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

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.