Dynamic SQL for Enhanced Replication Server Performance

Dynamic SQL in Replication Server enhances replication performance by allowing Replication Server Data Server Interface (DSI) to prepare dynamic SQL statements at the target user database and to execute them repeatedly.

Instead of sending SQL language commands to the target database, only the literals are sent on each execution, thereby eliminating the overheads brought by SQL statement syntax checks and optimized query plan builds. In addition, DSI optimizes dynamic SQL statements by generating the language command only when the dynamic SQL command fails, and generating the prepared statement only once when the prepared statement is used for the first time.

• Dynamic SQL Configuration Parameters
  Use the dynamic SQL configuration parameters to enable and tune dynamic SQL.
• Set up the Configuration Parameters to Use Dynamic SQL
  You can enable or configure dynamic SQL at the server or database connection level.
• Table-Level Dynamic SQL Control
  create replication definition and alter replication definition allow you to control the application of dynamic SQL on each table through replication definitions.
• replicate minimal columns Clause and Dynamic SQL
  Replication processing uses dynamic SQL when the replication definition contains replicate minimal columns or, when you set replicate_minimal_columns on for a connection.
• Limitations for Dynamic SQL
  There are several limitations to be aware of when you use dynamic SQL.