Enabling RTL

Enable RTL at the database level.

Prerequisites
Set dsi_bulk_copy and dynamic_sql to off before you enable real-time loading (RTL) replication to Sybase IQ.
Task
  1. To enable and configure RTL at the database level to affect only the specified database, enter:
    alter connection to IQSRVR.iqdb
set dsi_compile_enable to ‘on’
go
  2. Suspend and resume the connection to the replicate Sybase IQ database to enable the change to the connection:
    suspend connection to IQSRVR.iqdb
go
resume connection to IQSRVR.iqdb
go
Parent topic: Scenario for Replication to Sybase IQ