Dynamic SQL Enhancements

Replication Server 15.5 introduces several enhancements to dynamic SQL.

Dynamic SQL enhances performance by allowing the Replication Server Data Server Interface (DSI) module to prepare dynamic SQL statements at the replicate database and to run them repeatedly. See “Dynamic SQL for enhanced Replication Server performance,” in Chapter 4, “Peformance Tuning” in the Replication Server Administration Guide Volume 2.

Optimized Dynamic SQL Statement Execution
Replication Server 15.5 enhances the execution of dynamic SQL statements.
replicate minimal columns clause with Dynamic SQL
In Replication Server 15.5, replication processing does not skip dynamic SQL even if the replicate minimal columns clause is enabled and Replication Server uses replicate minimal columns and dynamic SQL effectively at the same time.
replicate_minimal_columns Extension
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.

Parent topic: Performance Enhancements