Use BLOCK FACTOR to reduce I/O when loading from a flat file. The BLOCK FACTOR option of the LOAD command specifies the blocking factor, or number of records per block, that were used when the input file was created. The default BLOCK FACTOR is 10,000.
The syntax for this load option is as follows:
BLOCK FACTOR = integer
Use the following guideline to determine BLOCK FACTOR:
record size * BLOCK FACTOR = memory required
You need extra memory for this option, in addition to the memory for the buffers. If you have a lot of memory available, or if no other users are active concurrently, increasing the value of BLOCK FACTOR can improve load performance.
