Considerations for deleting a partition from a HALDB database that uses a secondary index

If there a HALDB database uses a secondary index, you must be careful when you delete a partition.

If the secondary index has entries that point to the deleted partition, the secondary index becomes invalid. You must rebuild it with a tool such as the IMS Index Builder. If the secondary index does not have entries that point to the deleted partition, the secondary index is not affected and does not need to be rebuilt. If there are no records in the deleted partition, the secondary index does not need to be rebuilt. The secondary index is unaffected by the deletion of the partition.