IBM DB2 Query Patroller Installation Guide
This section provides an overview of a typical DB2 Query
Patroller environment.
The DB2 Query Patroller environment contains three components:
- A DB2 Query Patroller Server
- One or more DB2 Query Patroller System Administration Workstations
- Any number of DB2 clients.
| All of the DB2 Query Patroller Tools are written in Java and require a
Java Run-Time Environment (JRE) to be installed and configured before
use.
On Windows NT and Windows 2000, a JRE is always installed as part of the
installation. On AIX, a JRE is only installed as part of the
installation if a JRE does not currently exist on the server. With all
other UNIX-based operating systems, you must install the JRE yourself.
The steps required to configure a JRE for the DB2 Query Patroller tools are
the same as those required to configure a JRE for the Control Center.
For more information on the required configuration steps and a supported JRE
for your platform, refer to the Installation and
Configuration Supplement.
|
DB2 Query Patroller Server
The DB2 Query Patroller Server is installed on a DB2 server that is running
either DB2 Enterprise - Extended Edition or DB2 Enterprise Edition.
When you install the DB2 Query Patroller Server, a corresponding DB2 Query
Patroller Agent is also installed. The DB2 Query Patroller Server
accepts, analyzes, prioritizes, and schedules queries that run against your
data warehouse. This server can also notify users when their queries
complete.
In a partitioned database environment, the DB2 Query Patroller Server and a
corresponding DB2 Query Patroller Agent are installed on one database
partition server. This is the coordinator database partition server
where your clients connect to submit a query. To balance workload, you
can optionally install a DB2 Query Patroller Agent on the remaining database
partition servers in your partitioned database system. These agents
will help to process requests that are directed to the DB2 Query Patroller
Server and balance the workload on your server. A DB2 Query Patroller
Agent can also be used in a hardware environment that uses clusters of
symmetric multiprocessing (SMP) workstations.
DB2 Query Patroller System Administration Workstation
A DB2 client can act as a DB2 Query Patroller System Administration
Workstation. When you install a DB2 client on Windows NT or Windows
2000, you must perform a Custom installation and select to include
the Tracker Tool and the QueryAdmin Tool subcomponents,
of the DB2 Query Patroller Client component, to enable your
workstation to administer the DB2 Query Patroller Server. By default,
the DB2 Query Patroller Client is selected for installation when
you perform a Typical or a Custom install.
If you want to use a DB2 client to submit queries that can be captured by
the DB2 Query Patroller Server, you must install the QueryEnabler
Tool subcomponent. See the DB2 Clients description for
details on this subcomponent and the QueryMonitor Tool
subcomponent. We recommend that you install all the available
components with any DB2 Query Patroller System Administration Workstation
installation.
When you install a DB2 Query Patroller Client on a UNIX-based client, all
of the components necessary to administer the DB2 Query Patroller Server are
included in the installation. These components are not individually
selectable in a UNIX-based installation. Any DB2 Query Patroller Client
installed on a UNIX-based client will always be a DB2 Query Patroller System
Administration Workstation.
| Remember, in a UNIX-based environment you must install a DB2 Query
Patroller Client on a workstation that has a previously installed DB2
client. For information on how to install a DB2 client, refer to the
Installation and Configuration Supplement.
|
Typically, a DB2 Query Patroller System Administration Workstation consists
of the QueryAdmin Tool and the Tracker Tool. The
QueryAdmin Tool enables an administrator to manage the DB2 Query Patroller
Server's configuration, create and delete user profiles, and manage
queries and result destinations. The Tracker Tool allows an
administrator to monitor usage history of a database.
| It is the QueryAdmin Tool that differentiates a DB2 Query Patroller
System Administration Workstation from other DB2 clients that participate in a
DB2 Query Patroller environment.
|
DB2 Clients
When you install a DB2 client on Windows NT or Windows 2000, a
Typical installation will install the QueryMonitor Tool
and the QueryEnabler Tool subcomponents of the DB2 Query
Patroller Client component. By default, the DB2 Query
Patroller Client component is selected for installation when you perform
a Typical or a Custom install. Only the
QueryEnabler Tool subcomponent is required on a client to capture
queries.
When you install a DB2 Query Patroller Client on a UNIX-based platform, all
of the components necessary to administer a DB2 Query Patroller Server are
included in the installation and are not individually selectable. You
will therefore always install a DB2 Query Patroller System Administration
Workstation on a UNIX-based workstation when you install a DB2 Query Patroller
Client. This means that your DB2 client will always be able to submit
queries and administer the DB2 Query Patroller Server.
In a Windows NT or Windows 2000 environment, the QueryEnabler Tool and the
QueryMonitor Tool are typically installed on a DB2 client. The
QueryEnabler Tool traps queries submitted by a DB2 client and places the query
under the control of the DB2 Query Patroller Server. The QueryMonitor
Tool provides any user that has submitted a query the ability to list all
submitted queries, change the status of a query, or drop the result set for
the processed query.
For information on how to use any of the DB2 Query Patroller tools, refer
to the DB2 Query Patroller Administration Guide and the DB2 Query Patroller User's Guide.
The way you install a DB2 Query Patroller Server in your enterprise depends
on the type of DB2 server you use for your data warehouse or data mart.
If you are running queries against a DB2 Enterprise - Extended Edition server,
your environment is illustrated in Figure 1.
Figure 1. DB2 Query Patroller in a DB2 Enterprise - Extended Edition environment.
If you are running queries against a DB2 Enterprise Edition server, your
environment is illustrated in Figure 2.
Figure 2. DB2 Query Patroller in a DB2 Enterprise - Extended Edition environment.
|
Go to the section that describes the DB2 Query Patroller Server that you
want to install:
|
[ Top of Page | Previous Page | Next Page ]
