|
Cancel Table Refresh |
Scroll |
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/db2cdc1/DB2CDC1.cab
--schema=<name> --table=<name> | --key=<name>
--cancel
/*
Keyword and Parameter Descriptions
--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.
