每个子集称作一个数据库分区组。
创建数据库分区组内的表空间。
请记住,数据库分区组定义可以更改。
Keep in mind that the database partition group definition can change.
重新设计的重分发数据库分区组实用程序
生成缓冲池、表空间和数据库分区组信息。
Generate buffer pool, tablespace, and database partition group information.
被合并的表必须在相同的数据库分区组内定义。
The joined tables must be defined in the same database partition group.
当创建数据库分区组时,同时会创建分区映射。
The partitioning map is created when a database partition group is created.
这是用于数据库分区组、缓冲池和表空间的布局。
This is the layout for database partition groups, buffer pools and tablespaces.
至此,此表的定义与数据库分区组的定义相关联。
At this point, the definition of the table is tied to the definition of the database partition group.
例如,图5展示了一个由5个分区组成的数据库分区组。
For example, Figure 5 shows a database partition group made of five partitions.
创建一个数据库分区组来指定要参加分区的那些数据库分区。
Create a database partition group that specifies the database partitions that will participate in the partitioning.
可以选择将这个额外分区添加到某一个数据库分区组。
You can choose the database partition group where you want to add this extra partition.
多分区数据库分区组只能用属于相同实例的数据库分区来定义。
Multi-partition database partition groups can only be defined with database partitions that belong to the same instance.
数据库分区组是由一个或多个数据库分区组成的一个组。
A database partition group is a set of one or more database partitions.
当创建或修改一个数据库分区组时,就会有一个与之关联的分区映射。
When a database partition group is created or modified, a partitioning map is associated with it.
还可以使用系统编目视图来检索关于数据库分区和数据库分区组的信息。
You can also use the system catalog views to retrieve information about database partitions and database partition groups.
每个包含不止一个数据库分区的子集称作多分区数据库分区组。
Each subset that contains more than one database partition is known as a multi-partition database partition group.
注意:记住也要重分发ibmdefaultgroup数据库分区组。
Note: Remember to redistribute the IBMDEFAULTGROUP database partition group too.
IBMTEMPGROUP -用于系统临时表空间的默认数据库分区组。
IBMTEMPGROUP is - default database partition group for system temporary tablespaces.
IBMCATGROUP-用于包含系统编目的表空间的默认数据库分区组。
IBMCATGROUP - default database partition group for the tablespace containing the system catalogs.
在与一个数据库分区组相关联的表空间中,每个表的分区键可以确定表是否是并置的。
The partitioning key for each table in a tablespace that is associated with a database partition group determines if the tables are collocated.
除非想要利用与更大的表的并置,否则应该将小型的表放在单分区的数据库分区组中。
Small tables should be placed in single-partition database partition groups, except when you want to take advantage of collocation with a larger table.
IBMDEFAULTGROUP-用于包含用户表的表空间的默认数据库分区组。
IBMDEFAULTGROUP - default database partition group for the tablespaces containing the user tables.
用户可以通过使用数据库分区组和表空间,来确定将表数据分布到哪些数据库分区上。
Using database partition groups and tablespaces, a user can determine across which and how many database partitions their table data is to be spread.
有一个隐式的假设:每个表中的行是均匀分布在每个多分区数据库分区组中的所有分区上的。
There is an implicit assumption that the rows of each table are evenly distributed across all the partitions in each multiple-partition database partition group.
这里正在用一个新添加的分区对数据库分区组rdst_v10_015进行重分发。
The database partition group RDST_V10_015 is being redistributed with a new partition being added.
第一个特性是为已有数据库分区组添加或删除数据库分区,以及在相同命令上执行重分发的能力。
The first feature is the ability to add or drop database partitions to or from an existing database partition group and perform the redistribute on the same command.
更改此关系的惟一方式是丢弃此表并在与不同的数据库分区组相关联的一个不同的表空间内重新创建它。
The only way to change this relationship is to drop the table and recreate it in a different table space that is tied to a different database partition group.
distinct值的数量必须多到足以确保数据行均匀地分布在数据库分区组中的所有数据库分区上。
The number of distinct values must be great enough to ensure an even distribution of rows across all database partitions in the database partition group.
每个分区必须使用一个惟一的分区号,而同一个数据库分区可以属于一个或多个数据库分区组中。
Each partition must use a unique partition number and the same database partition may be found in one or more database partition groups.
应用推荐