Error 7380

Severity

10

Message text

WARNING: Line %d. Invalid value for '%S_MSG' specified.  This value will be ignored, default value will be used instead.

Explanation

You can specify a prefetch size on select, update, and delete statements for tables bound to caches with large I/O pools. Specify the prefetch size as the I/O size in kilobytes. Valid values for prefetch size are 2K, 4K, 8K, and 16K. The procedure sp_helpcache shows pools and their sizes for the cache to which an object is bound, or for the default cache.

Error 7380 occurs when the prefetch size you specify is invalid. When this error occurs, Adaptive Server continues processing and the optimizer substitutes the “best” prefetch size available.

Action

You must specify a prefetch size of 2K, 4K, 8K, or 16K. In addition, if the object is bound to a cache, make sure you use a valid prefetch size for that cache. Use sp_helpcache to see pools and their sizes for the cache to which the object is bound.

Additional information

See the Adaptive Server Enterprise reference manuals and performance and tuning guides for information about using prefetch sizes.

Versions in which this error is raised

All versions