• 能够通过命名创建每一个页面相对应的数据

    You can create Datapools that correspond to each page by naming them accordingly.

    youdao

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

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

    youdao

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

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

    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

  • 需要进行频繁备份情况可以这么或者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

  • 数据索引页面击中反映缓冲需要磁盘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

  • 通过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

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

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

    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

  • 例如如果具有一个2GB缓冲达到60%修改页面时,触发页面清洗器时就有1.2 GB (2 GB的60%)写入磁盘

    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.

    youdao

  • 操作系统控制大小,并负责根据工作负载压缩压缩之间移动页面

    The operating system controls the pool sizes and is responsible for moving pages between the compressed and uncompressed pools based on workload.

    youdao

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

    Create buffer pool BP 5000 page, size 16k.

    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

  • WritesCache页面写到缓冲区(不是磁盘)次数百分比。

    Writes Cache: Parentage of time that a page was written to the buffer pool but not to disk.

    youdao

  • BufferWrite修改并发送回缓冲区页面数量

    Buffer Write: Number of pages modified and sent back to the buffer pool.

    youdao

  • BufferReads缓冲区(不是磁盘)读取页面数量

    Buffer Reads: Number of times a page has been read from the buffer pool and not read from disk.

    youdao

  • ReadCache应该缓冲区读取页面百分比

    Read Cache: Percentage of times the page should be read from the buffer pool.

    youdao

  • 可以使用vmo命令lgpg_regionslgpg_size选项配置页面物理内存大小

    The vmo command can be used to configure the size of the large page physical memory pool using the lgpg_regions and lgpg_size options.

    youdao

  • 这时特别小心,因为如果配置不当,则可能导致4KB64 KB页面大小过度分页

    Do this with extreme caution, because over configuring the system with 16-megabyte or 16-gigabyte pages can lead to excessive paging of 4-kilobyte or 64-kilobyte page size pools.

    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

  • 所显示数目就是分配给数据库的缓冲页面数目。

    The number shown is the total number of buffer pool pages that are allocated for the database. For example, let's say we have the following buffer pools

    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

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

    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
- 来自原声例句
小调查
请问您想要如何调整此模块?

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

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