However, if the total buffer size is too large, and there is not enough storage to allocate them, a minimum system buffer pool for each page size is allocated, and performance is sharply reduced.
但是,如果总的缓冲区大小太大,并且没有足够的存储器可用来分配给它们,那么将为每种页大小分配最少的缓冲池,性能就会急剧下降。
If rows are accessed randomly, then the smaller page size enables DB2 to make better use of the buffer, because more pages fit into the same storage area.
如果随机访问行,那么较小的页大小让db2可以更好地利用缓冲区,因为同样的存储区域可以容纳更多页。
If rows are accessed randomly, then the smaller page size enables DB2 to make better use of the buffer, because more pages fit into the same storage area.
如果随机访问行,那么较小的页大小让db2可以更好地利用缓冲区,因为同样的存储区域可以容纳更多页。
应用推荐