Before you configure your DB2® Version
9.1.8 for Linux®, UNIX®, and Windows® database
for query tuning, you must perform some preliminary tasks on the server
to configure the DB2 database
and define the EXPLAIN tables.
Before you begin
- Ensure that you have SYSADM authority.
- Ensure that you have CREATE TABLE, CREATE INDEX, and CREATE FUNCTION
privileges on the target database.
Procedure
To complete the preliminary configuration tasks:
- Configure the DB2 database:
- In a Command Prompt window, connect
to the database and run the following command:
db2set
DB2_USE_DB2JCCT2_JROUTINE=yes
- In a DB2 command
line processor window, run the following command:
db2
update dbm cfg using KEEPFENCED NO
- Optional: In the DB2 command line processor window, run the following
command to ensure that no active transactions are running before you
restart the database:
LIST APPLICATIONS SHOW
DETAIL
- In the Command Prompt window, run
the following commands to restart the DB2 database
for the change to take effect:
- Define the EXPLAIN tables:
- In a DB2 command
window, run the EXPLAIN.DDL file to define the
EXPLAIN tables. By default, you can find the EXPLAIN.DDL file
in the following locations:
- On Windows: C:\Program
Files\IBM\SQLLIB\MISC
- On Linux or UNIX: /opt/ibm/db2/version_number
- Give access to these tables to other users who need
to use IBM® Data
Studio.