Monitoring HALDB Online Reorganization

Several commands allow you to monitor a HALDB Online Reorganization.

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

Table 1. Mapping monitoring tasks to commands for HALDB Online Reorganization
Task	Command
Display status and rate information about HALDB Online Reorganizations that are in progress.	`QUERY OLREORG` type-2 command
Display status and rate information about HALDB Online Reorganizations when the ALTER option is specified.	QUERY OLREORG STATUS(ALTER) type-2 command
Monitor and display the status of the specified databases or partitions (including those HALDB Online Reorganizations that are in progress).	`/DISPLAY DB OLR` type-1 command
Display HALDB Online Reorganization status.	`QUERY DB` type-2 command
List all of the databases for which HALDB Online Reorganizations are in progress.	`QUERY DB STATUS(OLR)` type-2 command