SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 14224: Remote Library Services and SAS/ACCESS combined has poor performance results

DetailsHotfixAboutRate It
Using the REMOTE LIBRARY SERVICES and SAS/ACCESS engines together
may cause performance problems with SAS 9.1.  It appears that using the
ERRLIMIT= option in SAS/SHARE or SAS/CONNECT environments can result in
performance degradations when creating or populating a newly created
table using SAS/ACCESS.

This problem was introduced when support was added for the ERRLIMIT=
option with SAS/SHARE to turn off it's buffering of observations.  In
doing so, Share is limiting the data movement from the server to one
observation at a time now, rather than in a MOB (multi- observation
buffer). Share will revert to this single observation transmission if an
engine returns a warning or error on an operation. Apparently, with
Access engine's it will automatically turn off MOBing if the ERRLIMIT=
option isn't set to zero.  ERRLIMIT=1 is the default.

To work around this problem, specify ERRLIMIT=0 on the Access librefs on
the SAS/SHARE server.

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#014224

For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:

http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#014224


Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to SybaseMicrosoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to TeradataMicrosoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to PeopleSoftMicrosoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to SAP BWMicrosoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to R/3Microsoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to OracleMicrosoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to PC FilesMicrosoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to Oracle RdbMicrosoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to OLE DBMicrosoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to MySQLMicrosoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to ODBCMicrosoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to InformixMicrosoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to DB2 Server for VMMicrosoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to IMS-DL/IMicrosoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to DB2Microsoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to CA-IDMSMicrosoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to CA-OpenIngresMicrosoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to CA-Datacom/DBMicrosoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to AdabasMicrosoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
SAS SystemSAS/ACCESS Interface to BaanMicrosoft Windows XP Professional9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows NT Workstation9.1 TS1M09.1 TS1M3 SP2
Microsoft Windows 2000 Professional9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled Solaris9.1 TS1M09.1 TS1M3 SP2
Linux9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled HP-UX9.1 TS1M09.1 TS1M3 SP2
64-bit Enabled AIX9.1 TS1M09.1 TS1M3 SP2
Tru64 UNIX9.1 TS1M39.1 TS1M3 SP2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.