IBM DB2 Query Patroller Installation Guide

Before You Begin

Before you begin the installation, ensure that you have the following items and information:

__  1.
Your system is running either DB2 Enterprise - Extended Edition or DB2 Enterprise Edition Version 7 and has a working instance. For more information on how to install, possibly migrate, and configure either of these DB2 servers, refer to the appropriate Quick Beginnings manual.
__  2.
An available port in the /etc/services file. This port will be reserved for DB2 Query Patroller communications. By default, the db2setup utility will reserve the service name DQP1 and the first available port number after and including 55000 for communications. If you want to reserve a different service name and port number, you may change these values during the installation.
__  3.
The instance running on your DB2 server has been stopped. To stop an instance, log on to the system as a user with System Administrative (SYSADM) authority and enter the db2stop command. For more information on SYSADM authority and the users to which this authority is granted, refer to the Administration Guide.
__  4.
A database whose queries you want to manage using the DB2 Query Patroller Server. If you do not have a database, the db2setup utility will give you the option to create a database during the installation.
__  5.
The vmstat utility has been installed on your workstation.
__  6.
Depending on the language locale that you are using, if you are installing DB2 Query Patroller on a server that is running AIX 4.3.1, you may need to install a PTF. For a more information on the locales that require a PTF, see Appendix A, Language Requirements.
__  7.
A user, with the username iwm, that will be associated with the DB2 Query Patroller instance. This user will be given SYSADM authority over the instance that contains the database where you want to capture running queries.
The db2setup utility gives you the option to create this user during the installation if it does not already exist. If this user does not already exist, we recommend that you let the db2setup utility create it for you. If this user already exists, you must enter all of the matching values for this user in the fields provided.

[ Top of Page | Previous Page | Next Page ]

__ 1.	Your system is running either DB2 Enterprise - Extended Edition or DB2 Enterprise Edition Version 7 and has a working instance. For more information on how to install, possibly migrate, and configure either of these DB2 servers, refer to the appropriate Quick Beginnings manual.
__ 2.	An available port in the `/etc/services` file. This port will be reserved for DB2 Query Patroller communications. By default, the db2setup utility will reserve the service name `DQP1` and the first available port number after and including `55000` for communications. If you want to reserve a different service name and port number, you may change these values during the installation.
__ 3.	The instance running on your DB2 server has been stopped. To stop an instance, log on to the system as a user with System Administrative (SYSADM) authority and enter the db2stop command. For more information on SYSADM authority and the users to which this authority is granted, refer to the Administration Guide.
__ 4.	A database whose queries you want to manage using the DB2 Query Patroller Server. If you do not have a database, the db2setup utility will give you the option to create a database during the installation.
__ 5.	The vmstat utility has been installed on your workstation.
__ 6.	Depending on the language locale that you are using, if you are installing DB2 Query Patroller on a server that is running AIX 4.3.1, you may need to install a PTF. For a more information on the locales that require a PTF, see Appendix A, Language Requirements.
__ 7.	A user, with the username iwm, that will be associated with the DB2 Query Patroller instance. This user will be given SYSADM authority over the instance that contains the database where you want to capture running queries. The db2setup utility gives you the option to create this user during the installation if it does not already exist. If this user does not already exist, we recommend that you let the db2setup utility create it for you. If this user already exists, you must enter all of the matching values for this user in the fields provided.