Unable to delete a Database Manage Storage(DMS) Tablespace? Undefined tablespace error but can't use the containers in subsequent create Tablespace.
Posted on 2011-02-24
I started to create a Database managed storage tablespace which appeared successfully created. I then started to create a table for the tablespce
and got tablespace not found error. I issued a db2 list tablespaces and found that the tablespace was not listed. Okay, I went ahead and tried to
create the tablespace again and got the error that the "...containers have been assigned to the tablespace" but the tablespace is not shown when I issued
a select for tablespace from syscat.tablespaces/ I hope I have explained my problem well and I need help resoving this problem.
How can I go about dropping this problem tablespace so that I can reuse the containers? How can I delete a tablespace that seem to not cataloged?
Any help will be highly appreciated