Reorganizing a database

Given the following initial and target configurations, use this scenario to reorganize a database.

  • Initial configuration
    • dbx is registered for database-level sharing.
    • dbx is authorized for update access to an online IMS system (IMSA).
  • Target configuration
    • dbx is successfully reorganized.

Follow these steps to reorganize a database:

Procedure

  1. Prevent other IMS systems from obtaining access with the following command: CHANGE.DB DBD(dbx) NOAUTH
  2. Start reorganization jobs.

    Run a set of reorganization jobs, such as Scan, Unload, Reload, or Prefix Update, in a protected environment.

    You must run these reorganization utilities without interference from other IMS systems. The DBRC CHANGE.DB NOAUTH command prohibits authorizations to the database for online and batch IMS systems, except for all reorganization utilities.

  3. Authorize the Online Database Image Copy utility (DFSUICP0) initialization with the following command: CHANGE.DB DBD(dbx) AUTH
    This command allows other batch or online IMS systems to obtain access to dbx.

Related reading:  For a discussion of ways to reorganize a database, see Reorganizing databases.