Preliminary configuration tasks for configuring a DB2 Version 9.1.8 for Linux, UNIX, and Windows database for query tuning

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

Procedure

To complete the preliminary configuration tasks:

  1. Configure the DB2 database:
    1. In a Command Prompt window, connect to the database and run the following command:

      db2set DB2_USE_DB2JCCT2_JROUTINE=yes

    2. In a DB2 command line processor window, run the following command:

      db2 update dbm cfg using KEEPFENCED NO

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

    4. In the Command Prompt window, run the following commands to restart the DB2 database for the change to take effect:
      db2stop
      db2start
  2. Define the EXPLAIN tables:
    1. 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
    2. Give access to these tables to other users who need to use IBM® Data Studio.

Feedback