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

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

5.2.3 Explanation of the operands

Guidelines for specifying the int_trc_lvl operand:
We recommend that you specify the int_trc_lvl operand as follows:
  1. Production run
    For actual operations, we recommend that you omit the int_trc_lvl operand. If you cannot obtain reasonable performance with specification of the operand omitted, specify collection of activity trace information temporarily so that you can evaluate performance. In this case, specify p1 or p2 in the first parameter of the int_trc_lvl operand, nc in the second parameter, and the int_trc_getl or int_trc_getv operand in the specific facility (the one exhibiting low performance). If you specify p2 in the first parameter of the int_trc_lvl operand, specify a sufficient value in the int_trc_filesz operand.
  2. Test run
    At the test stage, we recommend that you specify p1 in the first parameter of the int_trc_lvl operand and omit the second parameter. This enables you to execute the hdstrcedit command to view activity trace information in the event of a problem with performance. Use the command's execution results to tune the HiRDB table definitions and the number of import groups.
    If you need more detailed information (such as the unit price of SQL executions), change the second parameter to p2 in the int_trc_lvl operand. When you specify p2, specify a sufficient value in the int_trc_filesz operand (at least 1MB).

This operand is applicable when the smt_sendintvl operand is specified.