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
您可以使用以下命令来创建缓冲池
Now see what containers and buffer pools are in DB2.
现在来看一下DB 2中的容器和缓冲池是什么。
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.
要解决这个问题，可以减少主缓冲池的大小。
Buffer pools can be increased over the 2gb limit by using AWE.
通过使用AWE可以将缓冲池增加到超过2gb的限制。
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限制的缓冲池。
More buffer pools can be added by using the CREATE BUFFERPOOL statement.
可以使用CREATEBUFFER pool语句添加更多的缓冲池。
The query returns only the buffer pools that have a lower hit ratio than 90%.
该查询只返回命中率低于90%的缓冲池。
The following query Listing 1 shows which table Spaces use which buffer pools.
下面的查询清单1说明了哪些表空间使用哪些缓冲池。
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.
这是用于数据库分区组、缓冲池和表空间的布局。
Listing 2. XML and relational data in separate table Spaces and buffer pools.
必要时，如何将XML数据放入一个单独的表空间中？
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.
将数据和索引分离到两个不同的缓冲池，并分别调优。
In db2diag.log, you will see message saying db2 will start with hidden buffer pools.
在db2diag . log中，您将看到有消息说db 2将利用隐藏缓冲池启动。
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.
如果已分配的内存不能帮助提高性能，那么请避免给缓冲池分配过多的内存。
If you do not have the same buffer pools created, then you can also change the buffer pool name.
如果没有创建相同的缓冲池，那么您还可能修改缓冲池名称。
Four small buffer pools of page size 4k, 8k, 16k and 32k are allocated when a database is started.
当数据库启动时，要分配4个页宽分别为4k、8 K、16k和32 K的小型缓冲池。
应用推荐