SQLCODE = -551 (No privileges) in a RC/Query Table-Column(T-C) report for SYSACCEL.SYSACCELERATEDTABLES.

Products

• RC/Query for DB2 for z/OS

Issue/Introduction

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-
LES
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
INFORMATION

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.

Environment

Release: 20.0
Component: RC/Query for Db2 for z/OS

Resolution

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.