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.