The ADMIN_GET_INTRA_PARALLEL scalar function returns the
current state of intrapartition parallelism for the application.
This function can be used to check if current statements
are running with parallelized query access plan.
Syntax
>>-ADMIN_GET_INTRA_PARALLEL--(--)------------------------------><
The schema is SYSPROC.
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
Information
returned
This function returns a value of type VARCHAR(3)
that specifies the current state of intrapartition parallelism for
the database application. One of the following values is returned:
- YES
- The database application will run with intrapartition parallelism
enabled.
- NO
- The database application will run with intrapartition parallelism
disabled.
Usage notes
The value returned by ADMIN_GET_INTRA_PARALLEL
can be different from the state set by ADMIN_SET_INTRA_PARALLEL in
the following cases:
- ADMIN_SET_INTRA_PARALLEL was called during a transaction and the
transaction is not yet committed or rolled back.
- ADMIN_SET_INTRA_PARALLEL was called during a transaction that
opens a with hold cursor and the current transaction has not yet closed
the cursor.
- The application is associated with a DB2® workload,
which has a value applied to the MAX DEGREE workload attribute that
is different than the one specified by the call to ADMIN_SET_INTRA_PARALLEL.
Example
Find the current state of intrapartition
parallelism from DB2 CLP:
VALUES SYSPROC.ADMIN_GET_INTRA_PARALLEL
1
---
NO
1 record(s) selected.
DB2 10.5 for Linux, UNIX, and Windows