Following is new information that is to be added to specified sections of the book:
In Chapter 2, Administration, section: Parameters:
IWM_LOCAL_SERVANTS By default, the start program (iwm) starts five iwm_local processes. If a different number of iwm_local processes is required, set the IWM_LOCAL_SERVANTS environment variable to that number before invoking the start program (iwm).
In Chapter 4, Using the Command Line Interface, section: Submit Command (iwm_submit):
When executing a Select statement against a lowercase table or column name using iwm_submit, the Select statement must be defined in an SQL statement file (sql_stmt_file) and submitted using the -F parameter. See Table 4. iwm_submit Parameter Descriptions for information on the -F parameter and SQL statement files.
In Chapter 4, Using the Command Line Interface, section: Monitoring and Controlling Nodes:
If the iwm_cmd is used to stop node manager processes, the Server or Agent component must be stopped and restarted to turn the node manager processes on again.
In Chapter 5, Error Log Monitoring, section: Running the Log Monitor:
If the IWM_LOGMON environment variable is already set, the iwm_logmon command can only be invoked using the start program (iwm). If the IWM_LOGMON environment variable is set, any invocation of the "iwm_logmon -c <configuration_file> command will cause an error to occur and iwm_logmon will fail to run.
In Chapter 9, Configuring the DB2 Query Patroller Client, section: Client Configuration Options:
The DB2IWM.INI file contains an n-tier configuration option that allows
queries to be posted to the DB2 Query Patroller server without requiring
user intervention. When this option is set, the user may also specify a
result destination for queries by setting the "LastResultDestination" variable.
LastResultDestination = { None| <Result Destination Name>}
-"None" is the default value and directs the result set to a DB2 table.
-"Result Destination Name" is the value set for the Destination Name field on the
Result Set Administration page of the QueryAdministrator utility.
There is an error in the documentation for the n-tier option. "DB2_IWM_SUBMITWAIT variable" should read "n-tier option".
In Chapter 12, User Administration, section: Creating a User Profile:
This release of DB2 Query Patroller will not support user groups. Because a group cannot be added to the User Profile table, a profile for each user of DB2 Query Patroller must be individually added to the User Profile table. This action is performed using the User Administration page of the QueryAdministrator utility.