1- catalog the old database
2- then delete it.
====
db2 catalog db my_db as my_db on my_directory
db2 drop db my_db as my_db


-----Message d'origine-----
De : Kishor Bhede
[mailto:db2udbdba-ezmlmshield-x28199768.[Email address protected]
Envoyé : mardi 26 octobre 2004 06:58
À : LazyDBA Discussion
Objet : 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