Db2pclnr: For buffer pool page cleaners.
db2pclnr：缓冲池页面清除程序。
Number of table spaces using the buffer pool
使用缓冲池的表空间数
Each database requires at least one buffer pool.
每个数据库都至少需要一个缓冲池。
In this example, the buffer pool cluster was used.
本例使用了缓冲池集群。
DB2 reserves a slot in the buffer pool for the page.
DB 2在用于该页的缓冲池中预留一个位置。
Attempt to reduce buffer pool sizes for both databases. Or.
尝试减少这两个数据库的缓冲池大小。
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.
数据库记录是在内存的缓冲池区域里被读取和更新的。
Buffer Write: Number of pages modified and sent back to the buffer pool.
BufferWrite：修改并发送回缓冲区池的页面数量。
Subsequent users may often find some of these resources in the buffer pool.
随后的用户则常常可以发现有些资源已经在缓冲池中。
You can filter on buffer pool name, partition number, and other properties.
您可以根据缓冲池名称、分区编号和其他属性进行过滤。
Generate buffer pool, tablespace, and database partition group information.
生成缓冲池、表空间和数据库分区组信息。
It then scans each record in the buffer pool to apply the stage-1 predicate.
然后其在缓冲池上扫描每一条记录以便应用阶段1谓词。
The buffer pool hit ratio = (1 - (1838 + 50) / (269482 + 82)) * 100% = 99.29%
缓冲池命中率 = (1- (1838 +50) / (269482 + 82)) * 100% = 99.29%
The buffer pool hit ratio = (1- (273548 + 52) / (183925 + 82)) * 100% = 48.69%
缓冲池命中率 = (1- (273548 +52) / (183925 + 82)) * 100% = 48.69%
Note that the page sizes of 8K for the buffer pool and table space are the same.
请注意，缓冲池和表空间的页大小都是8K，两者是相同的。
It is mentioned earlier that ESTORE is used to extend the size of a buffer pool.
前面已提到，ESTORE是用于扩展缓冲池的大小。
These types of columns are unique in that they are not cached in the buffer pool.
这些类型的列是惟一的，它们不会缓存在缓冲池中。
Tracing can be restricted to a particular component (such as buffer pool services).
可以将跟踪限定到一个特定的组件(例如缓冲池服务)。
When a tablespace is created, it is assigned to the default buffer pool IBMDEFAULTBP.
在创建表空间的时候，会指派一个默认的缓冲池IBMDEFAULTBP。
Use one buffer pool, but increase its size until the index hit ratio stops increasing.
使用一个缓冲池，但是增加其大小直至索引命中率停止增长。
The accounting reports show the number of GETPAGES and synchronous reads per buffer pool.
会计报表显示对应于每个缓冲池的GETPAGES和同步读的数量。
The DBA can map the buffer pool to the tablespace when creating or altering the tablespace.
DBA在创建或更改表空间时可以将缓冲池映射到该表空间。
Create regular tablespace TS page, size 16k, managed by system using (FNIS buffer pool BP).
创建常规表空间TS页面，大小16K，由系统管理(fnis缓冲池BP)。
To find out which buffer pool is assigned to table Spaces, run the query shown in Listing 8.
要找出哪个缓冲池被分配给了表空间，请运行清单8中所示的查询。
If the hit ratio is low, increasing the number of buffer pool pages may improve performance.
如果命中率较低，则可以增加缓冲池页数来提高性能。
What happens if you increase the buffer pool size to 20,000 4K pages and run PERFORMER again?
如果将缓冲池大小增加到 20,000 个4K页面并重新运行 PERFORMER，那将会发生什么情况呢？
We recommend you keep increasing the buffer pool size until you see diminishing improvements.
我们建议您不断增加缓冲池大小，直到看到不再有性能提高。
应用推荐