Modifying the number of root anchor points in a PHDAM partition

If a PHDAM partition has many roots that randomize to the same root anchor point (RAP), lock contention problems that negatively impact performance can occur. To remedy this problem, you can increase the number of RAPs in the partition.

The modify the number of RAPs in a PHDAM partition:

Procedure

  1. Take the partition offline by issuing either the /DBRECOVERY DB partition_name command or the UPDATE DB NAME(partition_name) STOP(ACCESS) command.
  2. Unload the data from the partition.
  3. Change the number of RAPs in the partition by using either the HALDB Partition Definition utility (%DFSHALDB) or DBRC commands.
  4. Initialize the partition.
  5. Reload the partition.
  6. Take an image copy of the data sets for the partition.
  7. Make the partition available by issuing either the /START DB partition_name command or the UPDATE DB NAME(partition_name) START(ACCESS) command.