Be familiar with the comparison and column options provided for creating a row job.
Field |
Description |
---|---|
Abort condition (rows): |
Aborts row comparison if the difference count exceeds the specified value. Valid values: 1 to 9223372036854775807. Default value:1000. |
Abort row count mismatch: |
Determines whether to abort row comparison if table row counts do not match. Valid values: true or false. Default value: false. |
Auto reconciliation: |
Indicates whether to automatically apply the reconciliation script. Valid values: true or false. Default value: false. Note: To enable AUTO_RECONCILE, set
CREATE_COL_LOG to true.
|
Compare mode: |
Specifies the row comparison mode.
Default value: row_compare. |
Compress row data: |
Compresses the row data between the agent and
the server. Valid values: true or false. Default value: false. |
Create column log: |
Generates a column differences log, which lists all missing,
orphaned, and inconsistent row values (keys and columns).
Create a column log if you want to:
Valid values: true or false. Default value: false. |
Create reconciliation script: |
Generates a reconciliation script. To use this parameter, you must also set CREATE_COL_LOG to true. Valid values: true or false. Default value: false. |
Enable row count: |
Determines whether or not to count source and
target table rows before they are compared. DA server uses the
row count to estimate the comparison progress and end
time. Note: DA server counts rows if
COMPARE_MODE is row_count. Use
ENABLE_ROW_COUNT only if
COMPARE_MODE is a value other than
row_count.
Valid values: true or false. Default value: true. |
External sort: |
Sorts rows on the agent, thereby reducing the
impact of processing the ORDER BY clause in
the databases. Valid values: true or false. Default value: false. |
Hash type: |
Specifies the hash type for the comparison.
Note: Set the hash type comparison option to
agent_hash for heterogeneous
comparison. The database_hash
comparison option is used only for Adaptive
Server-to-Adaptive Server comparisons.
|
Maximum retry: |
Specifies the total number of recomparison for rows that have differences resulting from a previous comparison. Valid values: 0 to 100. Default value: 3. |
Partitions: |
Specifies the number of partitions for a table.
Note: This
number of partitions needs to be greater than 0 and
cannot be set higher than the maximum value of
1024.
Default value: 1 |
Retry option: |
Specifies the retry option.
Default value: never. |
Retry delay (seconds): |
Specifies the number of seconds delay for each recomparison. Valid values: 0 to 86400. Default value: 10. |
Column Option | Value |
---|---|
Compare mode: |
Specifies for how each column is compared.
|