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



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

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

Accidentally Dropped Incorrect Table space. Not to worry.
Solution 1: Restore entire db and roll forward to point in time just before drop table space – Time,Resource Inefficient – Bad Choice
Solution 2: Rebuild a new DB with SYSCATSPACE ,Dropped Table space and roll forward it to point in time just before drop table space – Time,Resource Efficient – Good Choice
Happy Learning & Sharing

Comments are closed.