Specifies the number of flushers to allocate for each database
partition.
- Configuration type
- Ingest utility
- Applies to
- Ingest utility
- Parameter type
- Configurable
- Default [range]
- max( 1, ((number of logical CPUs)/2)/(number of partitions) )
[0 to system resources]
When num_flushers_per_partition is
set to 0, one flusher is used for all partitions.
Note: When the
operation is DELETE, MERGE, or UPDATE, the utility will sometimes
reduce this parameter to 0 or 1 in order to reduce the chances of
a deadlock occurring (SQL2903W).
DB2 10.5 for Linux, UNIX, and Windows