?
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
Medium Priority
?
773 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 500 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

Enroll in August's Course of the Month

August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

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
Compliance and data security require steps be taken to prevent unauthorized users from copying data.  Here's one method to prevent data theft via USB drives (and writable optical media).
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…
Suggested Courses
Course of the Month11 days, 18 hours left to enroll

752 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