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实用程序中装载多个分区。
应用推荐