Upgraded to release r20 of the Database Management Solutions for Db2. An RC/Query for Db2 for z/OS (RCQ) user receives a -551 SQL error.
The problem occurs when issuing a "C" or "PK" command on a table line, in order to generate a report of the columns or packages of a table.
-551 auth-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation ON OBJECT object-name
where object-name is either SYSACCELERATEDTABLES or SYSACCELERATEDPACKAGES.
This problem did not occur on earlier releases of RC/Query.
The IBM DB2 Analytics Accelerator tables require that you grant users the SELECT privilege.
To prevent -551 errors when generating table reports in RC/Query for Db2 for z/OS, grant the user ID or secondary group ID SELECT privilege
on the SYSACCEL.SYSACCELERATEDTABLES and SYSACCEL.SYSACCELERATEDPACKAGES.