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.