When choosing partitioning keys, draw a data model that shows the relationships among the tables that are in your database.
在选择分区键时，可以画出一个数据模型，用来显示数据库内的这些表之间的关系。
This routine creates a copy of your existing table with the new partitioning key and loads it partially or fully with the data from the original table.
这个例程用新的分区键创建了现有表的一个副本并用来自原始表的数据对它进行部分或全部加载。
The idea behind partitioning is to spread a table's data across multiple partitions, storing some of its rows in one partition and other rows in other partitions.
分区背后的思想就是将一个表的数据分布在多个分区中，将该表中的一部分行存储在一个分区中，而将其他行存储在其他分区中。
The data model and the business relationship between tables can provide a more stable way of selecting a partitioning key than specific SQL statements.
这个数据模型以及表间的业务关系可以提供一种比sql语句更为稳定的选择分区键的方式。
For a data partitioning configuration, you must have a file system that is available to all participating machines that participate in your partitioned database system.
对于一个数据分区配置，必须有一个可供所有参与分区数据库系统的机器使用的文件系统。
The WFS must be a data partitioning feature (DPF) enabled system.
WFS必须是一个支持数据分区功能（DPF）的系统。
Partitioning maps are a flexible way of controlling where data is stored in a partitioned database.
分区映射是在分区数据库中控制数据存储位置的一种灵活的方式。
A partitioning key is a column (or group of columns) that is used to determine the partition in which a particular row of data is stored.
分区键是用于确定特定一行数据存储在哪个分区的一个列(或一组列)。
If a good partitioning key is chosen, the data will be evenly distributed across the nodes, and for most, if not all, queries, the partitioning key will uniquely identify the node containing the data.
如果选定一个好的分区键，那么数据会均匀地分布在所有节点，对于大多数情况都是如此，如果不是这样，请进行查询，分区键将惟一地标识包含数据的节点。
A data partition, also referred to as a range (currently DB2 supports only a range partitioning scheme), contains a subset of rows that are stored separately from other sets of rows in the table.
数据分区也称为范围(当前DB 2只支持范围分区方案)，一个数据分区包含一个行子集，这些行存储在与表中其他行集不同的地方。
This example tests the data skew in a scenario in which the partitioning key was changed to S_NATIONKEY.
这个示例测试的是分区键被更改为S_NATIONKEY的场景中的数据倾斜。
In order to get efficient access to data sizes >~1 GB, partitioning should be done along a reasonable key.
为了有效访问大小为 >~1GB 的数据，分区应沿着合理的键进行。
The partitioning key needs to be on a column or set of columns that are highly unique thus ensuring that the data will be evenly distributed across all the partitions that the table is defined on.
分区键需要位于高度惟一的一列或一组列上，从而确保数据均匀分布在该表所定义的所有分区上。
This example tests the data skew in a scenario in which the partitioning key was changed from S_NATIONKEY to S_ID.
这个示例测试的是分区键从 S_NATIONKEY 更改为 S_ID 的场景中的数据倾斜。
DurationLabel: Identifies the duration that is associated with the Constant value specified if the partitioning key column has been assigned a date, time, or time stamp data type.
DurationLabel：如果分区键列的数据类型是日期、时间或时间戳，这个参数指定与Constan t值相关的时间单位。
RANGE/TABLE PARTITIONING (Available with DB2 9) - splitting data by key range over multiple physical objects within a logical database partition.
RANGE/TABLEPARTITIONING（DB29提供） ——根据键范围将数据划分到一个逻辑数据库分区中的多个物理对象上。
You can store data in different partitions in the same table of a database using table partitioning.
您可以使用表分区将数据存储在同一个数据库表的不同分区中。
Database partitioning occurs when a database consists of two or more database partitions, where each database partition stores a subset of table data for each table that resides within it.
当一个数据库由两个或更多数据库分区组成，并且每个数据库分区存储位于其中的每个表的一部分表数据时，就属于数据库分区的情况。
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.
如果不需要特别考虑并置，那么能使数据均匀地散布在数据库分区组中所有数据库分区上的分区键就是好的分区键。
In a federated system with the data partitioning feature, only user-maintained MQTs are supported for nicknames.
在具有数据分区功能的联邦系统中，对于昵称只支持用户维护的MQT。
Database partitioning is an inherently relational process of dividing a table's rows by some logical piece of data into smaller groups.
数据库切分是一个固有的关系流程，可以通过一些逻辑数据块将一个表的行分为不同的小组。
TP supports partitioning a table into data partitions along a single dimension.
TP支持按照一个维将一个表分区成多个数据分区。
Just as a city map is organized into sections using a grid, the database manager USES a partitioning key to determine the location (the database partition) where the data is stored.
就像城市地图按网格分成一些区一样，数据库管理器使用分区键来确定数据所存储在的位置(数据库分区)。
The partitioning key should not include a column with unevenly distributed data or with a small number of distinct values.
分区键不应该包括没有将数据均匀分布或具有少数不同值的列。
The MBR partitioning system is a hodge-podge of data structure patches applied to overcome earlier limits.
mbr分区系统是一个数据结构补丁的大杂烩，用于克服早期的限制。
Typically, the partitioning key is time-based, resulting in a design that directs data for a given week, month, or quarter to be stored in a certain partition.
通常，分区键是基于时间的，因此这种设计会把某一周、月或季度的数据存储在特定分区中。
As this example demonstrates, the new partitioning key causes minimal data skew and is a much better choice than the original S_NATIONAL key from example 1.
正如这个示例所展示的，新的分区键带来了极少的数据倾斜，因此比示例1中的原始s_national键好很多。
Based on your data model, you should select partitioning keys that favor frequent joins and that are based on a primary key.
基于数据模型，选择那些有利于频繁合并且基于主键的分区键。
In such cases, it is recommended that you choose a partitioning key based on even data balancing.
在这些情况下，建议您基于数据平衡选择分区键。
For data partitioning environments, DB2 requires a remote shell utility to execute commands on a remote partition.
对于数据分区环境，DB 2需要一个远程shell实用程序来在远程分区上执行命令。
应用推荐