IBM Red Brick Warehouse Queryprocs and Parallel Count values

Technote (FAQ)


Question

Why is parallel count higher than the queryprocs setting?

Answer

The parallel count value from set stats full output can be higher than the queryprocs setting. This is working properly. The queryprocs setting is an upper limit on the parallelism per query at any point in time. During query execution when a process finishes another process can start. The parallel count value is cumulative and adds the total number of processes during query execution.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Red Brick Warehouse

Software version:

6.3

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Software edition:

All Editions

Reference #:

1616649

Modified date:

2012-11-07

Translate my page

Machine Translation

Content navigation