Error 5867

Severity

16

Message text

The wash size for the %dk buffer pool in cache %s has been incorrectly configured. It must be a minimum of %d buffers and a maximum of %d percent of the number of buffers in the pool.

Explanation

Wash size is the point in the cache at which Adaptive Server writes dirty pages to disk. You can use sp_poolconfig to place an entry in the configuration file to specify a wash size for a memory pool.

The default value for wash size depends on your server version. For example, in 11.5 the default wash size for a pool size less than 300MB is 20 percent of the buffers in the pool. (A buffer is a block of pages equal to the I/O size of the pool. All pages in a buffer are read from disk, written to disk, or flushed from the cache simultaneously.)

The minimum value for wash size is 10 buffers and the maximum value is 80 percent of the size of the pool.

Error 5867 occurs when you specify a value for wash size that is smaller than the minimum allowed size or larger than the maximum allowed size.

This error occurs with the following states:

State

Meaning

1

Occurs when you run sp_configure with the verify or read option after specifying a value for wash size that is smaller than the minimum allowed size or larger than the maximum allowed size.

2

Occurs when you use sp_poolconfig or update the configuration file directly to specify a value for wash size and that value is smaller than the minimum allowed size or larger than the maximum allowed size.

Action

Determine a valid value for wash size for the buffer pool and cache specified in the error message and run your command again.

Additional information

Refer to the Reference Manual: Procedures for information about sp_poolconfig and wash sizes.

Refer to “Configuring Data Caches” in the System Administration Guide: Volume 2 for information about the wash area and wash configuration.

Versions in which this error is raised

All versions