num_flushers_per_partition - Number of flushers per database partition configuration parameter

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).