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:
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:
|