Parallel processing access (PARALLELISM_MODE='I', 'C', or 'X')
DB2® can use parallel processing for read-only queries.
- If the PARALLELISM_MODE value is:
- DB2 plans to use:
- I
- Parallel I/O operations.
Query I/O parallelism is deprecated and is likely to be
removed in a future release.
- C
- Parallel CP operations.
- X
- Sysplex query parallelism. Sysplex query parallelism is deprecated and is
likely to be removed in a future release.
Non-null values in the ACCESS_DEGREE and JOIN_DEGREE columns indicate the degree of parallelism that DB2 plans to use. However, at execution time, DB2 might not actually use parallelism, or use fewer operations in parallel than originally planned.
