DB2 10.5 for Linux, UNIX, and Windows

ADMIN_SET_INTRA_PARALLEL procedure - Enables or disables intrapartition parallelism

The ADMIN_SET_INTRA_PARALLEL procedure enables or disables intrapartition parallelism for a database application. Although the procedure is called in the current transaction, it takes effect starting with the next transaction.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-ADMIN_SET_INTRA_PARALLEL--(--state--)-----------------------><

The schema is SYSPROC.

Procedure parameters

state
An input argument of type VARCHAR(3) that specifies the required state of intrapartition parallelism for the database application. The argument can be one of the following values:
YES, or yes
The database application starts to run with intrapartition parallelism enabled starting with the next transaction.
NO, no
The database application starts to run with intrapartition parallelism disabled starting with the next transaction.
NULL
The database application starts to run with the intrapartition parallelism state dependent on the value of the intra_parallel database manager configuration parameter, starting with the next transaction.

Authorization

One of the following authorities is required to execute the routine:
  • EXECUTE privilege on the routine
  • DATAACCESS authority
  • DBADM authority
  • SQLADM authority

Default PUBLIC privilege

None

Examples

Example 1: To run the database application with intrapartition parallelism enabled from the next transaction:
CALL ADMIN_SET_INTRA_PARALLEL('YES')
Example 2: To run the database application with intrapartition parallelism disabled from the next transaction:
CALL ADMIN_SET_INTRA_PARALLEL('NO')
Example 3: To run the database application with intrapartition parallelism state dependent on the value of the intra_parallel database manager configuration parameter:
CALL ADMIN_SET_INTRA_PARALLEL(NULL)

Usage notes

The required state of parallelism set through ADMIN_SET_INTRA_PARALLEL only takes effect for the application invoking this procedure.

Calls to ADMIN_SET_INTRA_PARALLEL will not change the intra_parallel database manager configuration parameter setting.

Intrapartition parallelism settings applied by ADMIN_SET_INTRA_PARALLEL can be overridden if the database application is associated with a workload that has specified a value for the MAX DEGREE workload attribute.

Intrapartition parallelism cannot be enabled by this procedure if the shared sort heap is not available (SQL5192W).