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
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
- EXECUTE privilege on the routine
- DATAACCESS authority
- DBADM authority
- SQLADM authority
Default PUBLIC privilege
None
Examples
CALL ADMIN_SET_INTRA_PARALLEL('YES')
CALL ADMIN_SET_INTRA_PARALLEL('NO')
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).