1. Oracle GoldenGate Classic Architecture Documentation
  2. Prepare
  3. Prepare Your Database for Oracle GoldenGate Classic Architecture
  4. Db2 z/OS
  5. Understanding What's Supported for DB2 for z/OS
  6. Non-Supported Objects and Operations for DB2 for z/OS

Non-Supported Objects and Operations for DB2 for z/OS

The following objects and operations are not supported by Oracle GoldenGate on DB2 for z/OS:

  • Extraction or replication of DDL operations

  • Clone tables

  • Data manipulation, including compression, that is performed within user-supplied DB2 exit routines, such as:

    • Date and time routines

    • Edit routines (CREATE TABLE EDITPROC )

    • Validation routines (CREATE TABLE VALIDPROC )

  • Replicating with BATCHSQL is not fully functional for DB2 for z/OS. Non-insert operations are not supported so any update or delete operations will cause Replicat to drop temporarily out of BATCHSQL mode. The transactions will stop and errors will occur.