Prefetch delay (-prefetchDelay)

Operating system and syntax UNIX / Windows
-prefetchDelay
Use with Maximum value Minimum value Single-user default Multi-user default
DBS 1

Use Prefetch delay (-prefetchDelay) to enable a delay when sending the first network message for queries with prefetch capabilities.

When you specify Prefetch delay, Prefetch Num Recs (-prefetchNumRecs) and Prefetch factor (-prefetchFactor) parameters determine the duration of the delay. Prefetch delay is on by default.

To change this parameter while the database is running, use PROMON or the _DbParams VST.

You can use this parameter to support continuous operation of the database. For more information, see Change database parameters while the database is running.