Sequential prefetch (PREFETCH='S')
Sequential prefetch is used for table scans. The maximum number of pages read by a request issued from your application program is determined by the size of the buffer pool used.
For certain utilities (LOAD, REORG, RECOVER), the prefetch quantity can be twice as much.
When sequential prefetch is used
Sequential prefetch is used
only for table space scans. When Db2
expects that sequential prefetch will probably be used, the value of the PREFETCH column is 'S.'
However, Db2 might use dynamic prefetch in
some cases if when the value of PREFETCH column is 'S.'