• The minimum number of buffer pages is 18 and the maximum is 4096.

    缓冲区页面最少18大为 4097。

    youdao

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

    需要进行频繁备份情况可以这么或者DB2之外执行复制活动之前强制发生变更页面离开缓冲

    youdao

  • Thus, the read operations compete with log writing and the write operation for data pages from the buffer pool.

    因而操作日志缓冲池中的数据操作之间存在竞争

    youdao

  • This requires the appropriate index pages to be in the buffer pool.

    要求缓冲存在适当索引

    youdao

  • Increase the log buffer size to 256 pages or larger.

    日志缓冲区大小增加256个页面更大

    youdao

  • This recovery process instantly begins to prefetch dirty pages from the centralized buffer pool into its own local buffer pool.

    这个恢复进程立即开始集中式缓冲预取自己的本地缓冲池。

    youdao

  • 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可以更好地利用缓冲区因为同样存储区域可以容纳更多

    youdao

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

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

    youdao

  • Virtual segment also contains dictionary cache, stored procedures cache, and big buffer pools used for writing large block of pages to disk at once.

    虚拟内存段包含字典缓存器,存储过程缓存器,以及在向磁盘一次性写入大块页面时使用到的较大缓冲

    youdao

  • If this is the case, a larger buffer pool is the best solution, but adding more free space to index pages may also help.

    如果的确上述情况,那么使用大的缓冲最好解决办法但是索引增加更多自由空间也有所帮助。

    youdao

  • This calculation takes into account all of the pages (index and data) that are cached by the buffer pool.

    这个计算考虑缓冲高速缓存所有(索引数据)。

    youdao

  • You might also have a query that runs against a very large table that USES the same buffer pool and involves reading more pages than the total buffer size.

    假设一个针对非常运行查询,它使用同一个缓冲并且需要读取总的缓存大小还多

    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

  • Transactions requiring disk I/O, such as flushing dirty pages from the buffer pool or flushing logs from the log buffer, may wait.

    要求磁盘I/O事务例如刷新缓冲中的或者刷新日志缓冲区中的日志可能需要等待

    youdao

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

    通过12000个4K页面更大缓冲性能结果10完成43个事务增加完成66个事务,如图4中所示。

    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

  • Once fetched into DB2 buffer pools, records in these pages are scanned and the stage-1 predicate is applied.

    一旦提取DB2缓冲扫描这些页面上的记录并应用阶段 1 谓词。

    youdao

  • For other platforms, the buffer pool size is 250 pages with a 4k pagesize.

    而在其他平台上缓冲大小250个大小为4k

    youdao

  • Whenever an application posts a send or receive, and AFD.SYS's buffering is disabled, all pages in the buffer are locked into physical memory.

    如果AFD . SYS的缓冲关闭,当应用程序收发数据时,应用程序缓冲区所有页面锁定物理内存中。

    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

  • If the hit ratio is low, increasing the number of buffer pool pages may improve performance.

    如果命中率低,则可以增加缓冲页数来提高性能。

    youdao

  • With the buffer pool size of 250 pages, the application test run experienced very poor buffer pool hit ratio of 48.69%.

    通过250个页面缓冲大小应用程序测试运行呈现了48.69%的糟糕缓冲池命中率

    youdao

  • What happens if you increase the buffer pool size to 20,000 4K pages and run PERFORMER again?

    如果缓冲大小增加 20,000 个4K页面重新运行 PERFORMER,那将发生什么情况呢?

    youdao

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

    然后通过FETCH节点获取合格RID以提取来自表格空间相应记录数据页面db2缓冲

    youdao

  • Furthermore, compressed pages of a DB2 table space remain compressed in the DB2 buffer pool in main memory.

    而且DB 2空间压缩内存db2缓冲仍保持压缩。

    youdao

  • However, over-allocating free space may result in wasted DASD space, less data transferred per I/O, less efficient use of buffer pools and more pages to scan.

    然而,过多地分配空余空间可能会产生浪费DASD 空间,导致每次I/O 只能传输少的数据缓冲利用效率,并且扫描更多

    youdao

  • 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%)写入磁盘

    youdao

  • Number of pages prefetched into the buffer pool, but never read.

    预抓取缓冲从未读取页面数量

    youdao

  • By default, JSP pages have an 8kb buffer, which is flushed automatically when it's full of the dynamically generated HTML.

    默认状态下,jsp页面具有一个8kb缓冲区满载动态生成的HTML自动刷新

    youdao

  • Current size of the buffer pool (in pages).

    缓冲当前大小(页面数)。

    youdao

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

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

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