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 :
- SYSIBM.SYSTABLES
- SYSIBM.SYSCOLUMNS
Db2/LUW Refresh requires Read access to any Table to be refreshed
- GRANT SELECT on <schema.tablename> TO < sqdata_user>;
- 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:
ALTERTABLE <schema.tablename> DATACAPTURECHANGES;