DB2 Version 9.7 for Linux, UNIX, and Windows

seqdetect - Sequential detection flag configuration parameter

This parameter controls whether the database manager is allowed to detect sequential page reading during I/O activity.

Configuration type: Database
Parameter type: Configurable online
Propagation class: Immediate
Default [range]: Yes [Yes; No ]

The database manager can monitor I/O, and if sequential page reading is occurring the database manager can activate I/O prefetching. This type of sequential prefetch is known as sequential detection.

If this parameter is set to No, prefetching takes place only if the database manager knows it will be useful, for example table sorts, table scans, or list prefetch.

Recommendation: In most cases, you should use the default value for this parameter. Try turning sequential detection off, only if other tuning efforts were unable to correct serious query performance problems.