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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

FreeBSD on EC2 FreeBSD (https://www.freebsd.org) is a robust Unix-like operating system that has been around for many years. FreeBSD is available on Amazon EC2 through Amazon Machine Images (AMIs) provided by FreeBSD developer and security office…
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…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

773 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