Error 855



Message text

Bad prefetch size of %d encountered.


On select, update, and delete statements, you can specify a prefetch size that specifies the I/O size in kilobytes for tables bound to caches for which large I/Os are configured. Valid values for size are 2K, 4K, 8K, and 16K. You must have configured the I/O size for the cache before you can specify it for a prefetch size. The procedure sp_helpcache shows the valid sizes for the cache to which an object is bound, or for the default cache.

When you specify a prefetch size, the Adaptive Server parser passes that value to the Buffer Manager. If the value you specified is not available, error 7380 (a warning) is raised, and processing continues with the prefetch size that the Adaptive Server optimizer determines to be the “best” value.

Error 855 occurs when:


Call Sybase Technical Support.

Versions in which this error is raised

All versions