Enable RTL

After you have granted the relevant permissions and connected to the replicate Sybase IQ database, you can enable and configure RTL for replication to Sybase IQ.

Use dsi_compile_enable to enable RTL for the connection. If you set dsi_compile_enable off, Replication Server uses continuous log-order, row-by-row replication mode. For example, set dsi_compile_enable off for an affected table if replicating net-row changes causes problems, such as when there is a trigger on the table that requires all operations on the table to be replicated in log order, and therefore compilation is not allowed.

Note: When you set dsi_compile_enable on, Replication Server disables dsi_cmd_prefetch and dsi_num_large_xact_threads.

To enable and configure RTL at the database level to affect only the specified database, enter:

alter connection to IQ_data_server.iq_database
set dsi_compile_enable to ‘on’
go

You can also enable and configure RTL at the server or table levels.

After you execute dsi_compile_enable, suspend and resume the connection to the replicate Sybase IQ database.