PDGP分区组跨越数据节点,这是表空间所在的位置。
The PDGP partition group spans the data nodes, which is where the table Spaces are placed.
例如,图5展示了一个由5个分区组成的数据库分区组。
For example, Figure 5 shows a database partition group made of five partitions.
还可以使用系统编目视图来检索关于数据库分区和数据库分区组的信息。
You can also use the system catalog views to retrieve information about database partitions and database partition groups.
数据库分区组是由一个或多个数据库分区组成的一个组。
A database partition group is a set of one or more database partitions.
在与一个数据库分区组相关联的表空间中,每个表的分区键可以确定表是否是并置的。
The partitioning key for each table in a tablespace that is associated with a database partition group determines if the tables are collocated.
如果不需要特别考虑并置,那么能使数据均匀地散布在数据库分区组中所有数据库分区上的分区键就是好的分区键。
If collocation is not a major consideration, a good partitioning key for a table is one that spreads the data evenly across all database partitions in the database partition group.
更改此关系的惟一方式是丢弃此表并在与不同的数据库分区组相关联的一个不同的表空间内重新创建它。
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.
取决于数据库分区的数量,您可以有一个或多个单分区的数据库分区组,以及一个或多个多分区的数据库分区组。
Depending on the number of database partitions, you may have one or more single-partition database partition groups, and one or more multi-partition database partition groups.
每个分区必须使用一个惟一的分区号,而同一个数据库分区可以属于一个或多个数据库分区组中。
Each partition must use a unique partition number and the same database partition may be found in one or more database partition groups.
这是用于数据库分区组、缓冲池和表空间的布局。
This is the layout for database partition groups, buffer pools and tablespaces.
有一个隐式的假设:每个表中的行是均匀分布在每个多分区数据库分区组中的所有分区上的。
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.
数据被划分到一个数据库分区组中的所有分区上,可以为数据库分区组添加一个或多个数据库分区,或者从中去掉数据库分区。
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.
可以选择将这个额外分区添加到某一个数据库分区组。
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.
具体地说,管理员必须定义适当的数据库对象,比如分区组、表空间、缓冲区池等等。
Specifically, an administrator must define appropriate database objects, such as partition groups, table Spaces, buffer pools, and so on.
创建一个数据库分区组来指定要参加分区的那些数据库分区。
Create a database partition group that specifies the database partitions that will participate in the partitioning.
被合并的表必须在相同的数据库分区组内定义。
The joined tables must be defined in the same database partition group.
除非想要利用与更大的表的并置,否则应该将小型的表放在单分区的数据库分区组中。
Small tables should be placed in single-partition database partition groups, except when you want to take advantage of collocation with a larger table.
在这里,- l创建了表空间、数据库分区、组和缓存池的ddl语句。
Where -l generates the DDL statements for tablespace, database partition, groups, and buffer pool.
注意:如果这是具有多个物理分区(MPP)的系统,那么测试中数据库分区组中的分区数目就必须相同。
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.
用户可以通过使用数据库分区组和表空间,来确定将表数据分布到哪些数据库分区上。
Using database partition groups and tablespaces, a user can determine across which and how many database partitions their table data is to be spread.
每个子集称作一个数据库分区组。
创建数据库分区组内的表空间。
多分区数据库分区组只能用属于相同实例的数据库分区来定义。
Multi-partition database partition groups can only be defined with database partitions that belong to the same instance.
第一个特性是为已有数据库分区组添加或删除数据库分区,以及在相同命令上执行重分发的能力。
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.
如果表分区不在该数据库分区上,那么将请求发送给数据库分区组中持有该表分区的第一个数据库分区。
If a table partition does not exist on the database partition, the request is sent to the first database partition in the database partition group that holds a partition for that table.
IBMDEFAULTGROUP-用于包含用户表的表空间的默认数据库分区组。
IBMDEFAULTGROUP - default database partition group for the tablespaces containing the user tables.
当创建数据库分区组时,同时会创建分区映射。
The partitioning map is created when a database partition group is created.
为此,可以将用户表放在不包括IBMCATGROUP数据库分区组中的数据库分区的数据库分区组中。
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-用于包含系统编目的表空间的默认数据库分区组。
IBMCATGROUP - default database partition group for the tablespace containing the system catalogs.
应用推荐