The ADMIN_GET_INTRA_PARALLEL scalar function returns the
current state of intrapartition parallelism for the application. It
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.
Example
Find the current state of intrapartition
parallelism from DB2® CLP:
VALUES SYSPROC.ADMIN_GET_INTRA_PARALLEL
1
---
NO
1 record(s) selected.
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.