You can use this parameter to specify actions that the CDC Replication Engine for Db2® for z/OS® Remote Source takes when it
detects a DDL operation at the source database.
This property can be set, displayed, or cleared per-subscription-per-table, per-subscription, or
per-table. It can be set at the instance level by using Management Console or CHCCLP, but can only
be set at the subscription or table level by using the dmset utility.
For the RESILIENT option, you can only set a per-subscription-per-table, per-subscription, or
per-table value if the instance-level value is RESILIENT. You cannot set the instance-level value to
any value that is not RESILIENT if there is a per-subscription-per-table, per-subscription, or
per-table value that is set to RESILIENT. This is because you can only have RESILIENT behavior at
the subscription or table level if it is enabled at the instance level.
- Applies to
- Source datastores
- Values
- Set this parameter to one of the following values:
-
- IGNORE
- The DDL is ignored. The subscription does not stop. Ignoring the DDL could lead to subsequent
DML parsing errors if the DDL change was significant. This action would lead to the subscription
stopping.
- STOP
- The subscription stops. Before restarting the subscription, you must re-add the table
definition. If a column was dropped or altered, or if the target table is altered to reflect the
change, you must re-describe the table. If the column was dropped, or if the target table is altered
to reflect the change, you must reassign.
- RESILIENT
- The subscription does not stop. CDC Replication automatically updates
the table definition in the metadata to reflect the new table structure. If the column was dropped
or altered, the table is automatically re-described. If the column was dropped, CDC Replication automatically re-assigns
the table. Any added column is left unmapped and not replicated to the target. Any dropped column
has the target database default value stored in that column for each subsequent insert that is
replicated. Any altered column still has the original data type on the target. If the source value
becomes too large to fit, it is truncated. This option should only be specified at the subscription
or table levels if the instance level setting is RESILIENT. If not, a warning is issued when the DDL
is processed and the action taken is STOP.
- Default Setting
- STOP