How to avoid a SQLCODE = -551 (No privileges) in a Table-Column(T-C) report?.

Document ID : KB000106003
Last Modified Date : 11/07/2018
Show Technical Document Details
Issue:
In a Table-Column(T-C) report for SYSACCEL.SYSACCELERATEDTABLES table got the following error.
 
DSNT408I SQLCODE = -551, ERROR: IH88403 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 in RACF and yes indeed we do not have natively access for SELECT on the table, however it is not clear why would SELECT on the table be used to display column definitions.
Resolution:
In 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 SELECTstatement on SYSACCEL.SYSACCELERATEDTABLES and the result is displayed in column 'ACCELERATED' in the report.