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