Authorities and privileges for migrating the EXPLAIN and ADVISE tables and the Index Advisor stored procedure on the DB2 for Linux, UNIX, and Windows databases

Ensure that you have the authorities and privileges that are required to migrate the EXPLAIN and ADVISE tables and to enable the new version of the Index Advisor stored procedure on a DB2® for Linux®, UNIX®, and Windows® database.
Task Authorities or privileges required
Migrate EXPLAIN and ADVISE tables For altering the EXPLAIN and ADVISE tables, one or more of the following privileges or authorities:
  • ALTER privilege on the table to be altered
  • CONTROL privilege on the table to be altered
  • ALTERIN privilege on the schema of the table to be altered
  • SYSADM or DBADM authority
For using the REORG utility, one or more of the following privileges or authorities:
  • SYSADM
  • SYSCTRL
  • SYSMAINT
  • DBADM
  • CONTROL privilege on the table
Note: If you migrated the data server from DB2 for Linux, UNIX, and Windows Version 9.7.0 to Version 9.7.1 or later, you must have the additional authorities and privileges for DROP INDEX, CREATE TABLE, and GRANT TABLE to migrate the EXPLAIN and ADVISE tables.
Migrate the Index Advisor stored procedure For dropping the old version of the Index Advisor stored procedure, one or more of the following privileges or authorities:
  • SYSADM or DBADM authority
  • DROPIN privilege on the schema for the federated procedure
  • Definer of the procedure as recorded in the DEFINER column of the catalog view for the federated procedure
  • CONTROL privilege on the federated procedure
For enabling the Index Advisor stored procedure, all of the following privileges or authorities:

Feedback