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

You must have certain authorities and privileges so that you can migrate EXPLAIN and ADVISE tables to the current version or format. The following table details the authorities and privileges that are required for each task.
Task Authorities or privileges required
Alter the EXPLAIN and ADVISE tables One or more of the following privileges or authorities:
  • ALTER privilege on the tables to be altered
  • CONTROL privilege on the tables to be altered
  • ALTERIN privilege on the schema of the tables to be altered
  • SYSADM or DBADM authority
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.
Use the REORG utility One or more of the following privileges or authorities:
  • SYSADM
  • SYSCTRL
  • SYSMAINT
  • DBADM
  • CONTROL privilege on the tables

Feedback