Connect CDC SQData

The Db2/LUW (UDB) Log Reader Capture requires special user privileges and preparation to access and read the Db2 Recovery Logs using the Db2/LUW (UDB) Instrumentation Facility Interface (IFI) calls. Version 4 of Connect CDC SQData also requires some system tables to be captured to support Schema Evolution.

The following GRANTS are required:

•GRANT DBADM  ON DATABASE  TO < sqdata_user>;

•GRANT EXECUTE ON PACKAGE sqdddb2d   TO < sqdata_user>;

•GRANT SELECT ON SYSIBM.SYSTABLES  TO < sqdata_user>;

•GRANT SELECT  ON SYSIBM.SYSCOLUMNS  TO < sqdata_user>;

•GRANT SELECT ON SYSIBM.SYSDATAPARTITIONS  TO < sqdata_user>;

Db2 Reorg and Load procedures may need to be updated:

•KEEPDICTIONARY=YES parameter must be used by all Db2 REORG and LOAD Utilities. If the CDC process is run asynchronously, for some reason gets behind or is configured to recapture older logs, the proper Compression Dictionary must  be available.

Schema Evolution Requires DATA CAPTURE CHANGES on Two (2) Catalog Tables:

1.SYSIBM.SYSTABLES

2.SYSIBM.SYSCOLUMNS

Db2/LUW Refresh requires Read access to any Table to be refreshed

•GRANT SELECT on <schema.tablename> TO < sqdata_user>;   See Db2/LUW Capture Based Refresh.

Notes:

•A common database request module (DBRM)sqddd2b.bnd ships as part of the product distribution and a Bind must be performed on the Package:
 
bind <SQDATA_DIR>/bnd/ sqdddb2d.bnd grant public

•Each Db2/LUW (UDB) table to be captured also requires:
 
ALTER TABLE <schema.tablename> DATA CAPTURE CHANGES;