Removing DATA CAPTURE CHANGES from non-replicated tables

You can run a script to remove the DATA CAPTURE CHANGES attribute from tables at the source database that are not being replicated.

Procedure

Run the script at the source Db2®. The script alters non-replicated tables to set DATA CAPTURE NONE so that no replication-related information is added to the Db2 recovery log when changes occur at the tables.

db2 connect to bludb
echo "db2 connect to bludb" > dcc-off.sh
db2 -x "select rtrim(TABSCHEMA) || '.' || rtrim(TABNAME) from syscat.tables where TABSCHEMA!='QASN' and DATACAPTURE!='N' and (tabschema, TABNAME) not in (select source_owner, source_name from qasn.ibmqrep_subs) order by 1 with ur"
do
echo "db2 \"ALTER TABLE $tabname DATA CAPTURE NONE\";" >> dcc-off.sh
done
chmod +x dcc-off.sh