IBM Support

IBM Red Brick Warehouse Queryprocs and Parallel Count values

Technote (FAQ)


Why is parallel count higher than the queryprocs setting?


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.

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: 07 November 2012