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

You must have certain authorities and privileges so that you can migrate the EXPLAIN and ADVISE tables to the current version or format. The following table details the authorities or 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 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
Use 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, ensure that you have the additional authorities and privileges for DROP INDEX, CREATE TABLE, and GRANT TABLE.

Feedback