Starting HALDB Online Reorganization

You start a HALDB Online Reorganization by using either version of the INITIATE OLREORG command.

Before HALDB partitions can be reorganized online, you must enable the HALDB master database for online reorganizations by issuing either of the DBRC commands INIT.DB OLRCAP or CHANGE.DB OLRCAP.

The following table describes the tasks and commands for starting or resuming an online reorganization for a HALDB partition.

Table 1. Mapping startup tasks to commands for HALDB Online Reorganization
Task	Type-1 command format	Type-2 command format
Begin HALDB Online Reorganization for one or more partitions.	/INITIATE OLREORG	INITIATE OLREORG
Begin HALDB Online Reorganization to alter the structure of a HALDB database across all partitions.	Not supported	INITIATE OLREORG OPTION(ALTER)
Resume HALDB Online Reorganization for one or more partitions.	/INITIATE OLREORG	INITIATE OLREORG
Set the RATE for a HALDB Online Reorganization.	/INITIATE OLREORG SET(RATE(`rate`)) or /UPDATE OLREORG SET(RATE(`rate`))	INITIATE OLREORG SET(RATE(`rate`)) or UPDATE OLREORG SET(RATE(`rate`))