Deleting a partition from a HALDB database that uses high-key partitioning

Deleting a partition permanently removes a partition and any records that it might contain from both the HALDB database. The records associated with the deleted partition are also permanently removed from the RECON data set.

1. Take an image copy of the partition you intend to delete and any partitions in to which records from the deleted partition will be moved.
2. Stop access to the partition you are deleting 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 both the partition you are deleting and the other partitions affected by the deletion.
4. Delete the definition of the partition from the RECON data set by using one of the following methods:
   • The HALDB Partition Definition utility
   • The DBRC command DELETE.PART DBD(HALDB_master_name) PART(partition_name)
5. Ensure that the high key values defined in the RECON data set for each partition are still appropriate.
6. Initialize the remaining partitions that will contain the records of the deleted partition.
7. Reload the remaining partitions using the output of step 1.
8. Take an image copy of the reloaded partitions. The image copy needed flag is set for the data sets of the reloaded partition.
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.