Each index partition indexes rows only from the corresponding data partition.
每个索引分区仅从相应的数据分区取得索引行。
With TP, the user can manually define each data partition, including the range of values to include in that data partition.
通过TP，用户可以手动地定义每个数据分区，包括将被包括到那个分区的值的范围。
Another advantage of using partitioned tables is that new data can be easily added to a table (as another data partition) while old or obsolete data can be easily removed and archived.
使用分区表的另一个优点是，可以轻松地在表中添加新数据(作为新的数据分区)，同时可以轻松地删除并存档老数据。
Back up the managed systems partition profile data.
备份管理的系统分区配置文件数据。
The index partition for each data partition can be in a different table space.
每个数据分区的索引分区可以位于不同的表空间中。
A common design would be to create a data partition for each month's 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只支持范围分区方案)，一个数据分区包含一个行子集，这些行存储在与表中其他行集不同的地方。
In order to resolve an in doubt transaction, a data partition may need to contact another data partition.
为了解决有问题的事务，一个数据分区可能需要与另一个数据分区联系。
By default, the XML data goes in the same table space as the corresponding data partition.
默认情况下，XML数据存储到与其相应数据分区相同的表空间当中。
Q: Can the local index partition and data partition be in the same table space for each partition?
Q：每个分区的本地索引分区和数据分区能否处于同一表空间中？
Listing 3 creates a range-partitioned table with relational and XML data, rolls out (detaches) a partition containing old data, and rolls in (attaches) a partition containing recent data.
清单3创建一个包含关系和XML数据的范围分区表，滚出(分离)包含老数据的分区，滚入(附加)包含最近数据的分区。
One XDA object is created per data partition to store XML data for that partition.
在每个数据分区中创建一个XDA对象，用于存储该分区的XML数据。
The data partition being attached has indexes in a separate table space from the data.
附加的数据分区具有与其数据处于不同表空间中的索引。
Q: How do I know if a data partition or an index partition needs to be reorganized?
Q：我如何知道一个数据分区或者索引分区是否需要重组？
One the other hand, DPF introduces the additional consideration of sending the rows to the proper data partition.
另一方面，DPF又需要考虑将行发送到适当的数据分区。
Q: How to tell the data partition in which a row resides?
Q：如何知道某行所在的数据分区？
With DB2 9.7, partitioned indexes are now supported, allowing each data partition to be indexed separately.
现在，DB 2 9.7支持分区索引，允许每个数据分区单独索引。
Low latency improvement scenario: Partition data based on time.
低延迟改进场景：基于时间的分区数据。
ColumnName: Identifies one or more columns (up to 16) by name, whose values are used to determine which data partition a particular row is to be stored in.
ColumnName：用名称指定一个或多个列(最多16列)，这些列的值用来决定数据行应该存储在哪个数据分区中。
SQL20153N would only occur if db2inidb is issued sequentially on each data partition, whereas SQL1391N can occur when db2inidb is run in parallel across all data partitions.
SQL20153N只在连续地在每个数据分区上发出db2inidb 的情况下出现，而 SQL1391N在并行地在所有数据分区上运行 db2inidb时出现。
Obtaining current partition use data.
获取当前分区使用的数据。
End: Specifies the high end of the range for each data partition.
End：指定每个数据分区的范围上限。
Start: Specifies the low end of the range for each data partition.
Start：指定每个数据分区的范围下限。
IndexTSName: Identifies the table space in which the partitioned index for each data partition is to be stored.
IndexTSName：指定存储每个数据分区的分区索引的表空间。
PartitionName: Identifies the unique name to be assigned to the data partition to be created.
PartitionName：指定分配给要创建的数据分区的惟一名称。
TSName: Identifies the table space in which each data partition is to be stored.
TSName：指定存储每个数据分区的表空间。
One way to think about the WebSphere profile is to consider it as the "user data partition," the equivalent of the user's home directory in UNIX/Linux operating system environments.
可以认为WebSphere概要文件是"用户数据分区"，等同于UNIX/Linux操作系统环境中用户的主目录。
A: the DATAPARTITIONNUM function returns the sequence number (SYSDATAPARTITIONS.SEQNO) of the data partition in which the row resides.
A：函数DATAPARTITIONNUM能够返回行所在数据分区的序号(SYSDATAPARTITIONS . SEQNO)。
End: Specifies the high end of the range for the data partition.
End：指定数据分区的最高范围。
End: Specifies the high end of the range for the data partition.
End：指定数据分区的最高范围。
应用推荐