Tuning IBM DB2 database buffer pools
优化IBMDB2数据库缓冲池
Set the size of all database buffer pools to AUTOMATIC.
将所有数据库缓冲池的大小设置为AUTOMATIC。
The database buffer pool(s) area is normally the largest component of the database shared memory.
数据库缓冲池通常是数据库共享内存中最大的一块内存。
Another configuration parameter that dramatically affects performance is the database buffer pool size.
另一个极大影响性能的配置参数是数据库缓冲池大小。
Database records are read and updated in the buffer pool area of memory.
数据库记录是在内存的缓冲池区域里被读取和更新的。
Each database requires at least one buffer pool.
每个数据库都至少需要一个缓冲池。
When you create a table space, you can associate it with a specific buffer pool (database cache) as well as to specific containers.
当创建表空间时，可以将它与特定的缓冲区池(数据库缓存)关联起来，并关联到特定的容器。
When you design buffer pools, you should consider the database memory requirements.
当您设计缓冲池时，您应该考虑数据库的内存需求。
Buffer pool contention can be a significant factor in database performance.
缓冲池竞争可以成为数据库性能中的重要因素。
If the database is not started, you cannot connect to the database and change the buffer pool sizes.
如果数据库没有启动，那么就不能连接到数据库，也就不能更改缓冲池的大小。
This is the layout for database partition groups, buffer pools and tablespaces.
这是用于数据库分区组、缓冲池和表空间的布局。
That means DB2 cannot start the database, because a database must have at least one buffer pool.
这意味着DB 2无法启动数据库，因为一个数据库至少必须有一个缓冲池。
Memory impacts the number of client connections and the size of the buffer pool and database cache allocated by the server.
内存影响客户端连接的数量、缓冲池的大小，以及服务器分配的数据库缓存的大小。
The log buffer size is defined by the LOGBUFSZ database parameter.
日志缓冲区大小是由LOGBUFSZ数据库参数定义的。
Specifically, an administrator must define appropriate database objects, such as partition groups, table Spaces, buffer pools, and so on.
具体地说，管理员必须定义适当的数据库对象，比如分区组、表空间、缓冲区池等等。
To isolate objects in different buffer pools, you can create more than one table space in the same database, and associate each table space with separate buffer pools.
为了在不同缓冲池中隔离对象，您可以在同一个数据库中创建一个以上的表空间，并给每一个表空间关联不同的缓冲池。
Compared to other memory buffers, buffer pools have the most significant impact on database performance.
与其他内存缓冲区相比，缓冲池对数据库性能的影响最为显著。
Where -l generates the DDL statements for tablespace, database partition, groups, and buffer pool.
在这里，- l创建了表空间、数据库分区、组和缓存池的ddl语句。
If this buffer size is exceeded, the database server discards saved data.
如果超过这个缓冲区大小，数据库服务器会丢弃保存的数据。
A buffer pool is associated with a single database, and can be used by more than one table space.
一个缓冲池是与单个数据库相关联的，可以被多个表空间使用。
Obviously, with availability of physical memory on the database server, a high buffer pool hit ratio is always better for your database performance.
显然，随着数据库服务器上物理内存的使用，高缓冲池命中率对于您的数据库性能而言始终比较好。
A database must have at least one buffer pool, and can have a number of buffer pools depending on the workload characteristics, database page sizes used in the database, etc.
一个数据库必须至少有一个缓冲池，并且可以有多个缓冲池，这要视工作负载的特征、数据库中使用的数据库页面大小等因素而定。
However, keep in mind that buffer pools are part of the database Shared memory set.
但是请记住，缓冲池是数据库共享内存集中的一部分。
The size of the buffer is determined by the AUDIT_BUF_SZ database manager configuration parameter.
缓冲区的大小是由AUDIT _ BUF_SZ这个数据库管理器配置参数决定的。
After making sure that you can use the BUFFPAGE parameter in the database configuration to control the buffer pool size, set it to a proper value.
确保可以使用数据库配置中的BUFFPAGE参数来控制缓冲池大小之后，将该参数设置成合适的值。
All buffer pools are allocated when the database is activated.
而所有的缓冲池是在数据库被激活时被分配的。
A database must have at least one buffer pool, and can have a number of buffer pools depending on such things as the workload characteristics and database page sizes used in the database.
一个数据库必须至少有一个缓冲池，并且可以有多个缓冲池，具体要视工作负载的特征、数据库中使用的数据库页面大小等因素而定。
Should the main buffer pools fail to start, DB2 will start the database with the small buffer pools.
这样，一旦主缓冲池无法启动，DB 2还可以使用这些小型的缓冲池来启动数据库。
In addition, each database has its own database configuration file, catalog tables, logs, reserved buffer pool area, and table Spaces.
此外，每一个数据库可拥有自己的数据库配置文件、目录表、日志、保留的缓冲池区域和表空间。
For example, the buffer pools and the database heaps are two separate memory pools within the database memory set.
例如，缓冲池和数据库堆是数据库内存集内的两个不同的内存池。
应用推荐