ADMIN_GET_INTRA_PARALLEL scalar function - Get intrapartition parallelism state

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

Read syntax diagramSkip visual syntax diagramADMIN_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 database 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 CLP:

VALUES SYSPROC.ADMIN_GET_INTRA_PARALLEL

1  
---
NO 

  1 record(s) selected.