• This means that DB2 fetches every data page in the table space sequentially into the buffer pool.

    意味着DB2按顺序空间上提取每一个数据页面缓冲

    youdao

  • This means they use the same page size and are buffered in the same buffer pool.

    意味着它们将使用相同同一个缓冲池中进行缓冲。

    youdao

  • 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.

    但是如果总的缓冲区大小并且没有足够的存储器可用分配给它们,那么将每种大小分配最少缓冲性能会急剧下降。

    youdao

  • If there are table Spaces with different page sizes, there must be at least one buffer pool per page size.

    如果一些具有不同大小空间那么每种大小必须至少一个缓冲

    youdao

  • Yet another change was creating a separate cache pool for the page cache.

    还有另一个改动页面缓存创建单独的缓存

    youdao

  • By default, the system does not allocate any memory to the large page physical memory pool.

    默认情况下,系统并不页面物理内存分配任何内存。

    youdao

  • For every different page size tablespace, there should be a matching page size buffer pool.

    对于每个不同大小表空间应该存在一个页大小相匹配缓冲

    youdao

  • 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.

    使得可以选择需要任何页面大小并且整个数据库仍然维护缓冲统一的页面大小。

    youdao

  • 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.

    相反由相应缓冲的页宽确定的,这个缓冲池也就是为包含该表空间所指定的缓冲池。

    youdao

  • When the page cache was moved into its own pool, the cache misses dropped about 50%.

    页面缓存转移自己的池之后,缓存未命中降低了将近50%。

    youdao

  • 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缓冲池中数据页面保持压缩的,为了潜在的重用允许更多的数据存在内存

    youdao

  • 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)。

    youdao

  • 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.

    数据库代理程序需要缓冲中的空间之前这些清除程序将缓冲池中已更改写到磁盘

    youdao

  • The more page requests that can be satisfied by a buffer pool, the better query performance will be.

    一个缓冲满足页面请求越多得到高的查询性能

    youdao

  • 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情况下直接处理一个页面请求时间

    youdao

  • You must choose a buffer pool name according to the page size you want and activate it through -alter BUFFERPOOL command.

    必须根据想要页面大小选择一个缓冲名称通过- ALTERBUFFER POOL命令激活

    youdao

  • 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页面的默认缓冲

    youdao

  • Note that the page sizes of 8K for the buffer pool and table space are the same.

    注意缓冲空间大小8K,两者是相同的。

    youdao

  • This parameter determines the threshold percentage of dirty pages in the buffer pool at which page cleaning will be initiated.

    这个参数决定缓冲阈值百分比,当脏页达到这个百分比时,就启动清除

    youdao

  • 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。

    youdao

  • 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.

    一方面,数据库代理需要缓冲中的空间之前页面清洗器将已修改页面缓冲池写入磁盘

    youdao

  • 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反过来驱动以及主机程序。

    youdao

  • Buffer pool data writes is much greater than Asynchronous pool data page writes.

    缓冲数据远远大于异步池数据写。

    youdao

  • Buffer pool index writes is much greater than Asynchronous pool index page writes.

    缓冲索引远远大于异步池索引写。

    youdao

  • For example, a table space with an 8kb page size can only use a buffer pool with page size of 8kb.

    例如页面大小8kb空间只能使用页面大小为8kb的缓冲

    youdao

  • Buffer pool data writes is approximately equal to Asynchronous pool data page writes.

    缓冲数据等于异步池数据写。

    youdao

  • Buffer pool index writes is approximately equal to Asynchronous pool index page writes.

    缓冲索引等于异步池索引写。

    youdao

  • Create buffer pool BP 5000 page, size 16k.

    创建缓冲BP 5000个页面大小16K

    youdao

  • Create regular tablespace TS page, size 16k, managed by system using (FNIS buffer pool BP).

    创建常规表空间TS页面大小16K系统管理(fnis缓冲BP)。

    youdao

  • Buffer pool ID, name, and page size.

    缓冲id名称页面大小

    youdao

$firstVoiceSent
- 来自原声例句
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定