DB2 10.5 for Linux, UNIX, and Windows

num_formatters - Number of formatters configuration parameter

Specifies the number of formatters to allocate.

Configuration type: Ingest utility
Applies to: Ingest utility
Parameter type: Configurable
Default [range]: max(1, ((number of logical CPUs)/2) ) [1 to system resources]

Although the default is the optimal setting, if you specify the DUMPFILE (or BADFILE) parameter on the INGEST command and you want the ingest utility to write the bad records in the same order that they appear in the input file, you must set num_formatters to 1.