Disabling HALDB partitions

Disabling a partition removes it from an active HALDB database while retaining all of the partition records in the RECON data set. Disabled partitions can be enabled later.

1. Take an image copy of the partition that you intend to disable and any partitions into which records will be moved from the disabled partition.
2. Stop access to the partition you are disabling and the other affected partitions by issuing either the /DBRECOVERY DB partition_name command or the UPDATE DB NAME(partition_name) STOP(ACCESS) command.
3. Unload the partition you are disabling and the other affected partitions.
4. Disable the partition by using one of the following methods:
   • The HALDB Partition Definition utility
   • The DBRC command CHANGE.PART DBD(HALDB_master_name) PART(partition_name) DISABLE
5. If the HALDB database uses high-key partitioning, ensure that the high key values defined to DBRC for each partition are still appropriate.
6. Initialize the remaining partitions affected by the change.
7. Reload the remaining partitions affected by the change.
8. Take an image copy of the reloaded data sets. The image copy needed flag is set for the data sets in the partitions that are initialized or loaded by the HD Reorganization Reload utility (DFSURGL0).
9. Issue the /START DB partition_name command or the UPDATE DB NAME(partition_name) START(ACCESS) command to make the affected partitions available again.