Typically, when SAS/ACCESS Interface to Teradata connects to the Teradata database, two connections are made to the database. However, if you use the UTILCONN_TRANSIENT=YES option in a LIBNAME statement and use the CREATE TABLE command, multiple connections are spawned. As a result, one of the following issues might occur:

• One of the connections is active while the other connection is inactive. When the inactive connection is terminated after a set number of minutes, the active connection is terminated as well. This stops any processes that you have running.


• When you are processing both SAS data sets and Teradata tables, the behavior could be worse, because processing the SAS data set could easily exceed the limited number of minutes. In that case, the Teradata connection is terminated before the database has even been accessed.

To avoid this issue, do not use the UTILCONN_TRANSIENT=YES option in a LIBNAME statement if this libref will be used in the CREATE TABLE command.

Operating System and Release Information

A fix for this issue for Base SAS 9.21_M3 is available at:

A fix for this issue for Base SAS 9.3_M1 is available at: