Mixed parallelism with queries that reference nicknames

For queries that contain local tables and nicknames in a partitioned environment, the optimizer can use both intrapartition and interpartition parallelism. Interpartition parallelism is an option for the optimizer in a partitioned environment. Intrapartition parallelism is an option, if it has been enabled in the database configuration or database manager configuration.

For interpartition parallelism, the federated server can distribute remote data among partitions and process data in parallel within each partition.

For intrapartition parallelism, multiple subagent processes within a partition are used to process local data in parallel.