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.