The DB2 Query Patroller client has several configuration options that control the operational semantics of the queries that it submits. These configuration options are can be modified in the file DB2IWM.INI in the Windows install directory. They configuration options are:
This option specifies the maximum number of rows that will be returned in the answer set. If this value is set to 0, the complete answer set will be returned.
This option specifies the maximum number of seconds the query will be permitted to run against the DB2 Query Patroller server. If this value is set to 0 or -1 the query will always run to completion.
This option is provided to allow queries to be posted to the DB2 Query Patroller server without requiring user intervention. This environment variable can be set to one of two values:
When the DB2_IWM_SUBMITWAIT variable is set to RUN, queries will be submitted to the DB2 Query Patroller server in a Submit and Wait mode. A user dialog is not required. The RUN value has a time out option: RUN: <timeout>. This option is in units of seconds. If this option is not set, the RUN setting will remain indefinitely.
When the DB2_IWM_SUBMITWAIT variable is set to CHECK, it will behave similarly to RUN, but in this case, DB2 Query Patroller will check to determine if an answer set exists for the query. If an answer set does exist, that result set will be returned, as opposed to the same query being executed again. The CHECK value has a time out option: CHECK: <timeout>. This option is in units of seconds. If this option is not set, the CHECK setting will remain indefinitely.
| Note: | The default value for the n-tier option is OFF. |
This option is provided to allow queries to be posted to the DB2 Query Patroller server without requiring user intervention. This environment variable can be set to one of two values: