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) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | none |
| Requirement: | To specify this option, you must first specify 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 |
Table of Contents
specifies the number of processes or threads that the load utility uses to write data records to the tablespace containers.
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 tablespace containers on all tablespaces that contain objects for the table that is being loaded. However, this value cannot exceed the maximum allowed value.
If you do not specify a value, the utility selects an intelligent default that is based on the number of tablespace 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.