Using replicate minimal columns with Dynamic SQL

Replication processing does not skip Dynamic SQL even if you enable the replicate minimal columns clause and Replication Server uses replicate minimal columns and Dynamic SQL effectively at the same time.

In addition to warm standby environments, you can use the replicate_minimal_columns parameter with physical connections in all situations, so that DSI can use the parameter to determine whether to use minimal columns when there is no replication definition, or when the replication definition does not contain the replicate minimal columns clause.

For example, to enable replicate_minimal_columns for the connection to the pubs2 database in the SYDNEY_DS data server:

alter connection to SYDNEY_DS.pubs2
set replicate_minimal_columns to ‘on’

You can use admin config to display replicate_minimal_columns configuration information for physical connections.

NoteWhen you set dsi_compile_enable to ‘on’, Replication Server ignores what you set for replicate_minimal_columns.