Prefetch factor (-prefetchFactor)

Operating system and syntax UNIX / Windows 
-prefetchFactor n
Use with Maximum value Minimum value Single-user default Multi-user default
DBS 100 0 – 100
n

The percent of a message buffer to fill before sending it to a waiting remote client.

Use Prefetch Factor (-prefetchFactor) to establish a percentage of a network message required to contain prefetched data before sending the message to a waiting remote client.

The number of records in a network buffer is also influenced by Prefetch Num Recs (-prefetchNumRecs) parameter. See Prefetch tuning for a discussion of the interaction between the parameters.

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.