Dropping databases

Dropping a database is an easy task compared to Oracle. You select the database you want to drop, and all its objects, containers, and files will be deleted.

Getting ready

The database must not be used, so all users have to be disconnected. I recommend you take a backup at this point. For many reasons, it could have been the wrong database to drop.

How to do it...

1. Select the database:

   Select the databases folder on the left pane of the control center; or, you can list databases:

   	[db2inst1@nodedb21 ~]$ db2 list database directory
   
   	 System Database Directory
   
   	 Number of entries in the directory = 1
   
   	Database 1 entry:
   
   	 Database alias                       = NAV
   	 Database name                        = NAV
   	 Local database directory             = /data/db2
   	 Database release level               = d.00
   	 Comment                              = Aviation Geo Data
   	 Directory entry type                 = Indirect
   	 Catalog database partition number    = 0
   	 Alternate server hostname...