How to avoid a SQLCODE = -551 (No privileges) in a Table-Column(T-C) report?.
Article ID: 106003
CA RC Compare for DB2 for z/OS
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.
Release: Component: RCQ
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.