I work in a shop that primarily uses Oracle databases. We use DB2 for our local databases for J2EE unit tests. Each project requires a new database.
While creating a database, DB2 was interrupted. I was unable to create the table space, and wanted to delete the database. I chose "delete" in the control center, and now I understand I should have chosen "drop" first. As a result, I cannot create using the same database name (instance already exists), and I cannot proceed with table space, tables etc (instance does not exist).
One person suggested locating a utility that would clean up the entry table. I have not found the utility, or any information on this problem.
I finally abandoned the database, and created a new one with another name.
I'd like to clean up my workstation.
What is the proper way to remove a DB2 database, and do I have any recourse on the messed up one? My only idea is to deinstall DB2 and reinstall, which means I lose several perfectly good databases and all my created data.