17.5.7 Types of transfer methods
(1) Key range transfer
- KEY RANGE
- This method selects the destination servers on the basis of key ranges.
![[Figure]](figure/zu170070.gif)
(2) Hash transfer
- HASH
- This method selects the destination servers by hashing.
![[Figure]](figure/zu170080.gif)
(3) One-to-one transfer
- 1 TO 1
- This method selects the destination server that has a one-to-one relationship with the server at the origin.
![[Figure]](figure/zu170090.gif)
(4) Matrix partitioning transfer
- MULTIDIM
- This transfer method determines the target server using all partitioning keys of a matrix-partitioned table, including hash partitioning.
![[Figure]](figure/zu170091.gif)
(5) Broadcast transfer
- BROADCAST
- This method copies the data to be transferred and sends it to all servers at the destination.
![[Figure]](figure/zu170100.gif)
(6) Unicast transfer
- UNICAST
- This method transfers data from the origin to a single destination server. The utility displays BROADCAST except for the Join Type section in the join processing information.
![[Figure]](figure/zu170102.gif)
(7) Partial key range broadcast transfer
- KEY RANGE PARTIAL BROADCAST
- This method uses partial key ranges of a matrix-partitioned (boundary values) table to narrow down the destination servers, copies the origin data, and then sends it to all the resulting destination servers.
![[Figure]](figure/zu170101.gif)
(8) Partial broadcast transfer
- PARTIAL BROADCAST
- This method uses part of the partitioning keys of a matrix-partitioned table including hash partitioning to narrow down the destination servers, copies the origin data, and then sends it to all the resulting destination servers.
![[Figure]](figure/zu170103.gif)