Prerequisites and requirements for using DB2 9.1.8 for Linux, UNIX and Windows with Optim Query Tuner for DB2 for Linux, UNIX, and Windows, Version 2.2.0.2, and Data Studio, Version 2.2.0.2 (stand-alone)

Technote (FAQ)


Question

What are the steps for configuring DB2 9.1.8 for Linux, UNIX and Windows to work with Optim Query Tuner for DB2 for Linux, UNIX, and Windows, Version 2.2.0.2, and Data Studio, Version 2.2.0.2 (stand-alone)?

Answer

  1. Configure the DB2 instance by following these steps:
    1. Ensure that your user ID has SYSADM authority.
    2. In a Command Prompt window, connect to the instance and run the following command:
      1. db2set DB2_USE_DB2JCCT2_JROUTINE=yes
    3. In a DB2 command-line processor window, run the following command:
      1. db2 update dbm cfg using KEEPFENCED NO
    4. (Optional) In a DB2 command-line processor window, run the following command to ensure no active transactions are running before you stop and restart the instance.
      1. LIST APPLICATIONS SHOW DETAIL
    5. In the Command Prompt window, run the following commands to stop and restart the DB2 instance for the change to take effect.
      1. db2stop
      2. db2start
  2. Define EXPLAIN tables by following these steps:
    1. Ensure that your user ID has the CREATE TABLE, CREATE INDEX, and CREATE FUNCTION privileges in the target database instance.
    2. Define EXPLAIN tables by running the EXPLAIN.DDL file from a DB2 command window. By default, the EXPLAIN.DDL file is located in C:\Program Files\IBM\SQLLIB\MISC for Windows, /opt/ibm/db2/V9.1 for Linux, and /opt/IBM/db2/V9.1 for AIX, HP-UX, and Solaris Operating Environment. (Please note that if you have more than one copy of DB2 installed, the DB2 database product installation path has _xx added to it, where xx are digits, starting at 01 and increasing depending on how many DB2 copies you have installed.)
    3. Give the other users who need to use Optim Query Tuner for DB2 for Linux, UNIX, and Windows and Data Studio access to these tables.

Cross Reference information
Segment Product Component Platform Version Edition
Information Management Data Studio Linux, Windows 2.2.0.2

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Optim Query Tuner for DB2 for Linux- UNIX and Windows

Software version:

2.2.0.2

Operating system(s):

Linux, Windows

Reference #:

1425726

Modified date:

2010-06-07

Translate my page

Machine Translation

Content navigation