When using real-time loading (RTL) replication, INSERT ... LOCATION execution failures can slow down replication to Sybase IQ.
Sybase IQ must connect to Replication Server to retrieve data when Replication Server sends an INSERT ... LOCATION statement to Sybase IQ. If Sybase IQ fails to connect, the INSERT ... LOCATION statements are not executed and RTL fails. After several unsuccessful attempts to replicate using RTL, Replication Server reverts to log-order, row-by-row continuous replication.
Create an entry for the replicate Replication Server in the interfaces file of the replicate Sybase IQ server. This allows Sybase IQ to connect to Replication Server using the user name and password specified in the database connection. The maintenance user must be a valid user in Replication Server with system administrator privileges and whose password matches the password that Replication Server uses to log in to Sybase IQ.