这意味着DB2按顺序在表空间上提取每一个数据页面到缓冲池。
This means that DB2 fetches every data page in the table space sequentially into the buffer pool.
具有大型缓冲池的环境也可能需要配置更多页面清洗器。
Environments with large buffer pools might also require more page cleaners to be configured.
在不需要进行频繁备份的情况下可以这么做,或者在DB2之外执行复制活动之前强制发生变更的页面离开缓冲池。
You would want to do this on situations where frequent backups are not possible, or to force changed pages off buffer pools before performing copy activities outside DB2.
在db2缓冲池中数据页面也保持压缩的,为了潜在的重用允许更多的数据缓存在内存中。
A data page also remains compressed in the DB2 buffer pool there by allowing more data to be cached in memory for potential reuse.
该参数指定为审计缓冲分配的4K大小的页面的数量。
This parameter specifies the number of 4k pages to allocate to audit buffering.
数据和索引页面的击中率反映了缓冲池在不需要磁盘I/O的情况下直接处理一个页面请求的时间量。
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.
一个缓冲池可满足的页面请求越多,将得到越高的查询性能。
The more page requests that can be satisfied by a buffer pool, the better query performance will be.
通过12000个4K页面的更大缓冲池,性能结果从每10秒完成43个事务增加到完成66个事务,如图4中所示。
With the bigger buffer pool of 12000 4k pages, the performance result improves from 43 completed transactions per 10 seconds to 66 completed transactions, as shown in Figure 4.
您必须根据您想要的页面大小选择一个缓冲池名称,并通过- ALTERBUFFER POOL命令激活它。
You must choose a buffer pool name according to the page size you want and activate it through -alter BUFFERPOOL command.
一旦提取到DB2 的缓冲池,将扫描在这些页面上的记录并应用阶段 1 谓词。
Once fetched into DB2 buffer pools, records in these pages are scanned and the stage-1 predicate is applied.
出于这些理由,在DB 2中创建新数据库时,会创建一个支持4KB页面的默认缓冲池。
For these reasons, a default buffer pool is created that supports a 4 KB page when a new database is created in DB2.
然后通过FETCH节点获取合格的RID以提取来自表格空间的相应记录和数据页面到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.
这使得您可以选择需要的任何页面大小,并且在整个数据库仍然维护一个缓冲池和统一的页面大小。
This gives you the ability to choose any page size you want, and still maintain a single buffer pool and uniform page size across the database.
对于具有大于一个页面大小的表空间的数据库而言,需要创建具有匹配页面大小的附加缓冲池。
For a database that has table Spaces of more than one page size, additional buffer pools with matching page sizes need to be created.
在用统一的页面大小创建数据库时,只需要一个匹配该页面大小的缓冲池(即使它不是4KB)。
When you create a database with a uniform page size, only one buffer pool to match this page size is required (even if it isn't a 4 KB).
检查点是指数据库服务器在特定的时间点对磁盘上的页面和共享内存缓冲区中的页面进行同步。
A checkpoint refers to a point when the database server synchronizes the pages on disk with the pages in the shared-memory buffers.
另一方面,数据库代理需要缓冲池中的空间之前,页面清洗器将已修改的页面从缓冲池写入磁盘。
Page cleaners, on the other hand, write changed pages from the buffer pool to disk before the space in the buffer pool is required by a database agent.
分页是为了使页面大小适合设备缓冲可接受的限制而将单个页面分解成多个页面的过程。
Pagination is the process of breaking a single page into multiple pages in order to fit the page size within acceptable limits of the device buffer.
创建缓冲池BP 5000个页面,大小16K。
通过250个页面的缓冲池大小,应用程序测试运行呈现了48.69%的糟糕的缓冲池命中率。
With the buffer pool size of 250 pages, the application test run experienced very poor buffer pool hit ratio of 48.69%.
例如,页面大小为8kb的表空间只能使用页面大小为8kb的缓冲池。
For example, a table space with an 8kb page size can only use a buffer pool with page size of 8kb.
创建常规表空间TS页面,大小16K,由系统管理(fnis缓冲池BP)。
Create regular tablespace TS page, size 16k, managed by system using (FNIS buffer pool BP).
预抓取到缓冲池,但从未读取的页面数量。
Number of pages prefetched into the buffer pool, but never read.
缓冲池id、名称和页面大小。
db2pclnr:缓冲池页面清除程序。
db2exfmt输出将显示所有缓冲池中的页面总数为总的大小。
The db2exfmt output would show the total size as the sum of the number of pages in all the bufferpools.
图3显示了用一个包含250个4K页面的缓冲池所完成的事务数目:(注意:您系统上的性能结果可能不同。)
Figure 3 shows the number of transactions completed with one buffer pool of 250 4k pages: (Note: Performance results may differ on your system.)
缓冲池必须具有相同的页面大小(pagesize)。
Memknobs分配一个固定大小的缓冲区,循环遍历缓冲区页面,写到每一页上。
Memknobs allocates a fixed-sized buffer and loops through that buffer's pages, writing to each one.
虚拟内存段还包含字典缓存器,存储过程缓存器,以及在向磁盘一次性写入大块页面时使用到的较大的缓冲池。
Virtual segment also contains dictionary cache, stored procedures cache, and big buffer pools used for writing large block of pages to disk at once.
应用推荐