Hello Parameshwaran,

This is for your kind information "drop db
<dbname>" works.

$ db2 drop db db2db1
DB20000I The DROP DATABASE command completed
successfully.


Thanks,

Kishor

--- Parameshwaran S <[Email address protected]
wrote:

> **A LazyDBA.com subscriber has responded to your
> lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this
> email,
> **and removed any attachments, and kept your email
> address secret
> **from this person, and any viruses/trojans.
> **If you reply to this email, the person will see
> your email address as normal
> **Anything below this line is the original email
> text
>
>
> There is no command as Drop Database. You will have
> to drop the tablespaces, delete the physical files
> and delete the other files like control files,log
> files etc.
>
> Regards
>
> Parameshwaran
>
> -----Original Message-----
> From: Kishor Bhede
>
[mailto:db2udbdba-ezmlmshield-x28199768.[Email address protected]
>
> Sent: Tue 10/26/2004 10:28 AM
> To: LazyDBA Discussion
> Cc:
> 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
>
>
>
>
>
>


=====
Regards,

Kishor Bhede
Oracle DBA
0-9822701610



__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail

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