• Tuning IBM DB2 database buffer pools

    优化IBMDB2数据库缓冲池

    youdao

  • Compare application hit ratio of buffer pools.

    比较缓冲池的应用程序命中率。

    youdao

  • Show which table Spaces use which buffer pools.

    说明哪些表空间使用哪些缓冲池。

    youdao

  • To create buffer pools, use the following commands

    您可以使用以下命令来创建缓冲池

    youdao

  • Set the size of all database buffer pools to AUTOMATIC.

    将所有数据库缓冲池的大小设置为AUTOMATIC。

    youdao

  • The DB2 buffer pools consist of slots of contiguous memory.

    db2缓冲池由数个插槽(slot)的连续的内存组成。

    youdao

  • To resolve this problem, reduce the size of main buffer pools.

    要解决这个问题,可以减少主缓冲池的大小。

    youdao

  • All buffer pools are allocated when the database is activated.

    而所有的缓冲池是在数据库被激活时被分配的。

    youdao

  • For this reason, DB2 pre-allocates these four small buffer pools.

    由于这个原因,DB 2预先分配了4个这样的小型缓冲池。

    youdao

  • Essentially, AWE allows you to create buffer pools over the 2gb limit.

    实际上,AWE允许创建超过2GB限制的缓冲池。

    youdao

  • However it does not mean that you should always create large buffer pools.

    然而,这并不意味着您总是需要创建较大的缓冲池。

    youdao

  • The query returns only the buffer pools that have a lower hit ratio than 90%.

    该查询只返回命中率低于90%的缓冲池。

    youdao

  • In the above set of commands, buffer pools and table Spaces have been created.

    使用上面这组命令将创建缓冲池和表空间。

    youdao

  • This is the layout for database partition groups, buffer pools and tablespaces.

    这是用于数据库分区组、缓冲池和表空间的布局。

    youdao

  • When you design buffer pools, you should consider the database memory requirements.

    当您设计缓冲池时,您应该考虑数据库的内存需求。

    youdao

  • However, keep in mind that buffer pools are part of the database Shared memory set.

    但是请记住,缓冲池是数据库共享内存集中的一部分。

    youdao

  • The database Shared memory (including buffer pools) starts at 0x50000000 (default).

    数据库共享内存(包括缓冲池)始于0x50000000(默认值)。

    youdao

  • Split the data and indices into two different buffer pools and tune them separately.

    将数据和索引分离到两个不同的缓冲池,并分别调优。

    youdao

  • The general recommendations for allocating multiple buffer pools include the following.

    下面给出了关于分配多个缓冲池的一般建议。

    youdao

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

    在具有大缓冲池的环境下,也可能需要配置较多的页清除程序。

    youdao

  • It contains control block information for tables, indexes, table Spaces, and buffer pools.

    它包含表、索引、表空间和缓冲池的控制块信息。

    youdao

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

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

    youdao

  • Avoid overallocating memory to buffer pools if the memory allocated cannot help performance.

    如果已分配的内存不能帮助提高性能,那么请避免给缓冲池分配过多的内存。

    youdao

  • When this happens, you should connect to the database and reduce the size of the main buffer pools.

    这时,应该连接到数据库,并减少主缓冲池的大小。

    youdao

  • Should the main buffer pools fail to start, DB2 will start the database with the small buffer pools.

    这样,一旦主缓冲池无法启动,DB 2还可以使用这些小型的缓冲池来启动数据库。

    youdao

  • Compared to other memory buffers, buffer pools have the most significant impact on database performance.

    与其他内存缓冲区相比,缓冲池对数据库性能的影响最为显著。

    youdao

  • Large buffer pools also have an effect on query optimization, since more of the work can be done in memory.

    大型缓冲池还会对查询优化产生影响,因为更多的工作可在内存中完成。

    youdao

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

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

    youdao

  • DB2 USES buffer pools to cache the table and index data as they are being read or written to the hard disk drive.

    当从硬盘驱动器读写表和索引数据时,DB 2使用缓冲池来缓存它们。

    youdao

  • For example, the buffer pools and the database heaps are two separate memory pools within the database memory set.

    例如,缓冲池和数据库堆是数据库内存集内的两个不同的内存池。

    youdao

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

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

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