To configure Adaptive Server for the secondary cache, enter a value for the extended cache size configuration parameter. When the value of extended cache size is zero (the default), Adaptive Server does not use a secondary cache.
To enable the secondary cache, specify a size for the secondary cache in 2K pages. For example, to create a secondary cache of 1048576 2K pages (about 2GB) using sp_configure, enter:
sp_configure “extended cache size”, 1048576
When the secondary cache is enabled, Adaptive Server creates the file /dev/shm/<server_name><pid_number>.shm.
If a secondary data cache is enabled:
Adaptive Server deletes the secondary cache whenever Adaptive Server shuts down, or the value of extended cache size is reset to zero.
Adaptive Server creates a secondary cache whenever Adaptive Server starts up.
Zero is the default value. When the value of extended data cache is zero, Adaptive Server does not use the secondary data cache.
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
