You can remove an allocation hint using the alter connection or alter route command with the set disk_affinity to 'off' parameter. For example:
alter connection to TOKYO_DS.db1 set disk_affinity to 'P1' to 'off'
This command deletes the allocation hint for P1 from the rs_diskaffinity table.
You can remove a partition from Replication Server using the drop partition command. If the partition you are dropping has one or more allocation hints in the rs_diskaffinity table, Replication Server marks the allocation hints for deletion, but does not delete them until all data stored on the partition has been successfully delivered and the partition has been dropped.
