Number of Db2 threads that UNLOAD PLUS uses

DIRECT YES

The maximum number of batch threads that UNLOAD PLUS uses concurrently is six per job. UNLOAD PLUS uses up to six threads during the UTILINIT phase and two threads for the duration of the job.

DIRECT NO

When you specify DIRECT NO, UNLOAD PLUS uses two batch threads during the UTILINIT phase and uses one of these threads during the entire execution.

In the UNLOAD phase, each task uses one batch thread to process a SELECT statement. Therefore, the maximum number of batch threads that UNLOAD PLUS uses concurrently during the UNLOAD phase is equal to the number of tasks that can execute concurrently. When you specify DIRECT NO, UNLOAD PLUS uses the MAXCONNECT command option to control the maximum number of tasks that can execute concurrently.