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:

1. Install the hot fix referenced in the link below
2. Use the FBUFSIZE data set option to force SAS to use a 32K buffer size to send data to Teradata
3. Change the value of resp_buf_len to 32767 in your clispb.dat file
4. Use the OVERRIDE_RESP_LEN=YES LIBNAME option to force SAS to use the resp_buf_len setting in the clispb.dat file
5. Set DBCOMMIT=0 in the LIBNAME statement

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 below:

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

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: