您能够通过命名创建同每一个页面相对应的数据池。
You can create Datapools that correspond to each page by naming them accordingly.
具有大型缓冲池的环境也可能需要配置更多页面清洗器。
Environments with large buffer pools might also require more page cleaners to be configured.
这意味着DB2按顺序在表空间上提取每一个数据页面到缓冲池。
This means that DB2 fetches every data page in the table space sequentially into the buffer pool.
还有另一个改动是为页面缓存创建一个单独的缓存池。
Yet another change was creating a separate cache pool for the page cache.
在默认情况下,系统并不为大页面物理内存池分配任何内存。
By default, the system does not allocate any memory to the large page physical memory pool.
在不需要进行频繁备份的情况下可以这么做,或者在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.
数据和索引页面的击中率反映了缓冲池在不需要磁盘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.
通过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.
一个缓冲池可满足的页面请求越多,将得到越高的查询性能。
The more page requests that can be satisfied by a buffer pool, the better query performance will be.
出于这些理由,在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.
例如,如果您具有一个2GB的缓冲池,当达到60%的修改页面时,在触发页面清洗器时就有1.2 GB (2 GB的60%)将写入磁盘。
For example, if you had a 2 GB buffer pool, when 60% of changed pages is reached, 1.2 GB (60% of 2 GB) would be written to disk as page cleaners are triggered.
操作系统控制池的大小,并负责根据工作负载在压缩和未压缩池之间移动页面。
The operating system controls the pool sizes and is responsible for moving pages between the compressed and uncompressed pools based on workload.
创建缓冲池BP 5000个页面,大小16K。
创建常规表空间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:缓冲池页面清除程序。
WritesCache:页面写到缓冲区池(而不是磁盘)的次数百分比。
Writes Cache: Parentage of time that a page was written to the buffer pool but not to disk.
BufferWrite:修改并发送回缓冲区池的页面数量。
Buffer Write: Number of pages modified and sent back to the buffer pool.
BufferReads:从缓冲区池(而不是磁盘)读取的页面数量。
Buffer Reads: Number of times a page has been read from the buffer pool and not read from disk.
ReadCache:应该从缓冲区池读取的页面百分比。
Read Cache: Percentage of times the page should be read from the buffer pool.
可以使用vmo命令的lgpg_regions和lgpg_size选项配置大页面物理内存池的大小。
The vmo command can be used to configure the size of the large page physical memory pool using the lgpg_regions and lgpg_size options.
这时要特别小心,因为如果配置不当,则可能导致4KB或64 KB页面大小的池过度分页。
Do this with extreme caution, because over configuring the system with 16-megabyte or 16-gigabyte pages can lead to excessive paging of 4-kilobyte or 64-kilobyte page size pools.
图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.)
所显示的数目就是分配给数据库的缓冲池页面的总数目。
The number shown is the total number of buffer pool pages that are allocated for the database. For example, let's say we have the following buffer pools
这使得您可以选择需要的任何页面大小,并且在整个数据库仍然维护一个缓冲池和统一的页面大小。
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.
虚拟内存段还包含字典缓存器,存储过程缓存器,以及在向磁盘一次性写入大块页面时使用到的较大的缓冲池。
Virtual segment also contains dictionary cache, stored procedures cache, and big buffer pools used for writing large block of pages to disk at once.
应用推荐