Trying to use IBM InfoSphere CDC to replicate DB2 table data from mainframe to a distributed database.
According to the CDC documentation, SELECT access is required on all source tables.
ACF2 rules indicate SELECT access is allowed on all tables but a few are not behaving as if SELECT access has been granted.
Using the ISPF test facility, it has been verified that SELECT access is in place.
Receiving CDC message:
CHC0143E User xxxxxxx is not authorized to add table yyyyyy.zzzz_aaaa_ZONED_xyz_COST, Diagnostic information (paaAddTableToCatalog; 14,502)
Release : 1.3
Component : CA ACF2 Option for Db2
ACF2 security is not being checked by IBM InfoSphere CDC when setting up a new "subscription".
The ACM exit of CDC is set to check "native" DB2 authorizations and not ACF2.