DB2 Tips n Tricks Part 8 - Restore an accidentally dropped table space

Video for Restoring Accidentally Dropped Table space.See Database Rebuild with only subset of table spaces in Action.

Views: 300


You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

Comment by Harishkumar Baburao Pathangay on September 21, 2013 at 12:23pm

Hi Guy Przytula,

After a quick reading from Info center...

If you have dependencies then it will not allow to drop table spaces. Say A table having Data and Index in separate table spaces, then you have to drop both the table spaces together.

I am just creating simple examples. Please consider that.


Harish Pathangay

Comment by Harishkumar Baburao Pathangay on September 18, 2013 at 9:02am

Hi Guy Przytula,

I was able to drop a table space and it had a table defined in the table space. If you look past 5 min of video, i have demonstrated the scenario with examples. Please have a look and let me know.


Harish Pathangay

Comment by Guy Przytula on September 18, 2013 at 4:26am

I had in mind (and already seen) that drop tablespace is not possible if any object exists in tablespace

dropping an empty tablespace is no problem - just re-create

dropping a table : if dropped table recovery is activated : nop

best regards, Guy Przytula

Featured Downloads

Try BLU Acceleration on Cloud

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service