HiRDB Datareplicator Version 8 Description, User's Guide and Operator's Guide

[Contents][Glossary][Index][Back][Next]

3.3.4 Import method for the multi-FES facility

HiRDB's multi-FES facility is used to distribute the workload and improve throughput by defining multiple front-end servers; it is appropriate in a HiRDB/Parallel Server when throughput is poor because SQL processing has become concentrated at a single front-end server.

When you use the table-based import method, the target Datareplicator can improve throughput by supporting the multi-FES facility. With the table-based partitioning method, you assign a target front-end server for each import group; with the key range-based partitioning method, you assign a target front-end server for each key range. For details about the definitions required to implement the multi-FES facility, see 5.10 Import definition.

How to improve the efficiency of communication between HiRDB servers using the hash partitioning method
The hash partitioning method enables you to set the front-end server to be used to process import data for each partition. This helps to distribute the workload among the front-end servers, and if the front-end server and the back-end server containing the RDAREA are on the same server, it can also reduce the overhead associated with communication between the front-end server and back-end server.