Reorganizing LOB table spaces
You can reorganize the data in LOB table spaces to reclaim disk space.
About this task
SYSIBM.SYSLOBSTATS contains information about how the data in the table space is physically stored.
Procedure
To determine when to reorganize LOB table spaces:
- Consider running REORG on the LOB table space when the percentage in the ORGRATIO column is less than 80.
- Use real-time statistics to identify Db2 objects that should be reorganized, have their statistics updated, or be image-copied.