IncludeRI

The IncludeRI parameter specifies whether the High-speed Apply Engine uses the referential integrity (RI) records in the logical log when it processes the apply request. If you need to maintain referential integrity for the target tables, set this parameter to Yes.

Related topic

LogicalLog-parameters

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[LogicalLog]

Abbreviation

None

Required?

No

Valid values

Yes or No

Default value

If the value of the SQLType parameter is Undo, the default value of IncludeRI is Yes.

If the value of the SQLType parameter is Redo or Migrate, the default value of IncludeRI is No.

Usage

Select one of the following values:

  • Specify Yes when the source tables are defined with RI and the target tables are not defined with RI.

    To maintain RI, High-speed Apply Engine must sort the logical log file before it processes it. If the value of IncludeRI is Yes, High-speed Apply Engine sets the Sort parameter to Yes, overriding the value set in the configuration if necessary. For more information, see Sort.

  • Specify No when the source tables are defined with RI and the target tables are defined with identical RI relationships.

The default value of this parameter depends on the value of the SQLType parameter (for more information, see SQLType).

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*