Required authorization

Explain reports require SELECT authorization to access certain tables.

Because OMEGAMON for Db2 PE uses Db2 system catalog tables to create Explain reports, you need SELECT authorization for the SYSIBM.SYS* catalog tables.

To explain saved QMF queries, you need SELECT authorization for the following QMF tables:

• Q.OBJECT_DIRECTORY
• Q.OBJECT_DATA

To control user access to the catalog tables, OMEGAMON for Db2 PE selects data through views. Sample definitions are in the RKO2SAMP library. You can use these definitions as supplied, or tailor them for your installation. For more information, see Configuration and Customization and the Program Directory (refer to OMEGAMON® for Db2 Performance Expert on z/OS®.

When you produce an Explain report, OMEGAMON for Db2 PE checks for the plan table. If it does not exist, it is created in the default database, if you have the required privileges. If you are not authorized, the execution of Explain ends with an error message.