Support for All Table Columns as Compareset Key Columns

You can now create comparesets using all non-large object (LOB) columns as compareset keys, when a unique row key column does not exist in the table.

In earlier versions of the SAP Replication Server Data Assurance Option, create compareset and create compareset foreach commands with map all parameter required primary key, identity, or uniquely indexed columns in the source table to create comparesets. In the version 15.7.1 SP200, when a table does not contain a primary key, identity or uniquely indexed column, the map all parameter uses all non-LOB columns as the compareset key.

If you do not want to create comparesets with non-LOB columns as the compareset key, set:

strict_key parameter to true in the create compareset command
column_strict_keys parameter to true in the create compareset foreach command

When all non-LOB columns are used as compareset keys, the keys might not be unique. To abort a comparison when duplicate row keys are detected, use the abort_dupe_key_immediate parameter in the create job and the alter jobcommand.

For command syntax and parameter descriptions, see the SAP Replication Server Data Assurance Option Users Guide.