Replicate the Minimal Set of Columns

To enhance replication system performance, specify replicate minimal columns in create replication definition. This clause lets you send only those columns that are required for delete and update operations to replicate databases.

Normally, Replication Server sends all the columns in each row when applying updates and deletes, as well as inserts, in each replicate database. Replication Server normally sends maximum columns to the standby database—if replication definitions are not used for the table or the replication definitions are not used for the standby connection.

A destination Replication Server uses the primary key columns in constructing the data server commands that it applies to the replicate or the standby database.

create replication definition publishers
with primary at TOKYO_DS.pubs2
(pub_id char(4), pub_name varchar(40),
city varchar(20), state char(2))
primary key (pub_id)
replicate minimal columns

• Change Minimal Columns Setting
  Use alter replication definition to change an existing replication definition to replicate only the minimal set of columns or to replicate all columns.
• Minimal Columns and rs_update and rs_delete Function Strings
  If you specify replicate minimal columns and need to create non-default rs_update and rs_delete function strings, use the rs_default_fs function string variable to represent the default function string behavior.
• Minimal Columns and Autocorrection
  If you specify replicate minimal columns, you cannot also specify autocorrection, which corrects discrepancies that may occur during materialization by converting each update or insert operation into a delete followed by an insert.