RC/Query report encounters message TSS7251E for SYSACCEL.SYSACCELERATEDTABLES
search cancel

RC/Query report encounters message TSS7251E for SYSACCEL.SYSACCELERATEDTABLES

book

Article ID: 36115

calendar_today

Updated On:

Products

RC/Query for DB2 for z/OS

Issue/Introduction

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

Environment

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.