Each subset is known as a database partition group.
每个子集称作一个数据库分区组。
Create the table space in the database partition group.
创建数据库分区组内的表空间。
Redesigned redistribute database partition group utility
重新设计的重分发数据库分区组实用程序
Keep in mind that the database partition group definition can change.
请记住,数据库分区组定义可以更改。
A database partition group is a set of one or more database partitions.
数据库分区组是由一个或多个数据库分区组成的一个组。
The joined tables must be defined in the same database partition group.
被合并的表必须在相同的数据库分区组内定义。
The partitioning map is created when a database partition group is created.
当创建数据库分区组时,同时会创建分区映射。
Generate buffer pool, tablespace, and database partition group information.
生成缓冲池、表空间和数据库分区组信息。
For example, Figure 5 shows a database partition group made of five partitions.
例如,图5展示了一个由5个分区组成的数据库分区组。
Note: Remember to redistribute the IBMDEFAULTGROUP database partition group too.
注意:记住也要重分发ibmdefaultgroup数据库分区组。
IBMTEMPGROUP is - default database partition group for system temporary tablespaces.
IBMTEMPGROUP -用于系统临时表空间的默认数据库分区组。
You can choose the database partition group where you want to add this extra partition.
可以选择将这个额外分区添加到某一个数据库分区组。
When a database partition group is created or modified, a partitioning map is associated with it.
当创建或修改一个数据库分区组时,就会有一个与之关联的分区映射。
In this case, the 'database partition group 1' spans all but one of the database partitions.
在这种情况下,Database Partition Group1横跨除一个数据库分区外的所有数据库分区。
IBMCATGROUP - default database partition group for the tablespace containing the system catalogs.
IBMCATGROUP-用于包含系统编目的表空间的默认数据库分区组。
IBMDEFAULTGROUP - default database partition group for the tablespaces containing the user tables.
IBMDEFAULTGROUP-用于包含用户表的表空间的默认数据库分区组。
The database partition group RDST_V10_015 is being redistributed with a new partition being added.
这里正在用一个新添加的分区对数据库分区组rdst_v10_015进行重分发。
At this point, the definition of the table is tied to the definition of the database partition group.
至此,此表的定义与数据库分区组的定义相关联。
Create a database partition group that specifies the database partitions that will participate in the partitioning.
创建一个数据库分区组来指定要参加分区的那些数据库分区。
Each subset that contains more than one database partition is known as a multi-partition database partition group.
每个包含不止一个数据库分区的子集称作多分区数据库分区组。
The partitioning key for each table in a tablespace that is associated with a database partition group determines if the tables are collocated.
在与一个数据库分区组相关联的表空间中,每个表的分区键可以确定表是否是并置的。
Note: If this is a system with multiple physical partitions (MPP), the number of partitions in the database partition group must be the same on test.
注意:如果这是具有多个物理分区(MPP)的系统,那么测试中数据库分区组中的分区数目就必须相同。
In theory, you can perform select, insert, update, or delete statements against a table that is not yet redistributed in the database partition group.
理论上讲,可以在数据库分区组中尚未重分发的表上执行select、insert、update或delete语句。
This used to be a two step process where you were required to issue an ALTER DATABASE partition GROUP statement to add or drop the partitions first.
这在过去是由两个步骤组成的一个过程,首先需要发出ALTERDATABASE PARTITION group语句来添加或删除分区。
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.
distinct值的数量必须多到足以确保数据行均匀地分布在数据库分区组中的所有数据库分区上。
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.
更改此关系的惟一方式是丢弃此表并在与不同的数据库分区组相关联的一个不同的表空间内重新创建它。
Data is divided across all the partitions in a database partition group and you can add or drop one or more database partitions from a database partition group.
数据被划分到一个数据库分区组中的所有分区上,可以为数据库分区组添加一个或多个数据库分区,或者从中去掉数据库分区。
This is accomplished by placing user tables in database partition groups that do not include the database partition in the IBMCATGROUP database partition group.
为此,可以将用户表放在不包括IBMCATGROUP数据库分区组中的数据库分区的数据库分区组中。
If a database partition group had been created in the database using database partitions 1 and 2, the partitioning map for that database partition group would be.
如果在使用数据库分区1和2的数据库中创建了一个数据库分区组,那么这个数据库分区组的分区映射为。
You are advised to issue the ALTER DATABASE partition GROUP statement to customize the tablespace setting and to control the container layout in the new partition.
建议发出ALTERDATABASE PARTITION group语句来定制表空间设置,并控制新分区中的容器布局。
应用推荐