下面的例子定义了两个缓冲池和两个表空间,一个表空间的页宽为 4KB,另一个表空间的页宽为 32KB(注意,一个表空间总是要有一个缓冲池,且缓冲池要有一个匹配的页宽) 。
The following example defines two buffer pools and two table spaces, one each with 4KB and 32KB pages. (Note that a table space always requires a buffer pool with a matching page size.)
db2表中一个行中存储的所有值的总大小不能超过表空间的页宽。
The total size of all values stored in a row of a DB2 table is limited by the page size that is used for the table space.
更少的缓冲池和表空间,以及更少的页宽种类,可以导致更简单的物理数据库设计,从而更容易管理、维护和调优。
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.
应用推荐