Recovery Text: |
Parallel table preload can improve the performance of queries. Even
though the access plan was created to use parallel preload, the system will
actually use parallel preload only if the following are true: - The query attribute degree must have been specified with an option of
*IO or *ANY for the application process.
- There is enough main storage available to load all of the data in the
file into active memory. Normally, 5 megabytes would be a minimum. Increasing
the size of the shared pool may improve performance.
For more information about parallel table preload, refer to Data access on DB2 UDB for iSeries: data access paths and methods. |