With inter-partition parallelism, for any given query, DB2 first identifies the partitions where the data resides.
若启用分区间并行性,对于任何给定的查询,DB2首先识别数据所驻留的分区。
To enable the optimizer to choose the intra-partition parallelism you must set the intra_parallel database manager configuration parameter as shown here.
要启用优化器以选择分区内并行性,您必须按如下所示设置分区内并行的数据库管理器配置参数。
In order to achieve parallelism during the load, you can manually create multiple load jobs, one for each partition or alternatively, you can load multiple partitions within a single load utility.
为了在装载过程中实现并行性,可以手动地创建多个LOAD任务,每个分区对应一个任务,或者,也可以在单个LOAD实用程序中装载多个分区。
Partition the table space as evenly as possible, because the degree of parallelism is influenced by skews in the 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.
本文描述的高级并行机制、数据和分区关联以及其他技术都提供了一组重要工具,使用这些工具可以帮助简化脱机处理。
DB2 EEE supports two types of parallelism: inter-partition and intra-partition.
DB 2EEE支持两类并行性:分区间和分区内。
DB2 EEE supports two types of parallelism: inter-partition and intra-partition.
DB 2EEE支持两类并行性:分区间和分区内。
应用推荐