on_utility_action
This system parameter specifies the action that the CDC Replication Engine for Db2® for z/OS® Remote Source takes when it detects that a Db2 utility was run.
You set, clear, and display this parameter by using the dmset utility. You can specify a value for the parameter that is per-subscription-per-table, per-subscription, and per-table. If multiple values are specified, precedence is in this same order.
- 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 utility action 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 stops again when the utility action 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 was enabled. When the subscription starts again, the flagged table is refreshed before mirroring resumes.
- DFFRFRSH
- Flags the affected table for a differential refresh then stops the mirroring subscription. The subscription automatically resumes if the persistent subscription feature was enabled. When the subscription starts again, the flagged table is differentially refreshed before mirroring resumes.
- 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 of the tables are inactive, the subscription stops. The parked table must be resynchronized (refreshed) to make the table active again.
- IGNORE
- No action is taken and a notification event is issued. Mirroring of the subscription is not affected.
- Default setting
- STOP