SET RUNTIME DEGREE command

Scope

This command affects all database partitions that are listed in the $HOME/sqllib/db2nodes.cfg file.

Authorization

Required connection

Instance. To change the maximum run time degree of intra-partition parallelism on a remote server, it is first necessary to attach to that server. If no attachment exists, the SET RUNTIME DEGREE command fails.

Command syntax

>>-SET RUNTIME DEGREE FOR--+-ALL--------------------------+----->
                           |    .-,------------------.    |   
                           |    V                    |    |   
                           '-(----application-handle-+--)-'   

>--TO--degree--------------------------------------------------><

Command parameters

FOR

ALL

The specified degree will apply to all applications.

application-handle

Specifies the agent to which the new degree applies. List the values using the LIST APPLICATIONS command.

TO degree

The maximum run time degree of intra-partition parallelism.

Usage notes

This command provides a mechanism to modify the maximum degree of parallelism for active applications. It can be used to override the value that was determined at SQL statement compilation time.

The run time degree of intra-partition parallelism specifies the maximum number of parallel operations that will be used when the statement is executed. The degree of intra-partition parallelism for an SQL statement can be specified at statement compilation time using the CURRENT DEGREE special register or the DEGREE bind option. The maximum run time degree of intrapartition parallelism for an active application can be specified using the SET RUNTIME DEGREE command. The max_querydegree database manager configuration parameter specifies the maximum run time degree for any SQL statement executing on this instance of the database manager.

The value in the CURRENT DEGREE special register and the intra_parallel setting can be overridden in a workload by setting the MAXIMUM DEGREE workload attribute.