Content

In the details that follow, replace <platform> with your platform:

• For AIX, use aix.
• For Linux x86-64, use linux-x86_64.
• For Linux on Power Systems (little endian), use plinux-le.
• For Linux on System z, use zlinux.
• For Windows, use win64.

Overview

Important:  On z/OS platforms, Db2 LUW installation package is currently not available for download from IBM Software Shopz . It is therefore recommended to use Db2 z/OS as the repository database unless you have your own Db2 LUW package and LAK.

The following is a summary of how to download, install, and configure either a new Db2 Query Workload Tuner for z/OS (QWTz) installation for versions 5.2.1 and above, or an upgrade from a previous Db2 QWTz installation.

Note: While Db2 QWTz allows users to connect to and manage Db2 instances on the z/OS platform, it is not intended to be installed on the z/OS platform. Db2 QWTz is designed for the Linux, Unix (AIX) and Windows operating systems.

Steps include:

1. Downloading Db2 QWTz [the QWTz base image package and the Licence Activation Kit (LAK)]
2. Installing or upgrading Db2 QWTz
3. Applying the Db2 QWTz LAK
4. Enabling your Db2 QWTz features
5. Configuring QWTz for tuning
6. [Optional On-Demand]Reverting back to a previous Db2 QWTz installation

Step 1: Downloading Db2 Query Workload Tuner for z/OS:

• All installation packages are available from IBM Software Shopz in ISO format. Use an extraction tool of your choosing to access the source files.

  The following table lists, by form number, the various installation packages available for Db2 Query Workload Tuner for z/OS, versions 5.2.1 and above:

  Description	Form Number
  IBM Db2 Query Workload Tuner for z/OS V5.2.3 - License Activation Kit (LAK)	LCD4-8584-04
  IBM Db2 Query Workload Tuner for z/OS V5.2.3 with License Activation Kit - for AIX Operating Systems	LCD4-8591-04
  IBM Db2 Query Workload Tuner for z/OS V5.2.3 with License Activation Kit - for Linux Operating Systems	LCD4-8592-04
  IBM Db2 Query Workload Tuner for z/OS V5.2.3 with License Activation Kit - for Windows Operating Systems	LCD4-8593-04
  IBM Db2 Query Workload Tuner for z/OS V5.2.2 - License Activation Kit (LAK)	LCD4-8584-03
  IBM Db2 Query Workload Tuner for z/OS V5.2.2 with License Activation Kit - for AIX Operating Systems	LCD4-8591-03
  IBM Db2 Query Workload Tuner for z/OS V5.2.2 with License Activation Kit - for Linux Operating Systems	LCD4-8592-03
  IBM Db2 Query Workload Tuner for z/OS V5.2.2 with License Activation Kit - for Windows Operating Systems	LCD4-8593-03
  IBM DB2 Query Workload Tuner for z/OS V5.2.1 - License Activation Kit (LAK)	LCD4-8584-02
  IBM DB2 Query Workload Tuner for z/OS V5.2.1 with License Activation Kit - for AIX Operating Systems	LCD4-8591-02
  IBM DB2 Query Workload Tuner for z/OS V5.2.1 with License Activation Kit - for Linux Operating Systems	LCD4-8592-02
  IBM DB2 Query Workload Tuner for z/OS V5.2.1 with License Activation Kit - for Windows Operating Systems	LCD4-8593-02

  
  To download Db2 QWTz from IBM Software Shopz:
  1. From the Fast access panel on the Shopz home page, click Sign in for registered users and sign into the site, using the credentials provided to you by IBM.
  2. From the Group page, click create new software orders for service or products.
  3. From the My orders page, under Package category, click the option button to the left of z/OS - Products, select CBPDO (products) from the drop-down list, and then click Continue. The next page presents the basic details of your order.
  4. Verify the details and click Continue.
  5. On the next page, choose a hardware option that matches your machine, and click Continue.
  6. On the next page, choose the option button to the left of Do not use a report for this order, and click Continue.
  7. On the next page, search for Db2 Query Workload Tuner for z/OS, using the following selections:
     - Group: select DBS - Db2 (114 Products)
     - Language: (your preferred language)
     - Filter: select Show licensed products
     - Search field: click the Product description option button
     - Search for: enter Query Workload Tuner
     - Sort by: click the Product ID option button (Product ID for Db2 QWTz is 5655-AB4)
     Click Show catalog, and then click Continue.
  8. Scroll through the result set to locate the version of DSM that you want to download, click the Select check box and click Continue. On the next page you should see a message, verifying that your order is fully entitled. Click Continue.
  9. On the next page, under Delivery media, select Internet as the preferred media. Click Continue.
  10. On the next page, review your order, then click Submit.
      You will receive an email containing credentials you need to download the product, and a link to the Shopz download page.

