When you select a database from the contents pane and select Show Related for that object, the Show Related dialog lists any objects with first-level dependencies on that database. These objects can be: indexes, storage groups, tables, table spaces. You can view second-level dependencies by selecting Show Related for each object with a first-level dependency.
When you define a DB2 database, you name a collection of tables, indexes and table spaces that are affected by anything you do to the database. The status of each object within the database can be displayed by a single command that names only the database.
If you are dropping a work file database, it must be in the stopped state and the privilege set must include SYSADM authority.
You can not drop a database while a DB2 utility has control of any part of the database.
Dropping a database from a storage group deletes it from the storage group, it does not change the capabilities of the storage group. Also, knowing what storage group is defined for the database can be helpful, if you decide to change the default storage group for table spaces and indexes within the database. The new default DB2 storage group is only used for new table spaces and indexes; existing definitions are not changed.