Problem Note 62582: You encounter performance issues when you try to get a list of tables or views using the FEDSVR LIBNAME engine
 |  |  |  |  |
When you try to access a library with more than 4,000 views or tables using the FEDSVR LIBNAME engine, you encounter slow performance. In this scenario, it might take up to two minutes to load the data in either SAS® Explorer or SAS® Enterprise Guide®.
For example, you encounter this issue when you submit code similar to the following:
libname fedlib fedsvr dsn="BASE-View" server="server-name" port=port-number schema='schema-name';
proc datasets lib=fedlib;
quit;
proc datasets lib=fedlib;
quit;
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Federation Server | Microsoft® Windows® for x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 |
| Microsoft Windows 8 Enterprise x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Datacenter | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| HP-UX IPF | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Linux for x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
| Solaris for x64 | 4.2 | 4.2 | 9.4 TS1M3 | 9.4 TS1M6 | ||
A fix for this issue for Base SAS 9.4_M5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B6Q.html#62582
When you try to access a library with more than 4,000 tables or views using the FEDSVR LIBNAME engine, you experience slow performance. It might take up to two minutes to retrieve the data in either SAS® Explorer or SAS® Enterprise Guide®.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-07-26 10:34:44 |
| Date Created: | 2018-07-06 11:07:13 |