PARALLELISM EFFICIENCY field (PARA_EFF subsystem parameter)
The PARA_EFF subsystem parameter controls the efficiency that Db2 assumes for parallelism when Db2 chooses an access path. The integer value that is used for this parameter represents a percentage efficiency.
Deprecated subsystem parameter: Non-default settings for PARA_EFF are deprecated. Db2 12 supports these settings, but their use is discouraged, and support is removed in Db2 13 or later. For best results, use the default value 50.
| Acceptable values: | 0–100 |
|---|---|
| Default: | 50 |
| Update: | option 30 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM PARA_EFF |