Increase the buffer pool size.
增加缓冲池大小。
Proper size for the buffer pool.
为缓冲池设置适当的大小。
Buffer pool ID, name, and page size.
缓冲池id、名称和页面大小。
Buffer pool must have same pagesize.
缓冲池必须具有相同的页面大小(pagesize)。
Create buffer pool BP 5000 page, size 16k.
创建缓冲池BP 5000个页面,大小16K。
A table space can only use one buffer pool.
一个表空间只能使用一个缓冲池。
Current size of the buffer pool (in pages).
缓冲池的当前大小(页面数)。
PWH.BUFFERPOOL for buffer pool snapshot data.
BUFFER POOL针对缓冲池快照数据。
Why not allocate a bigger buffer pool instead?
为什么不分配一个更大的缓冲池呢?
Increase the buffer pool size online as follows.
联机增加缓冲池大小,如下。
A new page needs to be read into the buffer pool.
新的页需要被读入缓冲池。
Create a new table space that USES the new buffer pool.
创建一个使用这个新缓存池的新表格空间。
Why not create a bigger buffer pool instead, you may ask.
那么您可能要问,为什么不创建一个更大的缓冲池呢。
Pay close attention to your overall buffer pool hit ratio.
密切关注您的总体缓冲池命中率。
Each DB2 database must have at least one single buffer pool.
每一个DB 2数据库都必须至少拥有一个缓冲池。
The above example shows a good buffer pool hit ratio of 98.4%.
以上示例显示了98.4%的良好缓冲池命中率。
Number of pages prefetched into the buffer pool, but never read.
预抓取到缓冲池,但从未读取的页面数量。
In general, a buffer pool hit ratio above 80% is considered good.
一般情况下,缓冲池命中率在80%以上就认为是良好的。
For a 64-bit system, the buffer pool can be practically any size.
对于64位系统,缓冲池实际上可以是任何大小。
Having more than one buffer pool can preserve data in the buffers.
拥有多个缓冲池可以将数据保存在缓冲区中。
Thus, provide sufficient buffer pool space to support index reads.
因此,应提供足够的缓冲池空间来支持索引读操作。
Most notably is the change of the size of the default buffer pool.
最值得注意的是对缺省缓冲池大小的修改。
The purpose of the buffer pool is to improve database system performance.
缓冲池的用途是为了提高数据库系统的性能。
Filter conditions, such as buffer pool name, table space name, table name.
过滤条件,如缓冲池名、表空间名、表名。
To determine the buffer pool size in the database, take a look at Listing 3.
为了确定数据库中的缓冲池大小,请查看清单3。
Use a large buffer pool, especially if indexes must be built during the Inserts.
使用大的缓冲池,如果必须在Insert期间建立索引的话,更应如此。
Is your Buffer Pool specification initialized to a value, and is it too small?
是否为缓冲区池指定了大小,这个值是否太小?
Buffer pool data writes is approximately equal to Asynchronous pool data page writes.
缓冲池数据写约等于异步池数据页写。
Buffer pool index writes is approximately equal to Asynchronous pool index page writes.
缓冲池索引写约等于异步池索引页写。
For every different page size tablespace, there should be a matching page size buffer pool.
对于每个不同页大小的表空间,应该存在一个页大小相匹配的缓冲池。
应用推荐