DEGREE bind option
The DEGREE option determines whether to attempt to run a query using parallel processing to maximize performance.
| Command option | Option values | Used with |
|---|---|---|
| DEGREE |
|
Note:
- The DEGREE bind option is not valid for REBIND of packages for native SQL procedures or advanced triggers.
Option descriptions for DEGREE
- DEGREE(1)
Disables most forms of query parallel processing for static SQL statements in the package.
Specifying DEGREE(1)does not disable DPSI parallelism. For information about how to disable DPSI parallelism, see MAX DEGREE FOR DPSI field (PARAMDEG_DPSI subsystem parameter).
- DEGREE(ANY)
- Specifying DEGREE(ANY) enables Db2 to choose any degree of query parallelism.
Limitations for DEGREE
For plans, DEGREE has no effect.
If you bind plans or packages using DEGREE(ANY), the space required in the EDM pool could increase by 50% to 70%.
Default values for DEGREE
| Process | Default value |
|---|---|
| BIND SERVICE | 1 |
| BIND PLAN | 1 |
| BIND PACKAGE | 1 |
| REBIND PLAN | Existing value |
| REBIND PACKAGE | Existing value |
Catalog records for DEGREE
See the DEGREE column in SYSPACKAGE catalog table and SYSPLAN catalog table.