The calculations are performed in parallel on each partition — where the data is.
计算是在每个分区(数据所在的位置)上并行执行的。
Each index partition indexes rows only from the corresponding data partition.
每个索引分区仅从相应的数据分区取得索引行。
Additionally, ADC only occurs if no compression dictionary exists within the physical table data object or partition.
此外,只有当物理表数据对象或分区中没有压缩字典时,才能运行adc。
With TP, the user can manually define each data partition, including the range of values to include in that data partition.
通过TP,用户可以手动地定义每个数据分区,包括将被包括到那个分区的值的范围。
Most importantly, I performed a backup of the managed systems partition profile data, using the HMC.
最重要的是,我使用 HMC对管理的系统分区配置文件数据执行了备份。
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.
备份管理的系统分区配置文件数据。
Advanced parallelism, data and partition affinity, and other techniques described in this article provide an essential set of tools that can help streamline offline processing.
本文描述的高级并行机制、数据和分区关联以及其他技术都提供了一组重要工具,使用这些工具可以帮助简化脱机处理。
You can partition data based on time by defining database views that contain historic data and the current month data respectively.
通过分别定义包含历史数据和当前月份数据的数据库视图,您可以根据时间对数据进行分区。
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数据。
Q: How do I know if a data partition or an index partition needs to be reorganized?
Q:我如何知道一个数据分区或者索引分区是否需要重组?
As updates are made to the data in a partition, the replica is updated as well.
对一个分区中的数据更新时,该副本也将得到更新。
One the other hand, DPF introduces the additional consideration of sending the rows to the proper data partition.
另一方面,DPF又需要考虑将行发送到适当的数据分区。
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.
低延迟改进场景:基于时间的分区数据。
Partition the data to enable linear horizontal scale-out.
分区数据以支持线性水平扩展。
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时出现。
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)。
Specifically, the plug-in would examine some partition meta-data associated with the work partition to be executed and, based on well-defined rules, route partitions to specific endpoints.
具体来说,插件将检查与要执行的工作分区关联的某个分区元数据,并基于定义良好的规则将分区路由到特定的端点。
Specifically, the plug-in would examine some partition meta-data associated with the work partition to be executed and, based on well-defined rules, route partitions to specific endpoints.
具体来说,插件将检查与要执行的工作分区关联的某个分区元数据,并基于定义良好的规则将分区路由到特定的端点。
应用推荐