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.
另一个极大影响性能的配置参数是数据库缓冲池大小。
Each database requires at least one buffer pool.
每个数据库都至少需要一个缓冲池。
Database records are read and updated in the buffer pool area of memory.
数据库记录是在内存的缓冲池区域里被读取和更新的。
When you create a table space, you can associate it with a specific buffer pool (database cache) as well as to specific containers.
当创建表空间时，可以将它与特定的缓冲区池(数据库缓存)关联起来，并关联到特定的容器。
If the database is not started, you cannot connect to the database and change the buffer pool sizes.
如果数据库没有启动，那么就不能连接到数据库，也就不能更改缓冲池的大小。
Each DB2 database must have at least one single buffer pool.
每一个DB 2数据库都必须至少拥有一个缓冲池。
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.
这使得您可以选择需要的任何页面大小，并且在整个数据库仍然维护一个缓冲池和统一的页面大小。
That means DB2 cannot start the database, because a database must have at least one buffer pool.
这意味着DB 2无法启动数据库，因为一个数据库至少必须有一个缓冲池。
The purpose of the buffer pool is to improve database system performance.
缓冲池的用途是为了提高数据库系统的性能。
Memory impacts the number of client connections and the size of the buffer pool and database cache allocated by the server.
内存影响客户端连接的数量、缓冲池的大小，以及服务器分配的数据库缓存的大小。
When you create a database with a uniform page size, only one buffer pool to match this page size is required (even if it isn't a 4 KB).
在用统一的页面大小创建数据库时，只需要一个匹配该页面大小的缓冲池(即使它不是4KB)。
Buffer pool contention can be a significant factor in database performance.
缓冲池竞争可以成为数据库性能中的重要因素。
Where -l generates the DDL statements for tablespace, database partition, groups, and buffer pool.
在这里，- l创建了表空间、数据库分区、组和缓存池的ddl语句。
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.
一个数据库必须至少有一个缓冲池，并且可以有多个缓冲池，这要视工作负载的特征、数据库中使用的数据库页面大小等因素而定。
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.
一个数据库必须至少有一个缓冲池，并且可以有多个缓冲池，具体要视工作负载的特征、数据库中使用的数据库页面大小等因素而定。
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参数来控制缓冲池大小之后，将该参数设置成合适的值。
These page cleaners write changed pages from the buffer pool to disk before the space in the buffer pool is required by a database agent.
在数据库代理程序需要缓冲池中的空间之前，这些页清除程序将缓冲池中已更改的页写到磁盘。
In addition, each database has its own database configuration file, catalog tables, logs, reserved buffer pool area, and table Spaces.
此外，每一个数据库可拥有自己的数据库配置文件、目录表、日志、保留的缓冲池区域和表空间。
For example, if you create a new database with an 8 KB page size, the default buffer pool for all the table Spaces will be 8 KB.
例如，如果用8KB页面大小创建一个新的数据库，那么所有表空间默认的缓冲池将是8 KB。
For these reasons, a default buffer pool is created that supports a 4 KB page when a new database is created in DB2.
出于这些理由，在DB 2中创建新数据库时，会创建一个支持4KB页面的默认缓冲池。
Page cleaners, on the other hand, write changed pages from the buffer pool to disk before the space in the buffer pool is required by a database agent.
另一方面，数据库代理需要缓冲池中的空间之前，页面清洗器将已修改的页面从缓冲池写入磁盘。
If each buffer pool has an NPAGES value of -1, then the buffer pool size is being controlled through the BUFFPAGE parameter in the database configuration.
如果每个缓冲池都有一个为“-1”的npages值，那么缓冲池大小是由数据库配置中的BUFFPAGE参数控制的。
Since a DB2 buffer pool is a part of the main memory of the system, the DB2 database manager allocates it for caching tables and index data when it reads or writes to and from media disks.
因为db2缓冲池是系统主内存的一部分，DB 2数据库管理器在它读取或写入磁盘介质时将它分配给缓存表和索引数据。
For for a large OLTP database, set aside as much as memory as possible for the buffer pool while keeping the system stable.
对于大型OLTP数据库，在保持系统稳定的同时为缓冲池留出尽可能多的内存。
To determine the buffer pool size in the database, take a look at Listing 3.
为了确定数据库中的缓冲池大小，请查看清单3。
Create DB2 database, buffer pool, and tablespace with more than 4k.
创建DB 2数据库、缓冲池和表空间，使用大于4k的页面大小。
Although the buffer pool did not exceed 1 GB in the large-database tests, the smaller database and greater concurrency tests used every Megabyte possible.
尽管在大型数据库测试中缓冲池从不超过1GB，但在并发性程度很高的小型数据库中，缓冲池的容量得到了充分的利用。
应用推荐