Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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
4
767 Views
Last Modified: 2013-11-17

Hello Experts,

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

Thanks okonita001
0
Comment
Question by:Okonita001
  • 3
4 Comments
 
LVL 37

Assisted Solution

by:momi_sabag
momi_sabag earned 125 total points
ID: 34979291
have you tried maybe to restart db2?
maybe it will solve your problem (which is very odd)
0
 

Assisted Solution

by:Okonita001
Okonita001 earned 0 total points
ID: 34979619

momi_sabag,

This is being done in production and I am not in a position to restart or ask for DB2 to be restarted.
The mystery is that I cannot even find where the tablespace is recorded neither can I find the tablespace object. Syscat.Tablespaces shows nothing. The container path that is supposed to house the tablespace shows nothing either. I am stomped.
Any other suggestion?

Thanks
0
 

Accepted Solution

by:
Okonita001 earned 0 total points
ID: 34979678
ps: I found IBM documentation that seem to acknowledge the existence of this problem and it noted that when this happens that the second attempt should cleanup the containers but that has not happened in my case. IBM stated that the problem was fixed in DB2 UDBv9.7. We are on V9.5. Baffling is the fact that I cannot even find the tablespace in the path defined for it. So where is this object is the question?
0
 

Author Closing Comment

by:Okonita001
ID: 35106991
The solution was partially correct and I was able to figure my problem solution
0

Featured Post

The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lets start to have a small explanation what is VAAI(vStorage API for Array Integration ) and what are the benefits using it. VAAI is an API framework in VMware that enable some Storage tasks. It first presented in ESXi 4.1, but only after 5.x sup…
The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question