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.
这意味着它们将使用相同的页宽并在同一个缓冲池中进行缓冲。
Environments with large buffer pools might also require more page cleaners to be configured.
具有大型缓冲池的环境也可能需要配置更多页面清洗器。
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.
这使得您可以选择需要的任何页面大小,并且在整个数据库仍然维护一个缓冲池和统一的页面大小。
Requests for subsequent rows on that page are filled from the buffer until all the rows on that page are processed.
对该页上的后续行的请求都可以在这个缓冲区中得到满足,直到将该页上的所有行都处理完为止。
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 data page also remains compressed in the DB2 buffer pool there by allowing more data to be cached in memory for potential reuse.
在db2缓冲池中数据页面也保持压缩的,为了潜在的重用允许更多的数据缓存在内存中。
If rows are accessed randomly, then the smaller page size enables DB2 to make better use of the buffer, because more pages fit into the same storage area.
如果随机访问行,那么较小的页大小让db2可以更好地利用缓冲区,因为同样的存储区域可以容纳更多页。
For a database that has table Spaces of more than one page size, additional buffer pools with matching page sizes need to be created.
对于具有大于一个页面大小的表空间的数据库而言,需要创建具有匹配页面大小的附加缓冲池。
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.
一个数据库必须至少有一个缓冲池,并且可以有多个缓冲池,这要视工作负载的特征、数据库中使用的数据库页面大小等因素而定。
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)。
Environments with large buffer pools may also require more page cleaners to be configured.
在具有大缓冲池的环境下,也可能需要配置较多的页清除程序。
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.
缓冲池数据写远远大于异步池数据页写。
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的情况下直接处理一个页面请求的时间量。
This parameter determines the threshold percentage of dirty pages in the buffer pool at which page cleaning will be initiated.
这个参数决定缓冲池中脏页的阈值百分比,当脏页达到这个百分比时,就会启动页清除。
The more page requests that can be satisfied by a buffer pool, the better query performance will be.
一个缓冲池可满足的页面请求越多,将得到越高的查询性能。
Fewer buffer pools and table Spaces and fewer distinct page sizes lead to a simpler physical database design which is easier to manage, maintain, and tune.
更少的缓冲池和表空间,以及更少的页宽种类,可以导致更简单的物理数据库设计,从而更容易管理、维护和调优。
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.
在数据库代理程序需要缓冲池中的空间之前,这些页清除程序将缓冲池中已更改的页写到磁盘。
You must choose a buffer pool name according to the page size you want and activate it through -alter BUFFERPOOL command.
您必须根据您想要的页面大小选择一个缓冲池名称,并通过- ALTERBUFFER POOL命令激活它。
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页面的默认缓冲池。
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.
分页是为了使页面大小适合设备缓冲可接受的限制而将单个页面分解成多个页面的过程。
Note that the page sizes of 8K for the buffer pool and table space are the same.
请注意,缓冲池和表空间的页大小都是8K,两者是相同的。
Every vertical blank, the hypervisor DMAs this buffer to the GPU memory, and then flips the GPU's visible page to the new data synchronously with the vertical blank signal.
对于垂直方向上的每个空格来说,管理程序都会采用 DMA 方式将自己的缓冲区读到GPU 的内存中,然后将 GPU的可视页刷新为与垂直空格信号同步的数据。
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.
另一方面,数据库代理需要缓冲池中的空间之前,页面清洗器将已修改的页面从缓冲池写入磁盘。
For example, a table space with an 8kb page size can only use a buffer pool with page size of 8kb.
例如,页面大小为8kb的表空间只能使用页面大小为8kb的缓冲池。
Four small buffer pools of page size 4k, 8k, 16k and 32k are allocated when a database is started.
当数据库启动时,要分配4个页宽分别为4k、8 K、16k和32 K的小型缓冲池。
应用推荐