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