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

book

Article ID: 106003

calendar_today

Updated On:

Products

CA RC/Migrator CA Endevor SCM Interface DB2 Administration CA RC Compare for DB2 for z/OS CA RC Extract for DB2 for z/OS CA RC/Query CA RC Secure for DB2 for z/OS CA RC Update for DB2 for z/OS

Issue/Introduction

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.

Environment

Release:
Component: RCQ

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.