Show TOC

Comment Enablement to Mark Primary Key Column Locate this document in the navigation structure

Add a new configuration setting to enable primary key columns to be marked in the replicate table by column comments.

For some replication modes such as CDC and TRANS_CDC, the replicate tables contain additional columns that form the new primary key of the table. To keep a reference to which columns form the primary key in the primary table, a comment is added to each column.

The comment is stored under the rep.column.pk container configuration setting. Run the ra_get_all_config command to check the current values and look for rep.column.pk in the value list.

The default primary key column comment is PRIMARY_KEY.