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 license 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.