Two thread pools control the parallelism of statement execution.
SQLExecutor:
JobExecutor:
SQL Executor: indexserver.ini.
JobExecutor: global.ini or indexserver.ini.
Parallelism Stopen HINT Details - MAX_CONCURRENCY Controls concurrency. This setting only accepts the value 1 (single thread plan execution) and the Join Engine determines suitable parallelism by default.
Examples:
SELECT * FROM T1 WITH HINT( MAX_CONCURRENCY(1) );
SPS11.
SAP auto-determines degree of parallelism statement execution with max parallelization.
Degree of Parallelism:
8 means max 8 threads can be engaged at any one time for any one statement.
Job Executor parameter that set the execution priority for a connection (ie for a statement)
alter user SYSTEM set parameter PRIORITY = '9';
select priority from m_connections where connection_id = CURRENT_CONNECTION;
workload class permits to limit also the parallelism.