Hi all,

I have a problem when i try to drop a database. It gives a message that database in use. But i am very sure that the database which i am planning to drop is not in use by any one because the server resides on my local machine.

I have one more query, can anyone tell me what is the difference between drop and remove database options in db2 udb.

Prior to the drop statement you can state a 'force all' statement to do a hard disconnect on all connections like:

db2=> force application all

you should be able do a drop database statement then...

As far as I can remember the drops really deletes the database, whereas the remove uncatalogs it. It is still there, but not recognized as such........... (could be wrong though on this one)

Hi,

DROP - permanently deletes a database (recovery is not posible)
REMOVE - unacatalog database (with Add options you can catalog it back)

Hope this helps,
Grofaty

Hi,

Thanks for the support.

since i was not able to drop a database, i removed that. can u tell me how to completely drop that database, which i have removed.

Hi,

In Control Center click pluses to open Database folder. Then on Database folder click Add and then enter the database name. Select Default drive and press OK. When database apears select right click on database and drop. If you will not be able to drop the database. Then right click and Disconect. Then try drop again.

Hope this helps,
Grofaty

db2stop kill

Will force all the users out and kills all the db2 process hanging.
This step will ensure that db2 will not be under use of any body

Now execute the drop command.

If this does not help you need to uncatalog the database and manually delete all the containers


Good Luck
Prasad

A very common question ...

Well, since you have uncataloged the database, you will have to catalog it again ...

db2 catalog database <dbname> on Cor whatever your database drive is )

Then issue

db2 drop database <dbname>
and now you should see the database dropped ...

Cheers

Sathyaram