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

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

    youdao

  • 具有大型缓冲环境可能需要配置更多页面清洗器

    Environments with large buffer pools might also require more page cleaners to be configured.

    youdao

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

    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.

    youdao

  • db2缓冲池中数据页面保持压缩的,为了潜在的重用允许更多的数据存在内存

    A data page also remains compressed in the DB2 buffer pool there by allowing more data to be cached in memory for potential reuse.

    youdao

  • 参数指定审计缓冲分配4K大小页面数量

    This parameter specifies the number of 4k pages to allocate to audit buffering.

    youdao

  • 数据索引页面击中反映缓冲需要磁盘I/O情况下直接处理一个页面请求时间

    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.

    youdao

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

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

    youdao

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

    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.

    youdao

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

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

    youdao

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

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

    youdao

  • 出于这些理由DB 2中创建新数据库会创建一个支持4KB页面的默认缓冲

    For these reasons, a default buffer pool is created that supports a 4 KB page when a new database is created in DB2.

    youdao

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

    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.

    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

  • 对于具有大于页面大小空间数据库而言,需要创建具有匹配页面大小的附加缓冲

    For a database that has table Spaces of more than one page size, additional buffer pools with matching page sizes need to be created.

    youdao

  • 统一页面大小创建数据库需要一个匹配页面大小的缓冲(即使不是4KB)。

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

    youdao

  • 检查点数据库服务器特定时间磁盘上页面共享内存缓冲中的页面进行同步

    A checkpoint refers to a point when the database server synchronizes the pages on disk with the pages in the shared-memory buffers.

    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

  • 分页为了使页面大小适合设备缓冲可接受限制而将单个页面分解多个页面过程

    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.

    youdao

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

    Create buffer pool BP 5000 page, size 16k.

    youdao

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

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

    youdao

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

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

    youdao

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

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

    youdao

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

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

    youdao

  • 缓冲id名称页面大小

    Buffer pool ID, name, and page size.

    youdao

  • db2pclnr缓冲页面清除程序。

    Db2pclnr: For buffer pool page cleaners.

    youdao

  • db2exfmt输出显示所有缓冲中的页面总数为总的大小

    The db2exfmt output would show the total size as the sum of the number of pages in all the bufferpools.

    youdao

  • 3显示一个包含250个4K页面缓冲所完成事务数目:(注意系统性能结果可能不同。)

    Figure 3 shows the number of transactions completed with one buffer pool of 250 4k pages: (Note: Performance results may differ on your system.)

    youdao

  • 缓冲必须具有相同页面大小(pagesize)。

    Buffer pool must have same pagesize.

    youdao

  • Memknobs分配个固定大小的缓冲循环遍历缓冲页面写到页上。

    Memknobs allocates a fixed-sized buffer and loops through that buffer's pages, writing to each one.

    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

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

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

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