Executing Recovery Analyzer PRA#LOAD and receiving SQL-551 error PTI does not have privilege CREATE MQT on SYSIBM tables.

Products

• Recovery Analyzer for DB2 for z/OS

Issue/Introduction

Executing Recovery Analyzer for Db2 for z/OS (PRA) PRA#LOAD job which is receiving:

SQL ERROR = -551 OCCURED IN PROGRAM PRA#PTIV
DSNT408I SQLCODE = -551, ERROR: PTI DOES NOT HAVE THE PRIVILEGE TO
PERFORM OPERATION CREATE MQT ON OBJECT SYSIBM.SYSXMLRELS

Resolution

It is preferred that the Authorization ID executing the PRA#LOAD job hold SYSADM authorization on the primary ID.

If executing with a SYSADM ID is not possible one option to resolve the SQL-551 errors reported is to
GRANT SELECT to PTI on the following SYSIBM tables:

SYSIBM.SYSTABLES
SYSIBM.SYSXMLRELS
SYSIBM.SYSAUXRELS
SYSIBM.SYSTABLEPART
SYSIBM.SYSINDEXPART
SYSIBM.SYSINDEXES

Another option would to GRANT SELECT to PUBLIC for the above SYSIBM tables.

This concern seems related to the creator of the table, PTI, requiring
authorization to SELECT from the SYSIBM tables in the MQT CREATE TABLE statement.

The same table CREATE in SPUFI for example returns the same SQL-551 error.
This seems to be a limitation in DB2 for the creation of the MQT where the
secondary authorization held is not utilized.