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
763 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
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…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

746 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now