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
>>-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).