The following section provides information and outlines approaches for configuring the DB2 Query Patroller server for best performance.
There are no specific guidelines for setting the DB2 Query Patroller parameters because each data warehouse has its own set of unique attributes, such as size of the database, the complexity of the queries, the number of users supported, and the availability of hardware resources. This section describes an approach that can be taken to configure the DB2 Query Patroller server.