How to recover the dropped tablespace?

I have gone through the DB2 ADMIN GUIDE.

But still I couldn't do that.

Please help me out.

Thanks in advance.

Views: 253

Reply to This

Replies to This Discussion

I'll present a recipe in IDUG EMEA about How to recever a dropped Table. fya.

Thanks for your reply, Kindly send the link of the recipe.


Dinesh kanna s

Sometimes you may drop a table space accidently such as table space is dropped when all the tables is explicitly created or when someone executes a DROP TABLESPACE statement unintentionally for specific table space. However, this issue can be solved with some manual methods. You can follow the manual steps mentioned in the below link:

This will be very helpful to you for repair and restoring accidentally dropped sb2 tablespace. All the best!!!


Latest Activity

Profile Icon via Twitter
IBM Unveils New Ways to Use, Develop for #Db2 for greater data control. Check out this press release - #data #JSON
Twitter1 hour ago · Reply · Retweet
Profile Icon via Twitter
Groupe France Mutuelle moved its mission-critical application to IBM #Db2 and cut costs while boosting performance…
Twitter3 hours ago · Reply · Retweet
Profile Icon via Twitter
RT @scend: The Db2 Developer Community Edition is available now! Use Db2's enterprise capabilities for free! #MySQL #MongoDB
Twitter7 hours ago · Reply · Retweet
Maira T. de Melo posted a group
17 hours ago

© 2017   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service