Disabling query parallelism
You can prevent DB2® from using parallel processing.
Procedure
To disable parallel operations, do any of the following actions:
Results
Example
If
the following resource limit table is active, it causes the following
effects:
- Disables I/O parallelism for all dynamic queries in the IOHOG package.
- Disables CP parallelism and Sysplex query parallelism for all dynamic queries in the CPUHOG package.
RLFFUNC | AUTHID | LUNAME | RLFCOLLN | RLFPKG |
---|---|---|---|---|
3 | (blank) | PUBLIC | blank | IOHOG |
4 | (blank) | PUBLIC | blank | CPUHOG |
5 | (blank) | PUBLIC | blank | CPUHOG |