Multi-Path Replication to Sybase IQ

Create multiple connections from Replication Server to the replicate Sybase IQ database to increase replication throughput and performance, and reduce latency and contention.

With multiple connections from an Adaptive Server or Oracle primary database to Replication Server and multiple connections from Replication Server to the replicate Sybase IQ database, you can create end-to-end multiple replication paths.

Database Support

Primary database:
- Adaptive Server 15.7 and later
- Oracle 10g and 11g. See Replication Server Options > Replication Agent Release Bulletin > Product Summary > Product Compatibility.
Replicate database – Sybase IQ version 15.1 and later. See Replication Server Release Bulletin > Product Compatibility > Replication Server Interoperability .

License

Multi-Path Replication™ is licensed as part of the Advanced Services Option. Replication to Sybase IQ using RTL is available in the Real-Time Loading Edition (RTLE). See Replication Server Installation Guide > Planning Your Installation > Obtaining a License.

Creating Alternate Replicate Connections to Sybase IQ
Use create alternate connection with the using profile clause to create an alternate connection from Replication Server to the replicate Sybase IQ database.
Altering or Dropping Alternate Replicate Sybase IQ Connections
Alter or drop default or alternate replicate connections to Sybase IQ by using the alter connection and drop connection commands.
Displaying Replicate Connection Information
Use the replicate parameter with admin show_connections to display information on all replicate connections.
Replication Load Distribution
Use the distribution mode supported by the primary database to distribute the replication load over available replication paths.

Parent topic: Sybase IQ as Replicate Data Server

Related concepts

Heterogeneous Multi-Path Replication

Multi-Path Replication from Oracle to Sybase IQ