In addition to controlling which tables are captured, it is also possible to add and remove items to be excluded from capture based on other parameters including: User. The basic syntax varies slightly based on the current state of the configuration and can be can be specified one or more times per command line.
Syntax
Create state:
--exclude-item=<variable>
Modify state:
--auto-exclude-plan=NO | --add-excluded-<item>=<variable> | --remove-excluded-<item>=<variable>Where the item <variable> in the case of UDB can be any one of the following list of optional keywords:
| Item | Variable | Description |
|---|---|---|
| user | User ID | The user-id associated with the transaction or program making UDB data changes. |
| correlation-id | Correlation ID | The Correlation ID of the program / transaction making UDB data changes. |
| plan | Package | If non-blank, this is the Package making UDB data changes. |
Example
Disable the automatic exclusion of the SQData Default plan (SQDDDB2D) to enable capture of updates that are normally excluded to prevent cyclic updates in an Active/Active Replication configuration.
$ sqdconfmodify /home/sqdata/udbcdc1/udbcdc1.cab --auto-excluded-plan=NO
Note:
- The wildcard character "*" can be used as part of the variable associated with any of the exclusion keywords, for example -correlation-id=udbtran*
- As with all modifications made to a Capture configuration file, the following steps must be followed to implement the change:
- Capture should be paused to allow subscribed Engines to consume all previously captured data
- The Capture must then be Stopped
- The changes must be Applied to the capture .CAB file to have the capture agent recognize the updated configuration
- The Capture must be Started