Q Replication to native Oracle targets

You can use Q Replication to replicate data to an Oracle target without the need for federation. The program that applies data to the native Oracle target is called Q Apply for Oracle.

Q Apply for Oracle runs as an Oracle database application, using Oracle client APIs and without the need for federation or Oracle replication products. Q Apply for Oracle provides the same set of functions that are available for Db2® target databases.

Software requirements

The following software is required for Q Apply for Oracle:

Source system
z/OS®
InfoSphere® Data Replication for Db2 for z/OS Version 10.1 and later
Linux®, UNIX, Windows
InfoSphere Data Replication Version 10.2.1 or later
Target system
  • All Linux, UNIX, and Windows systems that are supported by Q Replication
  • InfoSphere Data Replication Version 10.2.1 or later
  • Oracle 10.2g, Oracle 11.1g, Oracle 11.2g, Oracle 12c, or Oracle 12c R2
  • Standard Oracle Client or Oracle Instant Client

Restrictions

The following restrictions are in place for this feature:

  • Bidirectional and peer-to-peer replication are not supported.
  • Some additional configuration is required to support the Q Apply term=n parameter to allow automatic rerouting with Oracle real application clusters (RAC). For details, see the section on term in Descriptions of asnoqapp parameters.
  • Schema-level subscriptions are not supported. The supported DDL replication functions are the use of ADDCOL signals to add new columns from the source table to Q subscriptions and target tables, and automatic replication of ALTER COLUMN SET DATA TYPE operations.
  • Default values in source table columns must be valid for Oracle because they are applied "as is" on the target. If you specify a default value that includes a DB2-specific SQL expression, an error will occur on the target. You must ensure that column default values in Db2 are valid default value expressions in Oracle.
  • Existing Q subscriptions cannot be used with a native Oracle target. You must create new Q subscriptions.
  • For Exadata targets, Q Apply for Oracle must be remote from the actual instances in the Exadata cluster. Native Oracle apply is not supported for the Oracle Linux OS and cannot be run on an Exadata system.