Specifies the size of the shared memory buffers to use for transferring data from SAS to Teradata.
| Valid in: | DATA and PROC steps (when creating and appending to DBMS tables using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Default: | 64K |
| Restriction: | Starting in SAS 9.4M9, this option is not used. Documentation remains for users who have not upgraded to SAS 9.4M9. |
| Requirement: | To specify this option, you must first specify MULTILOAD=YES. |
| Data source: | Teradata |
| See: | BUFFERS= data set option, MULTILOAD= data set option, Teradata MultiLoad documentation, Using MultiLoad |
Table of Contents
specifies a numeric value (between the size of a row being loaded and 1MB) that specifies the buffer size.
This option pertains only to non-TPT MultiLoad. Two data set options, MBUFSIZE= and BUFFERS=, are available for tuning the number and size of data buffers used for transferring data from SAS to Teradata. Use BUFFERS= to vary the number of buffers for data transfer from 1 to 8. Use MBUFSIZE= to vary the size of the shared memory buffers from the size of each data row up to 1MB.
When you enable MULTILOAD=, data transfers from SAS to Teradata using shared memory segments by using the non-TPT MultiLoad operator. The default shared memory buffer size is 64K. The default number of shared memory buffers that are used for the transfer is 2.