384 HA Architectures & Capacity Planning with WebSphere Remote Server V6
available to write dirty pages to disk. This is also true when there are many
data-page or index-page writes in relation to the number of asynchronous
data-page or index-page writes.
Consider the following factors when setting the value for DB parameter
NUM_IOCLEANERS:
Application type
– If a query-only database will not have updates, set this parameter to be
zero (0). The exception is if the query workload results in many TEMP
tables being created. You can determine this by using the Explain utility.
– If transactions are run against the database, set this parameter to be
between one and the number of physical storage devices used for the
database.
Workload
Environments ...