BL_DISK_PARALLELISM= Table Option

Specifies the number of processes or threads to use when writing data to disk.

Category: Bulk Loading
Requirement: Must be specified within the BULKOPTS= Table Option
Data source: DB2 under UNIX and PC

Syntax

BL_DISK_PARALLELISM= number-of-processes-or-threads

Arguments

number-of-processes-or-threads

specifies the number of processes or threads that the load utility uses to write data records to the table-space containers.

Details

This option exploits the available containers when it loads data and significantly improves load performance.
The maximum number that is allowed is the greater of four times the BL_CPU_PARALLELISM value, which the load utility actually uses, or 50. By default, BL_DISK_PARALLELISM is equal to the sum of the table-space containers on all table spaces that contain objects for the table that is being loaded except where this value exceeds the maximum number that is allowed.
If you do not specify a value, the utility selects an intelligent default that is based on the number of table-space containers and the characteristics of the table.
For more information about using this option, see the DISK_PARALLELISM parameter in IBM DB2 Universal Database Data Movement Utilities Guide and Reference.
Last updated: February 23, 2017