SQLType
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 .
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 .
The value of this parameter affects the default value of the IncludeRI parameter (for more information, see IncludeRI).
Comments
Log in or register to comment.