This chapter provides an overview of the architecture and system requirements for DB2 Query Patroller.
The DB2 Query Patroller system consists of the DB2 Query Patroller server
system, the system administrator's workstation, and client PCs.
The diagram below illustrates the architecture of the DB2 Query Patroller
system.
The DB2 Query Patroller server system contains the target data warehouse and the DB2 Query Patroller software to manage queries against the database.
Two DB2 Query Patroller components reside on the DB2 Query Patroller server system:
The server component executes on a single database node. The server component accepts, analyzes, prioritizes, and schedules database requests and optionally notifies users when their requests complete. The DB2 Query Patroller system requires one and only one DB2 Query Patroller server component per installation of DB2 Query Patroller.
The agent component executes on one or more database nodes and processes database requests on behalf of users. On a single-processor or non-clustered SMP machine, the agent and server components run on the same machine. On an MPP machine or clustered SMP machines, the server component runs on one node and the agent may be run on several nodes, including the same node as the server component.
Most Windows-based PCs or workstations can serve as the system administrator's workstation.
Two DB2 Query Patroller components are required on the system administrator's workstation:
QueryAdministrator enables the system administrator to manage the DB2 Query Patroller system parameters, create or delete profiles for DB2 Query Patroller users, manage nodes, job queues, and result destinations.
QueryMonitor provides administrators with the ability to list queries, change status, and drop result sets for any jobs in the DB2 Query Patroller system.
At least one copy of QueryAdministrator must be installed on a system client thereby creating the system administrator's workstation.
Two components are optional for the system administrator's workstation:
Most Windows-based PCs or workstations running a 32-bit open database connectivity-compliant (ODBC-compliant) query application can serve as a client PC in the DB2 Query Patroller system.
The QueryEnabler component is required on each client PC. The QueryMonitor component is optional.
The QueryEnabler intercepts queries submitted by any ODBC-compliant query application and places the queries under the control of the DB2 Query Patroller system.
QueryMonitor provides users with the ability to list queries, change status, and drop result sets for queries they have submitted through the DB2 Query Patroller system.
The following sections list the requirements for the DB2 Query Patroller server system, the system administrator's workstation, and client workstations.
The server and agent components of DB2 Query Patroller require the following:
| Note: | If you are a AIX 4.3.1.0 refer to the Language Requirements appendix to ensure that you have the proper PTFs installed. |
Hardware and Operating System:
Table 1. Supported DB2 Query Patroller Server System Platforms
| Manufacturer | Platform | Operating System |
|---|---|---|
| IBM | AIX | AIX 4.2 or higher |
| Sun Microsystems | Solaris | Version 2.5.1 or higher |
RDBMS: DB2 Universal Database (UDB) Extended Enterprise Edition Version 6.1
Table 2. Required Disk Space on the DB2 Query Patroller Server System
| DB2 Query Patrol component | Disk Space (in MB) |
|---|---|
| DB2 Query Patrol server | 5 |
| DB2 Query Patrol agent | 1 |
| Total | 6 |
The requirements for the QueryAdministrator component of DB2 Query Patroller are listed below. These requirements are based on the DB2 Query Patroller administrative client components only. If you are installing the DB2 Query Patroller administrative client as part of a DB2 Administration Client Installation, refer to DB2 for UNIX Quick Beginnings for the DB2 Administration Client system requirements.
Memory (RAM): 16 MB (Windows 95) or 32 MB (Windows 98 and Windows NT 4.0 or higher).
Hardware and Operating System: An Intel 32-bit architecture (IA-32) PC running a Windows 32-bit operating system.
Table 3. Required Disk Space on Client PCs
| Component | Disk Space in MB |
|---|---|
| QueryAdministrator | 1 |
| QueryMonitor | 1 |
| Tracker | 1.6 |
| ODBC support | 2 |
| Java Enablement | 8.9 |
Database Driver: QueryAdministrator and QueryMonitor require an IBM DB2 ODBC driver configured to the target database.
Java environment: QueryAdministrator and QueryMonitor require a Java 1.1.7 environment.
The requirements for the QueryEnabler and QueryMonitor components of DB2 Query Patroller are listed below. These requirements are based on DB2 Query Patroller client components only.
Memory (RAM): 16 MB (Windows 95) or 32 MB (Windows 98 and Windows NT 4.0 or higher).
Hardware and Operating System: An Intel 32-bit architecture (IA-32) PC running a Windows 32-bit operating system.
Table 4. Required Disk Space on Client PCs
| Component | Disk Space in MB |
|---|---|
| QueryEnabler | .9 |
| QueryMonitor | 1 |
| ODBC support | 2 |
| Java Enablement | 8.9 |
32-bit ODBC Query Application: QueryEnabler requires a 32-bit ODBC query application such as Business Objects, or Cognos Impromptu.
Database Driver: QueryEnabler and QueryMonitor require an IBM DB2 ODBC driver configured to the target database.
Java Environment: QueryMonitor requires a JAVA 1.1.7 environment.