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