RE: How to drop Database?

RE: How to drop Database?

 

  


Kishor,


db2 list db directory

check if you getting any thing, if not


db2 catalog db yourdbname on instancehomedirectory

db2 terminate

db2 drop db yourdbname



Hope that will resolve your issues, let me know , if any questions.


Thank You


Lekharaju Ennam

-----Original Message-----
From: bimal tandel
[mailto:db2udbdba-ezmlmshield-x72249070.[Email address protected]
Sent: Tuesday, October 26, 2004 8:28 AM
To: LazyDBA Discussion
Subject: Re: How to drop Database?


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
>
>



---------------------------------------------------------------------
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