How Shareplex repairs a partitioned table
When running repair for a partitioned table, the default behavior of the repair process is to repair rows by using INSERTs and DELETEs only.
Repairs requiring UPDATEs are converted to a DELETE followed by an INSERT to prevent errors should an UPDATE cause a row to change partitions and row movement is not enabled for the table.
To change the repair behavior so that SharePlex repairs partitioned tables by using INSERTs, UPDATEs, and DELETEs as appropriate, set SP_DEQ_PART_TABLE_UPDATE parameter to 1.
sp_ctrl> set param SP_DEQ_PART_TABLE_UPDATE 1
SP_DEQ_PART_TABLE_UPDATE
This parameter affects the repair behavior of the compare table and compare config commands when they are issued for partitioned target tables.
• When this parameter is set to the default of 0, partitioned target tables are repaired using INSERTs and DELETEs only. Repairs requiring UPDATEs are converted to a
DELETE followed by an INSERT to prevent errors when an UPDATE could cause a row to change partitions and row movement is not enabled for the table.
• When this parameter is set to 1, partitioned tables are repaired using INSERTs, UPDATEs, and DELETEs as appropriate. Use this mode only when you know
UPDATEs will not result in a row changing partitions in the target table or when row movement is enabled for the target table.
Set this parameter on the target system.
Default: 0 (do not repair with UPDATEs)SP_DEQ_PART_TABLE_UPDATE
This parameter affects the repair behavior of the compare table and compare config
commands when they are issued for partitioned target tables.
• When this parameter is set to the default of 0, partitioned target tables are repaired
using INSERTs and DELETEs only. Repairs requiring UPDATEs are converted to a
DELETE followed by an INSERT to prevent errors when an UPDATE could cause a
row to change partitions and row movement is not enabled for the table.
• When this parameter is set to 1, partitioned tables are repaired using INSERTs,
UPDATEs, and DELETEs as appropriate. Use this mode only when you know
UPDATEs will not result in a row changing partitions in the target table or when row
movement is enabled for the target table.
Set this parameter on the target system.
Default: 0 (do not repair with UPDATEs)
