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.

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

Remember: You must set dsi_bulk_copy and dynamic_sql to off before you enable real-time loading (RTL) replication to Sybase IQ.

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.

Server level – affects all database connections to Replication Server:
```
configure replication server
set dsi_compile_enable to ‘on’
```
Table level – affects only the replicate tables you specify. If you specify a parameter at both the table level and database level, the table-level parameter takes precedence over the database-level parameter. If you do not specify a table-level parameter, the setting for the parameter applies at the database level. To set a parameter for a table, use alter connection and the for replicate table named clause, for example:
```
alter connection to IQ_data_server.iq_database
for replicate table named dbo.table_name
set dsi_compile_enable to ‘on’
```
Using the for replicate table name clause alters connection configuration at the table level. The configuration changes apply to replicate data from all the subscriptions and all the replication definitions of the tables you specify.

Note: For table-level configuration, you can use only alter connection, as Replication Server does not support the for clause with create connection.

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