Data Set Options for Relational Databases

MBUFSIZE= Data Set Option

Specifies the size of the shared memory buffers to use for transferring data from SAS to Teradata.

Default value:	64K
Valid in:	DATA and PROC steps (when creating and appending to DBMS tables using SAS/ACCESS software)
DBMS support:	Teradata

Syntax
Syntax Description
Details
See Also

Syntax

MBUFSIZE=size-of-shared-memory-buffers

Syntax Description

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

Details

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

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.

Use the MBUFSIZE= data set option to vary the size of the shared memory buffers from the size of each data row up to 1MB.

Use BUFFERS= to vary the number of buffers for data transfer from 1 to 8.