Known issues and limitations for Data Gate

Limitations

Source and target limitations

You can use Data Gate to synchronize a single data source (Db2 for z/OS subsystem or data sharing group) with exactly one target database instance (Db2 or Db2 Warehouse)

• To connect multiple data sources and target database instances, you must provision multiple Data Gate instances, that is, one for each data source/target combination.
• You can connect multiple Data Gate instances to the same data source in order to implement high availability (HA) and disaster recovery (DR) architectures.
• You can use a single database instance as the target of exactly one Data Gate instance. That is, you cannot make one and the same database instance the target of multiple instances.

Columns with a data type of XML or LOB are not supported

Columns with a data type of XML or LOB are not supported. A Db2 for z/OS table with unsupported columns can be added into Data Gate, then be loaded and synchronized. But the values of the columns with these unsupported types will therefore be missing in the target table.

Table load and synchronization conditions

A table cannot be loaded and synchronized if one or more of the following conditions apply:

• A mask has been defined for the table by means of a CREATE MASK statement.
• A permission has been granted on a table column by means of a CREATE PERMISSION statement.
• One or more table columns have a security label.
• One or more table columns use a field procedure (FIELDPROC).

Important: If you try to load and synchronize a table that satisfies one of these conditions, the Data Gate server on Cloud Pak for Data stops and then restarts automatically after an outage period of five to ten minutes. Hence you need not do anything to recover from the server shutdown.

Indexes and access control lists not inherited

Indexes and access control lists defined on the Db2 for z/OS source tables will not be inherited by the Data Gate target tables.