17.5.8 Types of transfer methods

Organization of this subsection
(1) Key range transfer
(2) Hash transfer
(3) One-to-one transfer
(4) Matrix partitioning transfer
(5) Broadcast transfer
(6) Unicast transfer
(7) Partial key range broadcast transfer
(8) Partial broadcast transfer

(1) Key range transfer

KEY RANGE
This method selects the destination servers on the basis of key ranges.
[Figure]

(2) Hash transfer

HASH
This method selects the destination servers by hashing.
[Figure]

(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]

(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]

(5) Broadcast transfer

BROADCAST
This method copies the data to be transferred and sends it to all servers at the destination.
[Figure]

(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]

(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]

(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]