In a RC/Query for Db2 for z/OS (RCQ) Table-Column(T-C) report encountering the following error:
DSNT408I SQLCODE = -551, ERROR: xxxxxxx DOES NOT HAVE THE PRIVILEGE TO
PERFORM OPERATION SELECT ON OBJECT SYSACCEL.SYSACCELERATEDTAB-
DSNT418I SQLSTATE = 42501 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXOSC SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -10 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFFF6' X'00000000' X'00000000'
X'FFFFFFFF' X'00000000' X'00000000' SQL DIAGNOSTIC
Checking RACF and do not have native access for SELECT on the table, however it is not clear why would
SELECT on table SYSACCEL.SYSACCELERATEDTABLES be required to display column definitions.
Component: RC/Query for Db2 for z/OS
In a Table-Column(T-C) report, if the Db2 subsystem has the accelerator available, RC/Query will check if the column is eligible for
IDAA acceleration or not. To get this information there is a SELECT statement on SYSACCEL.SYSACCELERATEDTABLES
and the result is displayed in column 'ACCELERATED' within the report.