If you see the error "All available virtual
memory has been used ...", the virtual memory
has run out.
There are several courses of action you can take if you encounter the previous error:
You can set an upper limit on the amount of virtual memory a LOAD command can use by setting LOAD_MEMORY_MB to a non-zero value, with 2000MB the maximum allowed value.
You can also adjust BLOCK FACTOR or BLOCK SIZE LOAD command options. These command options default to 10000 and 500000, respectively, but you can set them to any number. Setting them lower forces the load to use less virtual memory.
You can also resort to loading a subset of the columns at a time, which is referred to as a partial-width load.
