File Installation

A DB2 Web Query home directory, or "local root", should be created on the server that will run DB2 Web Query. You can then copy the DB2 Web Query files from the distribution media (CD Rom, compressed file, etc.) to the local root.

Note:     You will find 3 objects on the DB2 Web Query installation CD. One is a directory called DB2WebQuery. This directory contains all of the files associated with DB2 Web Query uncompressed. The second file is the file called DB2WebQuery.tar. This file contains all of the files associated with DB2 Web Query compressed in a .tar format. The third file on the CD is, DB2WebQuery.zip. It contains all of the files associated with DB2 Web Query compressed in the .zip format.

Before installing DB2 Web Query, ensure that you have installed the most recent JDBC driver and the most recent version of DB2 including any available patches.

Step 1: Create Local Root and Copy Program Files

1.         Create a local root for DB2 Web Query on the server that will run DB2 Web Query. The local route directory should be read/writable by the WebSphere user. This directory is the local root on the server for DB2 Web Query. All DB2 Web Query program files will reside in this directory on the server.

The suggested locations for the local root directory are as follows:

Platform

Recommended local root directory path

Windows NT and Windows 2000

C:\Program Files\DB2WebQuery

AIX

/usr/lpp/DB2WebQuery

z/OS, OS/390, and MVS

/usr/lpp/DB2WebQuery

iSeries and AS/400

/QIBM/UserData/DB2WebQuery

You can create the local root directory elsewhere and indicate the location using the installRoot parameter

2.         Identify the proper IBM DB2 Web Query distribution file for the platform on which you will be installing IBM DB2 Web Query.

Platform

Distribution Path

Windows NT and Windows 2000

wq12-full.zip

Linux and UNIX

wq12-full.tar

z/OS and OS/390 running WebSphere 3.x and 4.0

wq123903x-full.tar

z/OS and OS/390 running WebSphere 1.2

wq123901x-full.tar

iSeries and AS/400

/ DB2WebQuery directory on the IBM DB2 Web Query distribution CD

Note: use the Operations Navigator to copy the files to the server.

 

3.         Copy the entire contents of the distribution media to the IBM DB2 Web Query install root directory that you created in step one.

This creates the DB2 Web Query directory tree on your server. You can find all DB2 Web Query files in this directory tree.

Note:     You will find 3 objects on the DB2 Web Query installation CD. One is a directory called DB2WebQuery. This directory contains all of the files associated with DB2 Web Query uncompressed. The second file is the file called DB2WebQuery.tar. This file contains all of the files associated with DB2 Web Query compressed in a .tar format. The third file on the CD is, DB2WebQuery.zip. It contains all of the files associated with DB2 Web Query compressed in the .zip format.

Step 2: Copy HTML Files to Web Server Document Root

This step is not necessary if you are using WebSphere 3.0 or higher.

Copy the DB2 Web Query HTML files from the DB2 Web Query directory tree to your web server’s Document Root. The Document Root is the location where HTML files are stored on your web server. If you are unsure, refer to your web server documentation for the name and location of the Document Root.

In the DB2 Web Query directory tree, navigate to the folder named web. Copy the contents of this folder to your web server Document Root.

 

Step 3: Copy Java Files to Application Server Servlet Root

This step is not necessary if you are using WebSphere 3.0 or higher.

Copy the DB2 Web Query Java files from the DB2 Web Query directory tree to your application server’s Servlet Root. The Servlet Root is the location where Java servlet source files are stored in your application server. If you are unsure, refer to your application server documentation for the name and location of the Servlet Root.

In the DB2 Web Query directory tree, navigate to the folder named servlets. Copy all jar files located there to your web server Servlet Root.