Q Replication to native Oracle targets

Software requirements

The following software is required for Q Apply for Oracle:

Source system

• DB2 for z/OS®
• InfoSphere® Data Replication for DB2 for z/OS Version 10.1 and later or InfoSphere Replication Server for z/OS Version 9.7 APAR PK85947 and later

Target system

• AIX® Power® Version 6.1 or 7.1
• InfoSphere Data Replication Version 10.1.3 or later (includes DB2 for Linux, UNIX, and Windows Version 10.1)
• Oracle 10.2g, Oracle 11.1g, or Oracle 11.2g
• Standard Oracle Client or Oracle Instant Client

Restrictions

The following restrictions are in place for this feature:

• Only DB2 for z/OS sources are supported.
• Bidirectional and peer-to-peer replication are not supported.
• Target stored procedures and point-in-time (PIT) target tables are not supported. Only user tables and consistent-change-data tables are supported.
• Automatic loading of target tables is not supported. When you create Q subscriptions you must use the manual load (LOAD_TYPE E in the IBQREP_TARGETS table) or no load options (LOAD_TYPE N).
• The ASNCLP command-line program is not supported. You can use the Replication Center for setup and administrative tasks.
• For the Q Apply term parameter, the value of n is not supported.
• 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.