Deleting user-managed data sets

When you drop indexes or table spaces that you defined user-managed data sets for, you must also delete the data sets unless you want to reuse them. To reuse a data set, first commit, and then create a new table space or index with the same name. When Db2 uses the new object, it overwrites the old information with new information, which destroys the old data.