If you installed DB2 Query Patroller Server in a DB2 Enterprise - Extended Edition environment, you can optionally install a DB2 Query Patroller Agent on all the database partition servers in the instance. Installing multiple agents will help balance the workload across your partitioned database system, much like the balancing that occurs from configuring multiple coordinator database partitions for your client connections.
If you installed a DB2 Query Patroller Server in a DB2 Enterprise Edition environment, you do not need to install a DB2 Query Patroller Agent.
To install the DB2 Query Patroller Agent, simply log on to a database
partition server and run the setup program as you did in Performing the Installation. If you have already installed a DB2 Query Patroller
Server in your partitioned database system, the setup program will detect this
and only allow you to install a DB2 Query Patroller Agent. You can only
perform one DB2 Query Patroller Server installation in a DB2 Enterprise -
Extended Edition environment.
|
| When you run the setup program on a database partition server to install a DB2 Query Patroller Agent, the Select Products window will still show DB2 Query Patroller Server as the only selectable product to install. The Description box will verify that you are installing a DB2 Query Patroller Agent. |
Whenever you install a DB2 Query Patroller Agent on a database partition server, you must add an entry to the dqpnodes.cfg file on the DB2 Query Patroller Server if you want to start the agent when the server is started. This entry describes the server where you installed the DB2 Query Patroller Agent. You do not need to add an entry to this file for a particular database partition server if you do not want to start the agent on it. The dpqstart and dpqstop commands use the dqpnodes.cfg file to synchronize start and stop processes on the listed database partition servers. For more information, refer to the DB2 Query Patroller Administration Guide.