IncludeRI
For Db2, 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.
Attributes
This parameter has the following attributes:
Attribute | Value |
|---|---|
Section | [LogicalLog] |
Abbreviation | None |
DBMS | Db2 |
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).
Related topic