A refresh that has been started can be canceled before it has completed however one must consider that all published slices will have already been processed downstream.
Syntax
//*-------------------------------------------
//* Cancel a Refresh from a Db2 source table
//*-------------------------------------------
//CANCEL EXEC PGM=SQDCONF
//SYSOUT DD SYSOUT=*
//SQDPARMS DD *
refresh /home/sqdata/db2cdc/db2cdc.cab
--schema=<name> --table=<name> | --key=<name>
--cancel
/*
Keyword and Parameter Descriptions
| Keyword | Description |
|---|---|
| --schema=<name> |
Schema name, owner, or qualifier of a table. Different databases use different semantics, but a table is usually uniquely identified as S.T where S is referenced here as schema. This parameter cannot be specified with --key. |
| --table=<name> |
A qualified table name in the form of schema.name that identifies the source. This may be used in place of two parameters, --schema and --table. Both cannot be specified. |
| --key=<name> |
Same as --table. |