This means that DB2 fetches every data page in the table space sequentially into the buffer pool.
这意味着DB2按顺序在表空间上提取每一个数据页面到缓冲池。
Use the database system monitor to help you tune this configuration parameter using information from the snapshot data (or event monitor) about write activity from a buffer pool.
使用数据库系统监视器，利用有关从缓冲池进行写操作的快照数据(或事件监视器)信息来帮助您调优该配置参数。
This provides a means to exploit the various thresholds to favor certain types of data access within a buffer pool.
这为利用各种阈值处理缓冲池中某些类型的数据访问提供了一种方法。
Thus, the read operations compete with log writing and the write operation for data pages from the buffer pool.
因而，读操作与日志写和缓冲池中的数据页的写操作之间存在竞争。
If you are working with large data sets, consider using a dedicated buffer pool for the table space.
如果是使用大型数据集，可考虑用专用的缓冲池来代替表空间。
Having more than one buffer pool can preserve data in the buffers.
拥有多个缓冲池可以将数据保存在缓冲区中。
If the buffer pool is large enough to keep the required data in memory, less disk activity will occur.
如果缓冲池大到足以在内存中保存所需数据，就会发生较少磁盘活动。
This calculation takes into account all of the pages (index and data) that are cached by the buffer pool.
这个计算考虑了缓冲池高速缓存的所有页(索引和数据)。
You will find that DB2 9 offers new buffer pool snapshot monitor elements for XML data that match the existing counters for relational data and indexes.
您将发现，与用于关系数据和索引的已有的计数器相对应，DB 29为XML数据提供了新的缓冲池快照监视器元素。
The hit ratios for data and index pages reflect the number of times a page request was handled by the buffer pool directly without requiring disk I/O.
数据和索引页面的击中率反映了缓冲池在不需要磁盘I/O的情况下直接处理一个页面请求的时间量。
If necessary, you can separate data and index into two different buffer pools to help ensure a good index buffer pool hit ratio.
如果必要，可以将数据和索引分隔到两个不同的缓冲池中，以帮助确保一个良好的索引缓冲池命中率。
A data page also remains compressed in the DB2 buffer pool there by allowing more data to be cached in memory for potential reuse.
在db2缓冲池中数据页面也保持压缩的，为了潜在的重用允许更多的数据缓存在内存中。
The qualifying RIDs are then taken by the fetch node to fetch the corresponding records and data pages from the table space into the DB2 buffer pool.
然后通过FETCH节点获取合格的RID以提取来自表格空间的相应记录和数据页面到db2缓冲池。
When multiple buffer pools are in use, the buffer pool snapshot data can be used to calculate the buffer pool hit ratio of each pool to indicate the effectiveness of each buffer pool.
当多个缓冲池同时在用时，缓冲池快照数据可用于计算每个缓冲池的命中率，来表示每个缓冲池的有效性。
A desirable goal for your buffer pool hit ratio is 80% or higher for data, and 90% or higher for index.
您的缓冲池命中率的理想目标是数据80%或更高，索引90%或更高。
Since a DB2 buffer pool is a part of the main memory of the system, the DB2 database manager allocates it for caching tables and index data when it reads or writes to and from media disks.
因为db2缓冲池是系统主内存的一部分，DB 2数据库管理器在它读取或写入磁盘介质时将它分配给缓存表和索引数据。
Buffer pool data writes is much greater than Asynchronous pool data page writes.
缓冲池数据写远远大于异步池数据页写。
The defragmenter USES the buffer pool for this movement in order to keep the data in sync with other USES.
在移动时，碎片整理程序会采用缓存池来保持与其他使用的同步。
Buffer pool data writes is approximately equal to Asynchronous pool data page writes.
缓冲池数据写约等于异步池数据页写。
Buffer Pool - Memory allocated to store data before flushing it to disks.
缓冲池——在将数据刷新到磁盘之前，为存储数据而分配的内存。
Buffer pool activity, including table space and table information based on DB2 snapshot data.
缓冲池活动，包括基于DB 2快照数据的表空间和表信息。
Typically, in a MDM Server implementation, if you start with one big buffer pool for both data and index you should be fine.
通常，在一个MDMServer实现中，如果您一开始就对数据和索引使用一个大缓冲池，那么应该不会出现问题。
PWH.BUFFERPOOL for buffer pool snapshot data.
BUFFER POOL针对缓冲池快照数据。
Dbrun.snap - This script provides the hit ratio for the data and index pages of every buffer pool.
perl buffhitratio . pl dbrun. snap——该脚本提供了每个缓冲池的数据和索引页命中率。
For example, assume that Member 1 in Figure 1 wants to read a data page that isn't in its local buffer pool.
例如，假设图1中Member 1要读取不在它本地缓冲池中的数据页。
Buffer pool data physical reads (defined in units of tablespace page size).
缓冲池数据物理读数(以表空间页宽为单位定义)。
The buffer pool should be large enough to keep the required data in memory so that hard disk drive activity can be reduced.
缓冲池应该大到足以在内存中保留所需的数据，以便减少硬盘驱动器的活动。
As a result, compression allows more data to be in memory than without compression, which increases the buffer-pool hit ratio and makes higher utilization of the available memory.
因此，相比不压缩，压缩能让内存存储更多的数据，进而提高了缓冲池命中率和可用内存的利用率。
By combining data from filemon, iostat, and DB2 snapshot monitoring with a buffer pool monitoring switch, you can develop the following information.
通过将来自filemon、iostat和DB 2快照监视的数据与缓冲池监视开关相结合，可以得到以下信息。
Whether to adjust the size of the buffer pool based on run-time performance characteristics, such as the amount of time the system spends compressing and uncompressing data.
根据当前的性能状况是否要调整buffer pool的大小，例如对压缩和非压缩的状况分别统计系统花费的时间。
应用推荐