If DB2 Query Patroller is installed on a system that is running DB2 Enterprise-Extended Edition, you must update the dqpnodes.cfg file for each agent node before starting DB2 Query Patroller. The dqpnodes.cfg file is created in the following location during installation:
UNIX:
instance_path/dqpnodes.cfg
where instance_path is the path for the DB2 instance containing the target data source.
Windows:
instance_directory\dqpnodes.cfg
where instance_directory is the directory for the DB2 instance containing the target data source.
The dqpnodes.cfg file must contain entries for each node that has a DB2 Query Patroller server or agent installed. Entries in the dqpnodes.cfg file are in the following format:
node_number host_name {server | agent | none}
where node_number is the number given to the DB2 Query Patroller node, and host_name is hostname or IP address on UNIX, or the computer-name on Windows.
The node number you provide must be a value from 0 to 999. The number you choose for a DB2 Query Patroller node can be the same number used for the DB2 node on which the DB2 Query Patroller agent or server is installed.
Each entry in the dqpnodes.cfg file must be defined as server, agent or none. There must be only one entry per line, and only the node where the DB2 Query Patroller server is installed should specify the server option. Entries for nodes where the DB2 Query Patroller agent is installed must specify the agent option. To suspend a DB2 Query Patroller node entry for whatever reason, you can use the none option.
A dqpnodes.cfg file on Windows would contain entries similar to the following:
0 MY1STNODE server 1 MY2NDNODE agent 3 MY3RDNODE agent
To avoid confusion, it is recommended that you specify the same node number for a DB2 Query Patroller node and the DB2 node on which the DB2 Query Patroller server or agent is installed. For example, if you are installing a DB2 Query Patroller server on a DB2 node that has 0 as its designated node number in the db2nodes.cfg file, you would specify a node number of 0 in the dqpnodes.cfg file for the DB2 Query Patroller server. In this case, you would use the following commands to start both the DB2 node and DB2 Query Patroller server node:
db2start nodenum 0 dqpstart nodenum 0