Enabling parallel processing within a data sharing group

For a member to be a parallelism coordinator, you must specify YES for the COORDINATOR parameter of installation panel DSNTIPK.

Important: Start of change

Sysplex query parallelism is deprecated and will be removed in a future release of DB2®. End of change

To allow a member to be a parallelism assistant, you must specify YES for the ASSISTANT parameter of the same panel. At run time, assistants must have buffer pools defined to allow parallelism, or DB2 does not send work to those members.

Displaying coordinator and assistant parameter values: The command DISPLAY GROUP with DETAIL option allows you to see the values of the COORDINATOR and ASSISTANT subsystem parameters for all active members of a data sharing group. For example, the following command displays output similar to the figure below:

Begin general-use programming interface information.

-DB1A DISPLAY GROUP DETAIL

Figure 1. DISPLAY GROUP with DETAIL option

DSN7100I -DB1A DSN7GCMD
*** BEGIN DISPLAY OF GROUP(DSNDB0A ) GROUPLEVEL(610)        
                                     GROUP ATTACH NAME(DB0A)  MODE(C)
--------------------------------------------------------------------
DB2                                    DB2  SYSTEM   IRLM
MEMBER   ID  SUBSYS CMDPREF   STATUS   LVL  NAME     SUBSYS IRLMPROC
-------- --- ----   --------  -------- ---  -------  ----   --------
DB1A       1 DB1A   -DB1A     ACTIVE   610  MVS1     DJ1A   DB1AIRLM
DB2A       2 DB2A   -DB2A     ACTIVE   610  MVS2     DJ2A   DB2AIRLM
DB3A       3 DB3A   -DB3A     QUIESCED 610  MVS3     DJ3A   DB3AIRLM
DB4A       4 DB4A   -DB4A     ACTIVE   610  MVS4     DJ4A   DB4AIRLM
--------------------------------------------------------------------
DB2      PARALLEL    PARALLEL
MEMBER   COORDINATOR ASSISTANT
-------- ----------- ---------
DB1A             YES        NO
DB2A             YES       YES
DB3A            ****      ****
DB4A              NO        NO
--------------------------------------------------------------------
SCA   STRUCTURE SIZE:     1024 KB, STATUS= AC,   SCA IN USE:    11 %
LOCK1 STRUCTURE SIZE:     1536 KB
NUMBER  LOCK ENTRIES:      262144
NUMBER  LIST ENTRIES:        7353, LIST ENTRIES  IN USE:           0
*** END DISPLAY OF GROUP(DSNDB0A )
DSN9022I -DB1A DSN7GCMD 'DISPLAY GROUP ' NORMAL COMPLETION

End general-use programming interface information.