Each subset is known as a database partition group.
每个子集称作一个数据库分区组。
Create the table space in the database partition group.
创建数据库分区组内的表空间。
Redesigned redistribute database partition group utility
重新设计的重分发数据库分区组实用程序
Execute the following command to create the partition group.
执行下列命令来创建分区组。
A database partition can belong to more than one partition group.
一个数据库分区可以属于不止一个分区组。
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.
生成缓冲池、表空间和数据库分区组信息。
The group view displays partition groups, including your own customized groups.
组视图显示分区组,包括您的定制组。
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.
可以选择将这个额外分区添加到某一个数据库分区组。
The PDGP partition group spans the data nodes, which is where the table Spaces are placed.
PDGP分区组跨越数据节点,这是表空间所在的位置。
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.
在这种情况下,DatabasePartition 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进行重分发。
The partition group labeled IBMTEMPGROUP spans across the administration node and the two data nodes.
标有ibmtempgroup的分区组横跨管理节点及两个数据节点。
At this point, the definition of the table is tied to the definition of the database partition group.
至此,此表的定义与数据库分区组的定义相关联。
To create a new partition group consisting of all partitions in db2nodes.cfg, issue the following command.
为了创建一个新的由db 2 nodes . cfg中所有分区组成的分区组,可以发出以下命令。
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.
在与一个数据库分区组相关联的表空间中,每个表的分区键可以确定表是否是并置的。
If instead you wanted to create a new partition group, only consisting of partitions 1 and 2, you could issue a command similar to the following.
如果您想创建一个新的分区组,且这个分区组只包含分区1和2,可以发出如下命令。
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语句。
应用推荐