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: 240

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.

Regards

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:

http://www.filerepairtool.net/blog/restore-accidentally-dropped-db2...

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

RSS

Latest Activity

Profile Icon via Twitter
Twitteryesterday · Reply · Retweet
Profile Icon via Twitter
RT @SQL_Adria: Learn from @mstopfer1 at #SQLAdria Sibenik, June 2017! Check #DB2 #Linux #unix #windows Track & One Day #seminar! https://t.…
Twitteryesterday · Reply · Retweet
Profile Icon via Twitter
RT @SQL_Adria: Learn Building a #Mobile App using #DB2 native REST services by @janeman_98 at #SQLAdria #sibenik https://t.co/usJjmm3QcQ #…
Twitteryesterday · Reply · Retweet
Profile Icon via Twitter
RT @SQL_Adria: Learn from @EberhardHecler: #Data Lake with #DB2 for z/OS & DB2 #analytics Accelerator at #SQLAdria seminar: https://t.co/u
Twitteryesterday · Reply · Retweet

© 2017   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service