BL_DISK_PARALLELISM= Data Set Option

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

Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default:	none
Requirement:	To specify this option, you must first set BULKLOAD=YES.
Data source:	DB2 under UNIX and PC Hosts
See:	BL_CPU_PARALLELISM= data set option, BL_DATA_BUFFER_SIZE= data set option, BULKLOAD= set option

Syntax

Details

Syntax

BL_DISK_PARALLELISM=number-of-processes-or-threads

Syntax Description

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 50 or four times the BL_CPU_PARALLELISM value, which the load utility actually uses. 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 the IBM DB2 Universal Database Data Movement Utilities Guide and Reference.