SQLType

For Db2, the SQLType parameter determines which records in your logical log input the High-speed Apply Engine uses to generate and apply SQL statements.

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[LogicalLog]

Abbreviation

None

DBMS

Db2

Required?

No

Valid values

Redo, Undo, or Migrate

Default value

Migrate

Usage

Logical log input that conforms to the published format includes a field named SQLTYPE in the header of each record in the logical log data file. The SQLType parameter causes High-speed Apply Engine to select a different set of records based on the value in this field. High-speed Apply Engine generates SQL statements from the records it selects. For more information about logical log data records, see Logical log files Open link .

Specify one of the following values for the SQLType parameter:

  • Specify Redo to cause High-speed Apply Engine to generate SQL statements from redo records in the logical log input (where the SQLTYPE field is 'R'). A logical log input file does not contain any redo records unless a REDO recovery point was specified when the logical log was generated.

  • Specify Undo to cause High-speed Apply Engine to generate SQL statements from undo records in the logical log input (where the SQLTYPE field is 'U'). If this parameter is UNDO, High-speed Apply Engine:

    • Reverses the statement type of the original data changes (for example, if the original statement was an INSERT, High-speed Apply Engine generates and executes a DELETE statement)

    • Reverses the order of the original data changes. (To accomplish this, High-speed Apply Engine must sort the logical log input. When SQLType is UNDO, High-speed Apply Engine sets the value of the Sort parameter to Yes, regardless of the value in your configuration. For more information, see Sort.)

  • Specify Migrate to cause High-speed Apply Engine to generate SQL statements from undo records in the logical log input (where the SQLTYPE field is 'U'). If this parameter is Migrate, High-speed Apply Engine does not reverse the statement type or the order of the original data changes.

For more information about these values, see Command and syntax reference Open link .

The value of this parameter affects the default value of the IncludeRI parameter (for more information, see IncludeRI).

Related topic


Was this page helpful? Yes No Submitting... Thank you

Comments