|
Disable Table Refresh |
Scroll |
As noted above, all engines configured to received CDC data for a table will receive the published unit-of-work. To prevent a specific apply engine from receiving a table refresh unit-of-work, sqdconf can be used to block or un-block the refresh from that engine.
Syntax
//*-------------------------------------------
//* Block Table Refresh from an Apply Engine
//*-------------------------------------------
//BLOCK EXEC PGM=SQDCONF
//SYSOUT DD SYSOUT=*
//SQDPARMS DD *
conf modify <cab_file_name>
[--block-refresh | --allow-refresh --target=<engine_name>]
Keyword and Parameter Descriptions
<cab_file_name> - Must be specified and must match the name specified in the previous create command.
[--block-refresh | --allow-refresh --target=<engine_name>] - Db2 only. Block or Un-Block the the data from a capture based refresh from being published to a specific target subscription (Engine)
Example 1
Block the SQDATA.EMP table refresh from being published to DB2TOORA using JCL similar to this:
//*-----------------------------------------------
//*- Block Table Refresh from an Apply Engine
//*-----------------------------------------------
//BLOCK EXEC PGM=SQDCONF
//SYSOUT DD SYSOUT=*
//SQDPARMS DD *
modify /home/sqdata/db2cdc1/DB2CDC1.cab
--block-refresh --target=DB2TOORA
/*
Example 2
Un-Block refreshes published to DB2TOORA using JCL similar to this:
//*-----------------------------------------------
//*- Un-Block Table Refresh from an Apply Engine
//*-----------------------------------------------
//UNBLOCK EXEC PGM=SQDCONF
//SYSOUT DD SYSOUT=*
//SQDPARMS DD *
modify /home/sqdata/db2cdc1/DB2CDC1.cab
--allow-refresh --target=DB2TOORA
/*
