Problem:
Performing a (T) table report in RC/Query using the (C) column option in an environment where external security to DB2 is used (in this case CA Top Secret) failure occurs generating the report with the following message:
TSS7251E Access Denied to DB2TABLE SYSACCEL.SYSACCELERATEDTABLES
Environment:
CA Top Secret (or any external security package controlling all access to DB2)
Cause:
As of r19 in RC/Query, eligibility functionality has been added to check if a column is eligible for use with the IDAA Accelerator. The Table/Column report will now include the Accelerator column. To obtain this information RC/Query selects from SYSACCEL.SYSACCELERATEDTABLES, thus the need for the external security package to allow Select access to this catalog table for the associated ID running the RC/Query report.
Resolution:
Within the external security package, Grant Select authority for User IDs or their associated secondary Group ID to SYSACCEL.SYSACCELERATEDTABLES.