Binding the Apply program packages for Sybase sources

If you are replicating from a Sybase data source, you need to manually bind the Apply program packages to specify an isolation level of cursor stability (CS).

About this task

The Sybase wrapper that SQL Replication uses to connect to a Sybase data source requires an isolation level of CS. If you replication from Sybase without manually binding the Apply packages, you will receive a SQL1822N error.

Procedure

To manually bind Apply packages for Sybase sources:

  1. Connect to the Sybase source database, the Apply control server, and the target database.
  2. Set the isolation level to CS by using the following command: 
    db2 bind ~/sqllib/bnd/@applyur.lst isolation cs
db2 bind ~/sqllib/bnd/@applycs.lst isolation cs