Stopping HALDB Online Reorganization
You can stop a HALDB online reorganization by issuing the TERMINATE OLREORG command against one or more partitions.
The command can be issued as either an IMS type-1 command, /TERMINATE OLREORG, or a type-2 command, TERMINATE OLREORG.
If the database is shared, only the type-2 command can be routed to all IMS systems that share the database. The type-1 command applies only to the system in which it is issued.
If the reorganization was started by an INITIATE OLREORG command with OPTION(ALTER) specified, all of the partitions in the database are reorganized. In this case, if you need to stop the reorganization across the entire database, specify an asterisk in the NAME keyword, for example TERMINATE OLREORG NAME(*).
Example: The following figure shows the processing steps for an online reorganization of a HALDB partition and how it is affected by a TERMINATE OLREORG command that temporarily stops the reorganization:
- When you issue the TERMINATE OLREORG command, IMS terminates the reorganization by entering the termination phase.
- Later, when you issue the INITIATE OLREORG command, IMS restarts the reorganization from the initialization phase, then proceeds to the copying phase. In the figure, the reorganization then completes successfully through the termination phase.
Note that there are two sets of data sets for the second initialization phase because the reorganization is not complete.
In the figure, the columns represent the flow of control through the phases of the online reorganization, from the user to IMS, and the status of the data sets as the processing events occur.
