IBM DB2 Query Patroller Administration Guide

Command Line Interface Environment

To use the DB2 Query Patroller command line interface a user must have an entry in the User Profile table and the following profile variables must be defined. See DB2 Profile Variables for more information.

• DQP_RUNTIME must be set to the path name into which DB2 Query Patroller was installed.
• DQP_NET must be set to the TCP/IP address and port of the server node. Use the format address:port, where address represents either the dotted notation for the address or a name resolvable in the hosts file or through DNS, and port represents either the port number or a name resolvable in the services file.
• The default executable path on UNIX systems must contain DQP_RUNTIME/bin. On Windows systems, the default executable path must contain DQP_RUNTIME\bin.