Parser Errors (continued)

This section contains error messages for the Adaptive Server Parser.

Error 7380

Severity

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

Make sure the prefetch size you specify is 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

Refer to the Reference Manual and the Performance and Tuning Guide for information about using prefetch sizes.

Versions in which this error is raised

All versions