UTILS BLOCK FOR CDC field (UTILS_BLOCK_FOR_CDC subsystem parameter)
The UTILS_BLOCK_FOR_CDC subsystem parameter specifies whether to block certain Db2 Utilities for tables with replication enabled (with the DATA CAPTURE CHANGES attribute) or table spaces that contain such tables.
| Acceptable values: | NO, YES |
|---|---|
| Default: | NO |
| Update: | option 34 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM UTILS_BLOCK_FOR_CDC |
| Data sharing scope: | Member |
| Online changeable: | Yes |
- NO
-
Specifies that Db2 utilities can update replicated tables or table spaces with replication enabled.
- YES
- Specifies that the following Db2 utilities are blocked from updating replicated tables or table spaces with replication enabled:
- CHECK DATA with DELETE YES LOG NO
- LOAD with SHRLEVEL NONE or REFERENCE
- RECOVER with TOLOGPOINT, TORBA, TOCOPY, TOLASTCOPY, or TOLASTFULLCOPY
- REORG TABLESPACE with DISCARD
- REPAIR with LOCATE DELETE
