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.
- DB2 for Linux, UNIX,
and Windows, Version 9.7.4
or earlier: You must have the authority to install a JAR file
with a stored procedure on the database server. For more information,
see JAR file administration on the database server.
- 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.