If there are table Spaces with different page sizes, there must be at least one buffer pool per page size.
如果有一些具有不同页大小的表空间，那么每种页大小必须至少有一个缓冲池。
When you create a table space, you can associate it with a specific buffer pool (database cache) as well as to specific containers.
当创建表空间时，可以将它与特定的缓冲区池(数据库缓存)关联起来，并关联到特定的容器。
This means that DB2 fetches every data page in the table space sequentially into the buffer pool.
这意味着DB2按顺序在表空间上提取每一个数据页面到缓冲池。
The profiling table provides the percentage and number of samples collected for specified processor events such as the number of cache line misses, Transition Lookaside Buffer (TLB) misses, and so on.
评测表提供为特定的处理器事件收集的采样的百分数或数量，比如高速缓存线路故障的数量、传输后备缓存(TLB)故障的数量，等等。
Rather, the page size for tables is determined by the page size of the buffer pool to which the table space containing the table is assigned.
相反，表的页宽是由相应的缓冲池的页宽来确定的，这个缓冲池也就是为包含该表的表空间所指定的缓冲池。
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.
为了在不同缓冲池中隔离对象，您可以在同一个数据库中创建一个以上的表空间，并给每一个表空间关联不同的缓冲池。
Consider buffer pool utilization, which might lead you to make some changes to the previous table space design.
考虑缓冲池的利用率。这可能会使前面的表空间设计产生一些变化。
The following query Listing 1 shows which table Spaces use which buffer pools.
下面的查询清单1说明了哪些表空间使用哪些缓冲池。
If the small tables have their own buffer pool, thereby making it necessary for them to have their own table space, their pages cannot be overwritten by the large query.
如果小型表拥有自己的缓冲池，那么它们就必须拥有自己的表空间，因此大型查询就不能覆盖它们的页。
If you are working with large data sets, consider using a dedicated buffer pool for the table space.
如果是使用大型数据集，可考虑用专用的缓冲池来代替表空间。
To find out which buffer pool is assigned to table Spaces, run the query shown in Listing 8.
要找出哪个缓冲池被分配给了表空间，请运行清单8中所示的查询。
For a database that has table Spaces of more than one page size, additional buffer pools with matching page sizes need to be created.
对于具有大于一个页面大小的表空间的数据库而言，需要创建具有匹配页面大小的附加缓冲池。
In addition, each database has its own database configuration file, catalog tables, logs, reserved buffer pool area, and table Spaces.
此外，每一个数据库可拥有自己的数据库配置文件、目录表、日志、保留的缓冲池区域和表空间。
You might also have a query that runs against a very large table that USES the same buffer pool and involves reading more pages than the total buffer size.
假设有一个针对非常大的表运行的查询，它使用同一个缓冲池并且需要读取比总的缓存区大小还多的页。
A buffer pool is associated with a single database, and can be used by more than one table space.
一个缓冲池是与单个数据库相关联的，可以被多个表空间使用。
The most important reason to use more than one user table space is to manage buffer utilization.
使用多个用户表空间的最重要原因是管理缓冲区的利用率。
But when assigning specific table Spaces and indexes to those buffer pools, that could be viewed somewhat as a database design consideration.
但是，倘若是将特定的表空间和索引指派给那些缓冲池，那么这些因素又可以看作是数据库设计一类的因素了。
It contains control block information for tables, indexes, table Spaces, and buffer pools.
它包含表、索引、表空间和缓冲池的控制块信息。
Fewer buffer pools and table Spaces and fewer distinct page sizes lead to a simpler physical database design which is easier to manage, maintain, and tune.
更少的缓冲池和表空间，以及更少的页宽种类，可以导致更简单的物理数据库设计，从而更容易管理、维护和调优。
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。
Note that the page sizes of 8K for the buffer pool and table space are the same.
请注意，缓冲池和表空间的页大小都是8K，两者是相同的。
The qualifying RIDs are then taken by the fetch node to fetch the corresponding records and data pages from the table space into the DB2 buffer pool.
然后通过FETCH节点获取合格的RID以提取来自表格空间的相应记录和数据页面到db2缓冲池。
Furthermore, compressed pages of a DB2 table space remain compressed in the DB2 buffer pool in main memory.
而且DB 2表空间的压缩页在主内存的db2缓冲池中仍保持压缩。
For example, a table space with an 8kb page size can only use a buffer pool with page size of 8kb.
例如，页面大小为8kb的表空间只能使用页面大小为8kb的缓冲池。
In the above set of commands, buffer pools and table Spaces have been created.
使用上面这组命令将创建缓冲池和表空间。
A potential course of action here is to reduce the size of the buffer pools supporting the table Spaces resident on SSDs.
这里，可能的动作是减小支持驻留在SSD上的表空间的缓冲池大小。
A table space can be associated with only one buffer pool, but one buffer pool can be used for more than one table space.
一个表空间只能与一个缓冲池相关联，而一个缓冲池可用于多个表空间。
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使用缓冲池来缓存它们。
If you use multiple buffer pools, you might take the buffer pool hit ratio together with the buffer pool name from the PWH.BUFFERPOOL table.
若使用多个缓冲池，可能要从PWH . BUFFERpool表取得缓冲池命中率和缓冲池名称。
应用推荐