Step 2: Installing/Upgrading Db2 Query Workload Tuner for z/OS:

• To install Db2 QWTz V5.2.1 and above versions for the first time:
  1. After you have downloaded the IBM Db2 Query Workload Tuner, extract the QWTz base image package contents first (naming as ibm-db2querywkldtnr-x.x.x-platform).
     The extracted package expands into an /ibm-datasrvrmgr installation directory. For example, if you extract the package contents into C:\, the Db2 Query Workload Tuner for z/OS product expands into C:\ibm-datasrvrmgr. For the remainder of this Tech Note, the installation directory is referred to as <installdirectory>.
  2. From the installation directory, run the setup script and follow the prompts, or do a silent install from a terminal window.
     To do a silent install, review and modify <installdirectory>/setup.conf as required, and then run the following command: setup -silent. Go to the IBM Data Server Manager Knowledge Center for more information on setting parameters for the setup command.
     Note: You can use HTTPS with SSL security exclusively to connect to your Db2 QWTz server. To do this, set the following values in the <installdirectory>/Config/dswebserver.properties file:
     - cookie.secureOnly=true
     - port=-1
  
  To upgrade an existing Db2 QWTz installation to Version 5.2.1 and above:
  
  Note: Prior to upgrading, it is a good idea to make a backup of your repository database. Having such a backup is vital to successfully regressing back to an older QWTz environment, should you need to do so.
  1. Stop your current Db2 QWTz server or service. If your server is running as a Windows service, run <installdirectory>\bin\stopservice. Otherwise, run <installdirectory>/bin/stop.sh.
  2. Verify that the server is stopped, by running <installdirectory>/bin/status.
  3. Extract the package for Db2 QWTz V5.2.1 and above that you downloaded previously into your install directory. Allow the files to be overwritten and replaced.
  4. From the installation directory, run the setup script and follow the prompts, or do a silent install from a terminal window.
     To do a silent install, review and modify <installdirectory>/setup.conf, as required, and then run the following command: setup -silent. Go to the IBM Data Server Manager Knowledge Center for more information on setting parameters for the setup command.
  5. Verify that the server is started, by running <installdirectory>/bin/status. The message is shown as follows:
     dsserver_home: /data/DSMbuild/ibm-datasrvrmgr
     port: 11080
     https.port: 11081
     status.port: 11082
     SERVER STATUS: ACTIVE
     
     Note: If you keep historical data from Db2 QWTz V5.2.2 in the browser, you will need to clear the browser cache after you upgrade successfully from Db2 QWTz V5.2.2 to Db2 QWTz V5.2.3. You can find instructions on how to clear the cache for your specific browser at one of the following sites:
     • Firefox
     • Chrome
     • Internet Explorer
  6. Ensure that your repository database is up to date.
     • If your repository database resides on a LUW platform, navigate to the /samples/DB2LUW folder of your QWTz installation folder, and locate and run validate.sql. This will tell you if any of your repository tables are missing.
     • If your repository database resides on a z/OS system, you will need to perform additional steps to make it compatible with your new QWTz environment.
       For repository migration steps, refer to the IBM Knowledge Center topic, Upgrading an existing Db2 for z/OS repository database
  Now the upgrade is complete and your server is ready for use.

