Performing a (T) table report in RC/Query for Db2 for z/OS (RCQ) using the (C) column option in an environment where external security
to Db2 is used (in this case Top Secret) failure occurs generating the report with the following message:
TSS7251E Access Denied to DB2TABLE SYSACCEL.SYSACCELERATEDTABLES
Top Secret (or any external security package controlling all access to Db2)
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.
Within the external security package, Grant Select authority for User IDs or their associated secondary Group ID to SYSACCEL.SYSACCELERATEDTABLES.