2.188 WARNRATE

Valid For

Replicat

Description

Use the WARNRATE parameter to set a threshold for the number of SQL errors that can be tolerated on any target table before being reported to the process report and to the error log. The errors are reported as a warning. If your environment can tolerate a large number of these errors, increasing WARNRATE helps to minimize the size of those files.

When setting WARNRATE for a coordinated Replicat, take into account that the specified WARNRATE threshold is applied to each thread in the configuration, not as an aggregate threshold for Replicat as a whole. For example, if WARNRATE 100 is specified, it is possible for each thread to return 99 errors without a warning from Replicat.

For Replicat running in an Oracle environment, this parameter is valid for nonintegrated mode only.

Default

100 errors

Syntax

WARNRATE number_of_errors
number_of_errors

The number of SQL errors after which a warning is issued.

Example

WARNRATE 1000