What you need to know

Table and column names

• If the suppress_col_names parameter is set to Y, column names you specify in replication definitions must appear in the same order that they appear in your DB2 tables.

• The level of case-sensitivity for table and column names is determined by the LTL_table_col_case parameter.

Replication Server replicate minimal columns option

Replicates only the columns needed to perform update or delete operations at replicate databases.

Use the replicate minimal columns option only with replication definitions that use the default function strings for the rs_update and rs_delete functions.

If you specify replicate minimal columns for a replication definition, you cannot create a subscription using the nonatomic bulk materialization method because you cannot use the set autocorrection on option for the replication definition.