|The following text should appear at the end of Chapter 6, Performance |Tuning:
|Using the BIND Option, INSERT BUF to Improve DB2 Query Patroller |Performance
|By default, DB2 Query Patroller creates result tables to store the results |of the queries it manages. To increase the performance of inserts to |these result tables, include the INSERT BUF option when binding one of the DB2 |Query Patroller bind files.
|Bind the DB2 Query Patroller bind files to the database as follows:
|From the DB2_RUNTIME\bnd directory on Windows, or the DB2_RUNTIME/bnd path |on UNIX, enter the following commands:
|db2 connect to database user iwm using password |db2 bind @db2qp.lst blocking all grant public |db2 bind iwmsx001.bnd insert buf |db2 bind @db2qp_sp.lst |db2 commit
|where database is the database the replacement database that |will be managed by DB2 Query Patroller, and password is the |password for the administrative user account, iwm.