This means that DB2 fetches every data page in the table space sequentially into the buffer pool.
这意味着DB2按顺序在表空间上提取每一个数据页面到缓冲池。
This means they use the same page size and are buffered in the same buffer pool.
这意味着它们将使用相同的页宽并在同一个缓冲池中进行缓冲。
If there are table Spaces with different page sizes, there must be at least one buffer pool per page size.
如果有一些具有不同页大小的表空间，那么每种页大小必须至少有一个缓冲池。
However, if the total buffer size is too large, and there is not enough storage to allocate them, a minimum system buffer pool for each page size is allocated, and performance is sharply reduced.
但是，如果总的缓冲区大小太大，并且没有足够的存储器可用来分配给它们，那么将为每种页大小分配最少的缓冲池，性能就会急剧下降。
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.
这使得您可以选择需要的任何页面大小，并且在整个数据库仍然维护一个缓冲池和统一的页面大小。
Rather, the page size for tables is determined by the page size of the buffer pool to which the table space containing the table is assigned.
相反，表的页宽是由相应的缓冲池的页宽来确定的，这个缓冲池也就是为包含该表的表空间所指定的缓冲池。
A database must have at least one buffer pool, and can have a number of buffer pools depending on the workload characteristics, database page sizes used in the database, etc.
一个数据库必须至少有一个缓冲池，并且可以有多个缓冲池，这要视工作负载的特征、数据库中使用的数据库页面大小等因素而定。
This parameter determines the threshold percentage of dirty pages in the buffer pool at which page cleaning will be initiated.
这个参数决定缓冲池中脏页的阈值百分比，当脏页达到这个百分比时，就会启动页清除。
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缓冲池中数据页面也保持压缩的，为了潜在的重用允许更多的数据缓存在内存中。
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).
在用统一的页面大小创建数据库时，只需要一个匹配该页面大小的缓冲池(即使它不是4KB)。
A database must have at least one buffer pool, and can have a number of buffer pools depending on such things as the workload characteristics and database page sizes used in the database.
一个数据库必须至少有一个缓冲池，并且可以有多个缓冲池，具体要视工作负载的特征、数据库中使用的数据库页面大小等因素而定。
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的情况下直接处理一个页面请求的时间量。
The more page requests that can be satisfied by a buffer pool, the better query performance will be.
一个缓冲池可满足的页面请求越多，将得到越高的查询性能。
You must choose a buffer pool name according to the page size you want and activate it through -alter BUFFERPOOL command.
您必须根据您想要的页面大小选择一个缓冲池名称，并通过- ALTERBUFFER POOL命令激活它。
These page cleaners write changed pages from the buffer pool to disk before the space in the buffer pool is required by a database agent.
在数据库代理程序需要缓冲池中的空间之前，这些页清除程序将缓冲池中已更改的页写到磁盘。
For example, if you create a new database with an 8 KB page size, the default buffer pool for all the table Spaces will be 8 KB.
例如，如果用8KB页面大小创建一个新的数据库，那么所有表空间默认的缓冲池将是8 KB。
For these reasons, a default buffer pool is created that supports a 4 KB page when a new database is created in DB2.
出于这些理由，在DB 2中创建新数据库时，会创建一个支持4KB页面的默认缓冲池。
Note that the page sizes of 8K for the buffer pool and table space are the same.
请注意，缓冲池和表空间的页大小都是8K，两者是相同的。
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.
另一方面，数据库代理需要缓冲池中的空间之前，页面清洗器将已修改的页面从缓冲池写入磁盘。
Buffer pool index writes is much greater than Asynchronous pool index page writes.
缓冲池索引写远远大于异步池索引页写。
Buffer pool data writes is much greater than Asynchronous pool data page writes.
缓冲池数据写远远大于异步池数据页写。
For example, a table space with an 8kb page size can only use a buffer pool with page size of 8kb.
例如，页面大小为8kb的表空间只能使用页面大小为8kb的缓冲池。
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.
例如，如果您具有一个2GB的缓冲池，当达到60%的修改页面时，在触发页面清洗器时就有1.2 GB (2 GB的60%)将写入磁盘。
Create regular tablespace TS page, size 16k, managed by system using (FNIS buffer pool BP).
创建常规表空间TS页面，大小16K，由系统管理(fnis缓冲池BP)。
You can also use the new BUFFERPOOL configuration parameter to create a buffer pool that corresponds to the page size of the dbspace.
也可以使用新增的BUFFER POOL配置参数创建与dbspace页大小对应的缓冲池。
The output shows that the BANK database has a single buffer pool (IBMDEFAULTBP) defined, which has 250 pages (NPAGES) with a 4096-byte page size (PAGESIZE).
输出显示BANK数据库定义了一个缓冲池(IBMDEFAULTBP)，该缓冲池具有250个页面(NPAGES)，每个页面大小(PAGESIZE)为4096字节。
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要读取不在它本地缓冲池中的数据页。
Writes Cache: Parentage of time that a page was written to the buffer pool but not to disk.
WritesCache：页面写到缓冲区池(而不是磁盘)的次数百分比。
Db2 page Cleaner (db2pclnr) : Equivalent to DBWR process in Oracle, this process cleans the buffer pool before pages from the disk are moved into the BP.
db 2PageCleaner (db2pclnr)：相当于Oracle中的DBWR进程，该进程在将页从磁盘上转移到BP中之前，清理缓冲池。
Buffer Reads: Number of times a page has been read from the buffer pool and not read from disk.
BufferReads：从缓冲区池(而不是磁盘)读取的页面数量。
应用推荐