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

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

6.12.2 How to tune

The table below explains how to tune a Datareplicator. Choose the appropriate method after you have determine what needs to be tuned.

Table 6-24 Tuning methods

Processing performance Elements of tuning Tuning method Recommended level
Transmission performance
  • Transmission interval
  • Size of update information editing buffer
  • Transmission master process's transmission interval
  • Length of update information editing buffer
Adjust the following operand values:
 Medium

  • Interval at which the transmission process reads the extraction information queue file
  • Size of extraction information queue I/O buffer
 Adjust the following operand values:
  • quiosize operand
  • queue_read_wait_interval operand
For details about the quiosize operand, see 5.3 Extraction environment definition. For details about the queue_read_wait_interval operand, see 5.4 Transmission environment definition.		 Low
Import performance SQL performance Do the following at the target HiRDB:
  • When multiple indexes have been defined for a target table
    Delete any unneeded index.
  • When the time required for import processing has increased
    Re-organize the RDAREA storing the target table.
 High

  • Import processing commit interval
  • Import processing commit interval when the transaction-based import method is used
  • Import processing commit interval when the table-based import method is used
  • Maximum number of update SQL statements in an import transaction
 Adjust the following operand values:
  • cmtintvl operand
  • trncmtintvl operand
  • tblcmtintvl operand
  • reflect_trn_max_sqlnum operand
For details, see 5.9 Import environment definition.		 High
COMMIT issuance interval Adjust the commit_wait_time operand. For details, see 5.9 Import environment definition. High
Concurrent execution of import processing Define an import group and apply the table-based import method. For details, see 5.10 Import definition. Medium
Interval at which the import process reads the import information queue file Adjust the ref_wait_interval operand value. For details, see 5.9 Import environment definition. Low

[Contents][Back][Next]

[Trademarks]

All rights reserved. Copyright (C) 2007, 2013, Hitachi, Ltd.