By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,746 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

how to *really* remove a database in DB2 ..

P: 1
Hi,
I have recently removed a database from DB2 .

I had deleted a database in the past, but now when I go to recreate
it, I'm getting the message
"The database alias ___ already exists in either the local database
directory or system database directory"
I have checked the database, I have cataloged and uncataloged, and
when I list out the directories, the alias does not appear. But when I
try to recreate it, I get this message.
How do I locate the database alias and rename/remove it, once and for
all?
Thanks
Rajni
Jul 27 '07 #1
Share this Question
Share on Google+
1 Reply


P: 2
Hi,
I have recently removed a database from DB2 .

I had deleted a database in the past, but now when I go to recreate
it, I'm getting the message
"The database alias ___ already exists in either the local database
directory or system database directory"
I have checked the database, I have cataloged and uncataloged, and
when I list out the directories, the alias does not appear. But when I
try to recreate it, I get this message.
How do I locate the database alias and rename/remove it, once and for
all?
Thanks
Rajni
Use the CLP (command line processor) to connect to the DB2 system, catalog the database (if not already done) and the drop it; then you should be done.
It seems that dropping the database from the command-center (gui tools) does not delete it from the disk while doing it from clp or using the command-line tools is okay.

hope it helps
Jul 29 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.