Ensure that you have the authorities and privileges that
are required to configure a DB2® for Linux, UNIX, and Windows database.
You must have the following authorities and privileges to
configure a
DB2 for Linux, UNIX, and Windows database
for query tuning:
- To activate the full set of tuning features for InfoSphere® Optim™ Query
Workload Tuner on a database, you must have the authority or privilege
to run the CREATE FUNCTION statement.
- There are two mutually exclusive ways to run the EXPLAIN command.
- Run the EXPLAIN command on a database by using the OQT.WCC_EXPLAIN_SP stored procedure. If you
use this method, your user ID must have the authority to install a JAR file that contains the stored
procedure on a database.
- Run the EXPLAIN command from the IBM Data Studio client. To use this method, all users must
deselect the option Use a stored procedure to explain query workloads in the
preferences for the IBM Data Studio client. To deselect this option, in the client select . In the Preferences window, expand and then select EXPLAIN Options. On the right side of the
window, select the tab DB2 for Linux, UNIX, and Windows.
- You must have the authorities and privileges for running the CREATE
PROCEDURE (external) statement. For more information, see CREATE PROCEDURE (external) statement.
- You must have the authorities and privileges to create EXPLAIN
tables on your database, if these tables are not yet created.
- You must have the authorities, privileges, or both to grant the
required privileges to users who will be tuning SQL statements with InfoSphere Optim Query Workload Tuner. Those privileges
are listed in Authorities and privileges that are required for
capturing and tuning SQL statements and query workloads that run on DB2 for Linux, UNIX,
and Windows.