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.