You can use this parameter to specify the action that CDC Replication takes when a
decompression error occurs while reading a log record and the error is not resolved by rereading the
log record
This property can be set, displayed, or cleared at the instance level through Management Console,
CHCCLP, or the dmset utility. Using the dmset utility, you can set, clear, or display a value for
this property that is per-subscription-per-table, per-subscription, or per-table. Use the dmset
-s option to specify a subscription name and the -t option to
specify a schema.table name. If multiple values have been specified for the property, the order of
precedence is in the order given above.
- Applies to
- Source datastores
- Values
- Set this parameter to one of the following values:
-
- STOP
- Stops the mirroring subscription at the point in the Db2 log where the decompression error
occurred. You should resynchronize the affected source and target tables either by performing a
refresh or taking action outside of CDC Replication before resuming
replication. If you do not, the subscription will probably stop again when the log record that got
the decompression error is seen again. This is the default.
- REFRESH
- Flags the affected table for refresh then stops the mirroring subscription. The subscription
automatically resumes if the persistent subscription feature is enabled. When the subscription
starts again, the flagged table is refreshed before mirroring resumes. The subscription should not
see the decompression error again because the log record that got the decompression error is no
longer needed.
- DFFRFRSH
- Flags the affected table for a differential refresh then stops the mirroring subscription. The
subscription automatically resumes if the persistent subscription feature is enabled. When the
subscription starts again, the flagged table is differentially refreshed before mirroring resumes.
The subscription should not see the decompression error again because the log record that got the
decompression error is no longer needed.
- IDLE
- Suspends the mirroring subscription, marks the affected table as inactive (parked), and resumes
mirroring if at least one table is still active. If all the tables have become inactive then it
stops the subscription. The parked table must be resynchronized (refreshed) to make the table active
again.
- IGNORE
- Mirroring of the affected subscription is not affected; no action is taken other than issuing a
notification event. The operation that corresponds to the log record that got the decompression
error is lost.
- Default Setting
- STOP