Comparison and Column Options

Be familiar with the comparison and column options provided for creating a row job.

Comparison Options
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. `row_compare` – compares all table rows. `key_compare` – compares the primary key columns. `row_count` – compress row count. 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: Generate a reconciliation script Perform automatic reconciliation Generate a detailed report 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. `database_hash` – use the hash function provided by the database. `agent_hash` – use the hash function provided by Replication Server Data Assurance Option. Note: Set the hash type comparison option to `agent_hash` for heterogeneous comparison. The `database_hash` comparison option is used only for SAP ASE-to-SAP ASE 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. `never` – no recompare. `wait_and_retry` – run recompare based on RETRY_MAX and RETRY_DELAY_SEC settings. Default value: never.
Retry delay (seconds):	Specifies the number of seconds delay for each recomparison. Valid values: 0 to 86400. Default value: 10.

Column Comparison Option
Column Option	Value
Compare mode:	Specifies for how each column is compared. column_hash – compares using column hash value. row_hash – compares all columns with this option together with a whole hash value. literal – compares using column literal value.