TRUE on multiple-CPU systems,
FALSE on single-CPU systems
Allows stream building on the client system to be done in parallel with stream loading on the server system.
Syntax and Description
MULTITHREADING=[TRUE | FALSE]
By default, the multithreading option is always enabled (set to
TRUE) on multiple-CPU systems. In this case, the definition of a multiple-CPU system is a single system that has more than one CPU.
On single-CPU systems, multithreading is set to
FALSE by default. To use multithreading between two single-CPU systems, you must enable multithreading; it will not be on by default.
MULTITHREADING parameter is available only for direct path loads.
Multithreading functionality is operating system-dependent. Not all operating systems support multithreading.
The following example enables multithreading on a single-CPU system. On a multiple-CPU system it is enabled by default.