Authorities and privileges for migrating the EXPLAIN tables and Query Tuner tables on the DB2 for z/OS subsystems

Ensure that you have the authorities and privileges that are required to migrate the EXPLAIN tables and Query Tuner tables on the DB2® for z/OS® subsystems.
Task Authorities or privileges required
Alter EXPLAIN and Query Tuner tables One or more of the following privileges or authorities:
  • The ALTER privilege on the tables
  • Ownership of the tables
  • DBADM authority for the database
  • SYSADM or SYSCTRL authority
Create EXPLAIN and Query Tuner tables If you want to create the EXPLAIN tables in a new database, one or more of the following privileges or authorities for creating the database:
  • CREATEDBA privilege
  • CREATEDBC privilege
  • SYSADM or SYSCTRL authority
For creating the table space, one or more of the following privileges or authorities:
  • CREATETS privilege for the database
  • DBADM, DBCTRL, or DBMAINT authority for the database
  • SYSADM or SYSCTRL authority
For creating the tables, one or more of the following privileges or authorities:
  • CREATETAB privilege for the database
  • DBADM, DBCTRL, or DBMAINT authority for the database
  • SYSADM or SYSCTRL authority
Bind packages One of the following authorities and privileges:
  • SYSADM or DBADM authority
  • BINDADD privilege if required packages do not exist, and CREATEIN privilege on the schema
  • ALTERIN privilege on the schema if the required packages exist
  • BIND privilege on the required packages if they exist

Feedback