You must have the authorities and privileges that are required
to migrate the EXPLAIN tables on the subsystems.
If you have the SYSADM authority, you can migrate the
EXPLAIN tables on the subsystem. Otherwise, see the following table
for detailed authorities and privileges that are required for each
individual tasks of migrating the EXPLAIN tables.
Task |
Authorities or privileges required |
Alter EXPLAIN tables |
One or more of the following privileges or authorities:- The ALTER privilege on the table
- Ownership of the table
- DBADM authority for the database
- SYSADM or SYSCTRL authority
|
Create EXPLAIN tables |
If you want to create the EXPLAIN tables in
a new database, one or more of the following privileges or authorities
for creating the database:- CREATEDBA privilege
- CREATEDBC privilege
- SYSADM or SYSCTRL authority
For creating the table space, one or more of the following privileges
or authorities:- CREATETS privilege for the database
- DBADM, DBCTRL, or DBMAINT authority for the database
- SYSADM or SYSCTRL authority
For creating the tables, one or more of the following privileges
or authorities:- CREATETAB privilege for the database
- DBADM, DBCTRL, or DBMAINT authority for the database
- SYSADM or SYSCTRL authority
|
Bind packages |
One of the following authorities and privileges: - SYSADM or DBADM authority
- BINDADD privilege if required packages do not exist, and CREATEIN
privilege on the schema
- ALTERIN privilege on the schema if the required packages exist
- BIND privilege on the required packages if they exist
|