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.
这意味着它们将使用相同的页宽并在同一个缓冲池中进行缓冲。
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.
但是,如果总的缓冲区大小太大,并且没有足够的存储器可用来分配给它们,那么将为每种页大小分配最少的缓冲池,性能就会急剧下降。
If there are table Spaces with different page sizes, there must be at least one buffer pool per page size.
如果有一些具有不同页大小的表空间,那么每种页大小必须至少有一个缓冲池。
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.
在默认情况下,系统并不为大页面物理内存池分配任何内存。
For every different page size tablespace, there should be a matching page size 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.
这使得您可以选择需要的任何页面大小,并且在整个数据库仍然维护一个缓冲池和统一的页面大小。
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.
相反,表的页宽是由相应的缓冲池的页宽来确定的,这个缓冲池也就是为包含该表的表空间所指定的缓冲池。
When the page cache was moved into its own pool, the cache misses dropped about 50%.
当该页面缓存转移到其自己的池之后,缓存未命中降低了将近50%。
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)。
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.
在数据库代理程序需要缓冲池中的空间之前,这些页清除程序将缓冲池中已更改的页写到磁盘。
The more page requests that can be satisfied by a buffer pool, the better query performance will be.
一个缓冲池可满足的页面请求越多,将得到越高的查询性能。
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的情况下直接处理一个页面请求的时间量。
You must choose a buffer pool name according to the page size you want and activate it through -alter BUFFERPOOL command.
您必须根据您想要的页面大小选择一个缓冲池名称,并通过- ALTERBUFFER POOL命令激活它。
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,两者是相同的。
This parameter determines the threshold percentage of dirty pages in the buffer pool at which page cleaning will be initiated.
这个参数决定缓冲池中脏页的阈值百分比,当脏页达到这个百分比时,就会启动页清除。
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。
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.
另一方面,数据库代理需要缓冲池中的空间之前,页面清洗器将已修改的页面从缓冲池写入磁盘。
When the user submits input on the web page (Figure 34), this allocates a connection from the connection pool and drives the IO, which in turn drives the macro and the host application.
当用户在网络页面上提交输入(图34)时,它会从联系汇处分配一个联系,并驱动IO,这又反过来驱动宏以及主机程序。
Buffer pool data writes is much greater than Asynchronous pool data page writes.
缓冲池数据写远远大于异步池数据页写。
Buffer pool index writes is much greater than Asynchronous pool index 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的缓冲池。
Buffer pool data writes is approximately equal to Asynchronous pool data page writes.
缓冲池数据写约等于异步池数据页写。
Buffer pool index writes is approximately equal to Asynchronous pool index page writes.
缓冲池索引写约等于异步池索引页写。
Create buffer pool BP 5000 page, size 16k.
创建缓冲池BP 5000个页面,大小16K。
Create regular tablespace TS page, size 16k, managed by system using (FNIS buffer pool BP).
创建常规表空间TS页面,大小16K,由系统管理(fnis缓冲池BP)。
Buffer pool ID, name, and page size.
缓冲池id、名称和页面大小。
应用推荐