Step 3: Applying Db2 Query Workload Tuner for z/OS License Activation Kit:

Note: If you are performing an upgrade and have already applied the QWTz LAK to your previous version of QWTz, you can skip this step.

• 1. Download the entitled license activation kit package from IBM Software Shopz as described in Step 1.
  2. Stop your current Db2 QWTz server or service. If your current version is running as a Windows service, run <installdirectory>\bin\stopservice. Otherwise, run <installdirectory>/bin/stop.sh.
  3. Verify that the server is stopped by running <installdirectory>/bin/status.
  4. Apply the license activation kit:
     1. Extract the QWTz LAK into your install directory.
     2. Allow files to be overwritten and replaced. For example, the Config, dscomponents, and license folders in the LAK should be extracted to the Config, dscomponents and license folders in your installation directory.
  5. Start your Db2 QWTz server or service. If your server is running as a Windows service, run <installdirectory>\bin\startservice. Otherwise, run <installdirectory>/bin/start.sh.
  • Your Db2 QWTz license activation kits have been applied.







 
•  
•  
•  
•  
•  

Step 4 : Enabling IBM Db2 Query Workload Tuner for z/OS features:

• Once you have installed the package and applied the LAK, you can enable Db2 QWTz features for your Db2 for z/OS connections.

  To enable Db2 QWTz features:

  1. Log in to Db2 QWTz.
  2. From the Navigation bar, click Settings >Manage Connections.
  3. From the Database Connection pane, create a new z/OS connection, or select the z/OS connection for which you want to enable the QWTz license, and click Activate License.
  4. From the Edition column, click the corresponding URL to display the current supported capabilities in the Capabilities column. For example, if you have applied your Db2 QWTz license to that connection, you will see DSM_ENTERPRISE_Z_TUNE in the Capabilities column.







 
•  
•  
•  
•  
•  

Step 5 : Configuring IBM Db2 Query Workload Tuner for z/OS for tuning

• QWTz requires a repository database, for the storage of Tuning Metadata. Follow the steps in the IBM Data Server Manager Knowledge Center to add or upgrade a repository database.

  Additional steps are required to configure your Db2 subsystem for tuning, Follow the steps in the IBM Data Server Manager Knowledge Center to configure your Db2 database for tuning.

Step 6 (Optional) : Reverting back to a previous IBM Db2 Query Workload Tuner for z/OS installation, after upgrading

• When you upgrade your current QWTz environment, the running of the setup script creates a sub-folder within your installation folder, titled dsm_bak_v21x, that is populated with a backup of your current QWTz installation. The naming of this file is dictated by the version of IBM Data Server Manager (DSM) that corresponds to your installed version of QWTz, prior to upgrading (e.g., QWTz 5.2.2 and DSM 2.1.4), as this mechanism is used by all of the DSM-based management consoles.

  In the event that you want to revert back to your original QWTz installation, after upgrading, you can use the contents of this folder to re-create your previous QWTz environment.

  Note: Be advised that, if you have already upgraded your repository database for use with your upgraded QWTz version, there are several changes to tables that cannot be reverted. This process will only work using a clean backup of your previous QWTz repository database.

  To revert back to a previous DSM installation:

   
  1. Install a new instance of the QWTz version to which you want to revert back.
  2. From the installation folder of your upgraded QWTz instance, locate and open your \dsm_bak_v21x sub-folder.
  3. Copy the contents of the \dsm_bak_v21x sub-folder to the corresponding locations within your newly created QWTz installation.
  4. If you have not already done so, start your newly regressed version of the QWTz application.
  5. Log in through the web console and examine your product setup. You will find that your settings, such as the Java Heap Size and System port number, have been reverted to their previous values.
  6. Go to Settings > Product Setup and restore the connection to your previous QWTz repository database, or to a restored backup of that database.
     You will find all the information in the repository database is still here.