Enabling RTL

After you have granted the relevant permissions and connected to the replicate Sybase IQ database as described in the earlier sections, 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 to off, Replication Server uses continuous log-order, row- by-row replication mode. For example, set to ‘off’ for an affected table if replicating net row changes causes problems, such as when there is a trigger on the table which requires all the operations on that table to be replicated in log order, and therefore compilation is not allowed

When you set dsi_compile_enable, 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:

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.

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: