Increase the buffer pool size.
增加缓冲池大小。
Proper size for the buffer pool.
为缓冲池设置适当的大小。
Db2pclnr: For buffer pool page cleaners.
db2pclnr:缓冲池页面清除程序。
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).
缓冲池的当前大小(页面数)。
Number of table spaces using the buffer pool
使用缓冲池的表空间数
PWH.BUFFERPOOL for buffer pool snapshot data.
BUFFER POOL针对缓冲池快照数据。
Why not allocate a bigger buffer pool instead?
为什么不分配一个更大的缓冲池呢?
Each database requires at least one buffer pool.
每个数据库都至少需要一个缓冲池。
Increase the buffer pool size online as follows.
联机增加缓冲池大小,如下。
In this example, the buffer pool cluster was used.
本例使用了缓冲池集群。
DB2 reserves a slot in the buffer pool for the page.
DB 2在用于该页的缓冲池中预留一个位置。
Why not create a bigger buffer pool instead, you may ask.
那么您可能要问,为什么不创建一个更大的缓冲池呢。
Pay close attention to your overall buffer pool hit ratio.
密切关注您的总体缓冲池命中率。
Attempt to reduce buffer pool sizes for both databases. Or.
尝试减少这两个数据库的缓冲池大小。
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.
最值得注意的是对缺省缓冲池大小的修改。
This requires the appropriate index pages to be in the buffer pool.
这要求在缓冲池中存在适当的索引页。
Create DB2 database, buffer pool, and tablespace with more than 4k.
创建DB 2数据库、缓冲池和表空间,使用大于4k的页面大小。
In this case, we will trace only the buffer pool services component.
在本例中,我们将只跟踪缓冲池服务组件。
Database records are read and updated in the buffer pool area of memory.
数据库记录是在内存的缓冲池区域里被读取和更新的。
The purpose of the buffer pool is to improve database system performance.
缓冲池的用途是为了提高数据库系统的性能。
Filter conditions, such as buffer pool name, table space name, table name.
过滤条件,如缓冲池名、表空间名、表名。
应用推荐