Modifying and tuning HALDB Online Reorganization

Modifying and tuning a HALDB Online Reorganization is performed primarily by modifying the rate at which the reorganization is performed.

The following table describes the tasks and commands for modifying and tuning an online reorganization for a HALDB partition.

Table 1. Mapping modifying and tuning tasks to commands for HALDB Online Reorganization
Task	Type-1 command	Type-2 command
Change the impact of HALDB Online Reorganization on overall system performance, for one or more partitions.	/UPDATE OLREORG SET(RATE(`rate`))	UPDATE OLREORG SET(RATE(`rate`))
Specify whether to delete the inactive data sets after the copying phase completes.	/UPDATE OLREORG OPTION(DEL \| NODEL)	UPDATE OLREORG OPTION(DEL \| NODEL)

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 modify or tune the online reorganization of all partitions in the database, specify an asterisk in the NAME keyword, for example UPDATE OLREORG NAME(*) SET(RATE(rate)).