Providing software solutions since 1976
Training & Bookstore
Loading data from SAS to Teradata using SAS/Access® Interface to
Teradata's FASTLOAD functionality has shown worse performance in SAS 9
compared to SAS 8.
In order to address this issue, the following steps must be taken:
The FBUFSIZE data set option should be set to 32000. SAS 9 normally
sends 64000-byte buffers. Setting FBUFSIZE to 32000 reverts the buffer
size back to the SAS 8.2 default.
Setting the resp_buf_len to 32767 in the clispb.dat file and using
OVERRIDE_RESP_LEN=YES forces SAS 9 to revert to the SAS 8.2 default for
the Teradata client response buffer.
By default, a COMMIT is issued after inserting 1000 rows. Setting
DBCOMMIT=0 will allow all rows to be inserted prior to a COMMIT, thus
speeding up the process.
An example of using all of these settings after applying the hot fix is
Select the Hot Fix tab in this note to access the hot fix for this issue.
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: