Reorganizing databases offline

You perform three basic steps when reorganizing a database offline when you are not making structural changes to the database.

The steps for reorganizing a database offline are:

Procedure

  1. Unload the existing database.
  2. Delete the old database space and defining new database space. (This practice is always good, but it is only necessary if you have multiple extents or volumes, or are using VSAM.) For VSAM, database space refers to the clusters defined to VSAM for database data sets.
  3. Reload the database.