When you migrate from SAS 8.2 to SAS 9.1.3 SAS in the UNIX environment, significant performance degradation occurs when you run programs in SAS/ACCESS Interface to Sybase.

In SAS^® 9, SHARED is the default value for the CONNECTION= option. Changing that value to UNIQUE fixes the performance degradation for queries that use the LIBNAME statement. However, queries made with the ACCESS procedure are not affected by CONNECTION=UNIQUE. As a result, you will still experience performance degradation for those queries.

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: