LRU alternate buffer pool force skips (-lru2skips)
Operating system and syntax
UNIX Windows
-lru2skips n
Use with
Maximum value
Minimum value
Single-user default
Multi-user default
DBS
2GB
0
–
0
n
The number of times to access a buffer before moving it to the end of the LRU chain.
Use LRU alternate buffer pool force skips (-lru2skips) to specify the number of times a buffer in the alternate buffer pool is accessed before it is placed on the Most Recently Used (MRU) end of the LRU chain. Specifying the LRU alternate buffer pool skip parameter is helpful when high LRU latch wait timeouts are occurring (observable in PROMON or by VST) in the alternate buffer pool. Accessing a buffer a specified number of times eliminates the need to acquire the LRU latch each time a buffer is accessed. When the LRU alternate buffer pool skip value is tuned to your environment, contention on the LRU latch decreases, improving concurrency and performance, and there is no increase in the number of page misses in the buffer pool. If increasing the LRU skip value causes increased buffer pool misses, then the value should be tuned down or turned off altogether. Setting -lru2skips to zero disables the feature, and is the default.
Note: This parameter is only available for databases with an Enterprise license. LRU force skips is not implemented for private buffer pool data access.