Specifies the total amount of memory to allocate for the bulk-load utility to use as a buffer for transferring data.
| 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_DISK_PARALLELISM= data set option, BULKLOAD= data set option |
Table of Contents
specifies the total amount of memory that is allocated for the bulk-load utility to use as buffered space for transferring data within the utility. Memory is calculated in 4 KB pages regardless of the degree of parallelism.
If you specify a value that is less than the algorithmic minimum, the minimum required resource is used and no warning is returned. This memory is allocated directly from the utility heap, the size of which you can modify through the util_heap_sz database configuration parameter. If you do not specify a value, the utility calculates an intelligent default at run time. This calculated default is based on a percentage of the free space that is available in the utility heap at the time of instantiation of the loader, as well as on some characteristics of the table.
It is recommended that the buffer be several extents in size. An extent is the unit of movement for data within DB2, and the extent size can be one or more 4KB pages. The DATA BUFFER parameter is useful when you are working with large objects (LOBs) because it reduces input and output waiting time. The data buffer is allocated from the utility heap. Depending on the amount of storage available on your system, you should consider allocating more memory for use by the DB2 utilities. You can modify the database configuration parameter util_heap_sz accordingly. The default value for the Utility Heap Size configuration parameter is 5000 4KB pages. Because load is only one of several utilities that use memory from the utility heap, it is recommended that no more than 50% of the pages specifies by this parameter be made available for the load utility.
For more information about using this option, see the DATA BUFFER parameter in the IBM DB2 Universal Database Data Movement Utilities Guide and Reference.