MBUFSIZE= Data Set Option

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)
Default:	64K
Requirement:	To specify this option, you must first set MULTILOAD=YES.
Data source:	Teradata
Tip:	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.
See:	BUFFERS= data set option, MULTILOAD= data set option Using MultiLoad

Syntax

Details

Syntax

MBUFSIZE=size-of-shared-memory-buffers

Syntax Description

size-of-shared-memory-buffers: specifies a numeric value (between the size of a row being loaded and 1MB) that specifies the buffer size.

Details

This option specifies the size of data buffers used for transferring data from SAS to Teradata. Two data set options are available for tuning the number and size of data buffers used for transferring data from SAS to Teradata.

When you use MULTILOAD=, data transfers from SAS to Teradata using shared memory segments. The default shared memory buffer size is 64K. The default number of shared memory buffers that are used for the transfer is 2.