I am not sure if you are still having any problem, but then i thought may be
i will post this message for people refering to this group for informations.

If the database directory gets deleted then your drop database command will
give an error. This is the case where the database is physically deleted
from the file system and its entry still exists in the DB. So to uncatalog
the database is the only task remaining and this can be done by giving a
single command

uncatalog database <databasename>

Similarly if you have a database on a file system it can be cataloged using
catalog db <database name> as <alias name> at path <directory>

Regards
-Bimal D Tandel
Marlabs Inc.
----- Original Message -----
From: "Kishor Bhede "
<db2udbdba-ezmlmshield-x28199768.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, October 26, 2004 12:58 PM
Subject: How to drop Database?


> Hello All,
>
> I want to drop DB in DB2 and I know the
> statement "DROP DATABASE <DBNAME>".
>
> But the directory containing the DB2 Database
> files is deleted. Now I cannot drop the database by
> using above statement.
>
> I am working on DB2 V8 and AIX5.1.
>
> Thanks,
>
> Kishor
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Read only the mail you want - Yahoo! Mail SpamGuard.
> http://promotions.yahoo.com/new_mail
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>


DB2 & UDB email list listserv db2-l LazyDBA home page