How do I clean up old BMC Db2 databases, packages and plans?

The install provides jobs to clean up the BMC databases, packages and plans that are being installed. These jobs start with #D and you should review them carefully before executing them. If you cannot find the Install JCL or hlq.UDBCNTL library from the version of the databases and packages that you would like to clean up, you can use the following steps:

Note: The instructions below assume you are using CATALOG MANAGER.
  
Stop the databases that you want to drop for a couple of weeks to ensure they are not being used.

1. To clean up the CollectionID, plans and packages and synonyms.
   1. Type TB next to the database.
   2. Type PG next to a table.
   3. Type CI next to the package.
   4. Type PL next to the CI to get all the Plans.
   5. Type FREE ALL on the command line to generate a job to free the plans.
   6. Type SY next to the Collection ID to generate a synonym list.
   7. Type DROP ALL on the command line to drop the synonyms. (Important Note: Do NOT drop the synonyms on the BMCUTIL tables)
   8. Type AL next to the database.
   9.  Type DROP ALL on the command line to drop the aliases. 
   10. Type FREE all next to the Collection ID to free all the packages in the Collection ID.
2. Drop the DATABASEs.

Catalog Manager will generate a Drop Restrict on Drop if you select that option.