Connect CDC is designed for distributing SQL tabular data or user changes to that data. If the data can be accessed through an SQL entity that is represented in the SQL system catalog, it should be distributable. The table below lists the table types are eligible for distribution as DB2/400 source or target tables.
|
DB2/400 object |
Connect CDC Director category |
Copy or Replication source |
Copy or Replication target |
|---|---|---|---|
|
Table (SQL) |
Table |
Both |
Both |
|
Physical file |
Table |
Both |
Both |
|
View |
View |
Copy |
Both(only if updateable) |
|
Logical file |
View |
Copy |
Both(only if updateable) |
|
Alias for table |
Alias |
Both |
Both |
|
Alias for multi-member file member |
Alias |
Both |
Both |
|
a The checkbox label you select in Connect CDC Director when you retrieve that object’s data from the DB2 system catalog into your Connect CDC model. |