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

You must have the authorities and privileges that are required to migrate the EXPLAIN tables and Query Tuner tables on DB2® for z/OS® subsystems.

If you have the SYSADM authority, you can migrate the EXPLAIN and Query Tuner tables. Otherwise, see the following table for detailed authorities and privileges that are required for each individual tasks.

Task Authorities or privileges required
Alter EXPLAIN and Query Tuner tables One or more of the following privileges or authorities:
  • ALTER privilege on the tables
  • Ownership of the table
  • DBADM authority for the database
  • SYSADM or SYSCTRL authority
Create EXPLAIN and Query Tuner tables If you want to create the 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