If you edit your configuration file manually, check the cache, pool, and wash sizes carefully. Certain configuration file errors can cause start-up failure:
The total size of all of the caches cannot be greater than the amount of max memory, minus other Adaptive Server memory needs.
The total size of the pools in any cache cannot be greater than the size of the cache.
The wash size cannot be too small (less than 20 percent of the pool size, with a minimum of 10 buffers) and cannot be larger than 80 percent of the buffers in the pool.
The default data cache status must be “default data cache,” and the size must be specified, either as a numeric value or as “DEFAULT”.
The status and size for any cache must be specified.
The pool size and wash size for all pools larger than 2K must be specified.
The status of all user-defined caches must be “mixed cache” or “log only”.
The cache replacement policy and the asynchronous prefetch percentage are optional, but, if specified, they must have correct parameters or “DEFAULT”.
In most cases, problems with missing entries are reported as “unknown format” errors on lines immediately following the entry where the size, status, or other information was omitted. Other errors provide the name of the cache where the error occurred and the type of error. For example, you see this error if the wash size for a pool is specified incorrectly:
The wash size for the 4k buffer pool in cache pubs_cache has been incorrectly configured. It must be a minimum of 10 buffers and a maximum of 80 percent of the number of buffers in the pool.
