DB2 Tips n Tricks Part 55 – How Table Size increased after Table Reorganization



DB2 Tips n Tricks Part 55 – How Table Size increased after Table Reorganization

DB2 Tips n Tricks Part 55 - How Table Size increased after Table Reorganization

How Table Size increased after Table Reorganization
Solution:
Check for PCTFREE Table Attribute;
If set to 50 then after table reorganization it will double the table size.
Also, When loading 10GB if Data, it will occupy 20GB of Table Size.

Happy Learning & Sharing

Comments are closed.