467,179 Members | 1,298 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,179 developers. It's quick & easy.

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

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
  • viewed: 1861
Share:
1 Reply
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.

Similar topics

1 post views Thread by Kay Stoner | last post: by
2 posts views Thread by Themis Papassilekas | last post: by
4 posts views Thread by u7djo@hotmail.com | last post: by
4 posts views Thread by Viator | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.