Offline Reorganizations after HALDB Online Reorganizations

If an online reorganization is currently in progress, you can perform an offline reorganization after stopping the online reorganization by issuing the TERMINATE OLREORG command and then stopping access to the partition by issuing either the /DBRECOVERY command or the UPDATE DB NAME(partition_name) STOP(ACCESS) command. The HD Reorganization Unload utility (DFSURGU0) automatically unloads the records from the active portions of both the A–J and M–V data sets. The HD Reorganization Reload utility (DFSURGL0) loads all records into the A–J data sets and turns off the cursor-active status of the online reorganization in the RECON data set.

If an online reorganization is not currently in progress, you can perform an offline reorganization of a HALDB database without taking any additional special steps.