Partial offline reorganization

If you are reorganizing an HD database, you can reorganize parts of it, rather than the whole database.

You would need to reorganize parts, rather than all of it, for two reasons:
  • Only parts of it need to be reorganized.
  • By reorganizing only parts of it, you can break the amount of time it takes to do a total reorganization into smaller pieces.
The utilities you use to do a partial reorganization are:
  • The Database Surveyor utility, which helps you determine which parts of your database to reorganize
  • The Partial Database Reorganization utility, which does the actual reorganization

HALDB partitions do not support partial offline reorganization.