With version 15.5, Replication Server extends the replicate_minimal_columns parameter to connections in all situations, so that the Data Server Interface (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.
In Replication Server versions earlier than 15.5, you could only use replicate_minimal_columns in warm standby situations.
By default, replicate_minimal_columns is on for all connections. The replicate_minimal_columns setting for a connection overrides replication definitions set with the replicate all columns clause.
The behavior of the current replication environment could change when you set replicate_minimal_columns to on for a connection. Custom function strings at the replicate connection and trigger processes that rely on commands being sent to the replicate, even if no values are changed, could be affected. To restore the original behavior, set replicate_minimal_columns off for the connection.
For example, to enable replicate_minimal_columns for the connection to the pubs2 database in the SYDNEY_DS data server, enter:
alter connection to SYDNEY_DS.pubs2 set replicate_minimal_columns to ‘on’
You can use admin config to display the replicate_minimal_columns setting.