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.