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
770 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
[X]
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
  • 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

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Ever notice how you can't use a new drive in Windows without having Windows assigning a Disk Signature?  Ever have a signature collision problem (especially with Virtual Machines?)  This article is intended to help you understand what's going on and…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
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 video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

691 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