Tuning IBM DB2 database buffer pools
优化IBMDB2数据库缓冲池
Compare application hit ratio of buffer pools.
比较缓冲池的应用程序命中率。
Show which table Spaces use which buffer pools.
说明哪些表空间使用哪些缓冲池。
To create buffer pools, use the following commands
您可以使用以下命令来创建缓冲池
Set the size of all database buffer pools to AUTOMATIC.
将所有数据库缓冲池的大小设置为AUTOMATIC。
The DB2 buffer pools consist of slots of contiguous memory.
db2缓冲池由数个插槽(slot)的连续的内存组成。
To resolve this problem, reduce the size of main buffer pools.
要解决这个问题,可以减少主缓冲池的大小。
All buffer pools are allocated when the database is activated.
而所有的缓冲池是在数据库被激活时被分配的。
For this reason, DB2 pre-allocates these four small buffer pools.
由于这个原因,DB 2预先分配了4个这样的小型缓冲池。
Essentially, AWE allows you to create buffer pools over the 2gb limit.
实际上,AWE允许创建超过2GB限制的缓冲池。
The query returns only the buffer pools that have a lower hit ratio than 90%.
该查询只返回命中率低于90%的缓冲池。
In the above set of commands, buffer pools and table Spaces have been created.
使用上面这组命令将创建缓冲池和表空间。
This is the layout for database partition groups, buffer pools and tablespaces.
这是用于数据库分区组、缓冲池和表空间的布局。
When you design buffer pools, you should consider the database memory requirements.
当您设计缓冲池时,您应该考虑数据库的内存需求。
However, keep in mind that buffer pools are part of the database Shared memory set.
但是请记住,缓冲池是数据库共享内存集中的一部分。
The database Shared memory (including buffer pools) starts at 0x50000000 (default).
数据库共享内存(包括缓冲池)始于0x50000000(默认值)。
Split the data and indices into two different buffer pools and tune them separately.
将数据和索引分离到两个不同的缓冲池,并分别调优。
The general recommendations for allocating multiple buffer pools include the following.
下面给出了关于分配多个缓冲池的一般建议。
Environments with large buffer pools may also require more page cleaners to be configured.
在具有大缓冲池的环境下,也可能需要配置较多的页清除程序。
It contains control block information for tables, indexes, table Spaces, and buffer pools.
它包含表、索引、表空间和缓冲池的控制块信息。
Environments with large buffer pools might also require more page cleaners to be configured.
具有大型缓冲池的环境也可能需要配置更多页面清洗器。
Avoid overallocating memory to buffer pools if the memory allocated cannot help performance.
如果已分配的内存不能帮助提高性能,那么请避免给缓冲池分配过多的内存。
When this happens, you should connect to the database and reduce the size of the main buffer pools.
这时,应该连接到数据库,并减少主缓冲池的大小。
Should the main buffer pools fail to start, DB2 will start the database with the small buffer pools.
这样,一旦主缓冲池无法启动,DB 2还可以使用这些小型的缓冲池来启动数据库。
Compared to other memory buffers, buffer pools have the most significant impact on database performance.
与其他内存缓冲区相比,缓冲池对数据库性能的影响最为显著。
Large buffer pools also have an effect on query optimization, since more of the work can be done in memory.
大型缓冲池还会对查询优化产生影响,因为更多的工作可在内存中完成。
Once fetched into DB2 buffer pools, records in these pages are scanned and the stage-1 predicate is applied.
一旦提取到DB2 的缓冲池,将扫描在这些页面上的记录并应用阶段 1 谓词。
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使用缓冲池来缓存它们。
For example, the buffer pools and the database heaps are two separate memory pools within the database memory set.
例如,缓冲池和数据库堆是数据库内存集内的两个不同的内存池。
When you configure new buffer pools, make sure that you understand how it impacts the available memory of your system.
当您配置新的缓冲池时,一定要理解它对系统可用内存的影响。
应用推荐