Skip to Content

PARAMDEG—Maximum parallelism degree

Use the Modify Maximum Parallelism Degree panel or the PARAMDEG command to control the degree of parallelism for a parallel group. This value specifies the maximum number of parallel threads that can be spawned to service a single query. You can use this command to take advantage of parallelism while controlling virtual storage growth.

Modify Maximum Parallelism Degree panel

DDTG DBI1 Modify Maximum Parallelism Degree
Command ===> _________________________________________________________________

 Command: CURRENT
Description . . . . . . . . : MAXIMUM PARALLELISM DEGREE

Type the new Maximum Parallelism Degree you wish to change to. Then press Enter

Maximum Parallelism Degree Parameter
Parallelism Degree . . . . . _____ (0-254 or delta)

Command syntax and parameters

image2018-12-24_12-43-41.png

Value

Description

DB2ssid

Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies.

opertuneID

OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job).

value

Number of parallel threads that can be spawned to service a single query. Specify one of the following values:

  • 0—there is no upper limit on parallelism (the default)
  • 1—parallelism is effectively disabled
  • A numerical value in the range 2–254
  • A delta value
    Delta values are expressed numerically (+nn or -nn) or as a percentage (+nn% or -nn%). The resulting value must fall in the range 0–254.

NORESET

The changes you request remain in effect until the Db2 subsystem is cycled.

Db2 parameter values

Field

Installation panel

CLIST parameter

ZPARM macro

ZPARM parameter

Parallelism Degree

DSNTIP4

PARAMDEG

DSN6SPRM

PARAMDEG

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

OPERTUNE for DB2 13.1