Data Set Options for Relational Databases

BL_DISK_PARALLELISM= Data Set Option

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

Default value:	none
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	DB2 under UNIX and PC Hosts

Syntax
Syntax Description
Details
See Also

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

To specify this option, you must first set BULKLOAD=YES.

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.