Data Set Options for Relational Databases |
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
|
MBUFSIZE=size-of-shared-memory-buffers
|
- size-of-shared-memory-buffers
-
a numeric value (between the size of a row being loaded
and 1MB) that specifies the buffer size.
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.
For information about changing the number of shared memory buffers,
see the
BUFFERS= Data Set Option.
MULTILOAD= Data Set Option
Using MultiLoad
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.