LOAD buffer manipulator. The last character 'X' indicates one or more. Writes loaded data to the database and can be involved in async I/O. There is always one and often more depending on a heuristic. The heuristic is based on the number of CPUs on the system and the number of containers being written to.
This "intelligent default" may be overridden by the DISK_PARALLELISM modifier to the LOAD command.
We should make it clear that this Async I/O is not the async file I/O supported by some operating systems; it just means that we have separate processes writing the I/O. This means that other processes that are formatting the data are not tied up on I/O waits.
Visit the new-look IDUG Website , register to gain access to the excellent content.