16
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:
A problem occurs with the passing of the prefetch value and
The prefetch size that is passed to the Buffer Manager is smaller than the minimum allowed size or larger than the maximum allowed size.
Call Sybase Technical Support.
All versions
