IBM Red Brick Warehouse Queryprocs and Parallel Count values
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.
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