Problem Note 63718: You encounter slow performance when you use SAS® Federation Server to read in SAS® data sets
 |  |  |  |  |
When you read SAS data sets using SAS Federation Server, you might encounter slow performance.
Click the Hot Fix tab in this note to access the hot fix for this issue.
After you install this hot fix, you can use the following new LIBNAME options to improve performance:
- PREFETCH=x
This option enables or disables the PreFetch capability. It is optional but is required to enable PreFetch.
0 | OFF | FALSE | NO or not specified: These turn off PreFetch.
1 | ON | TRUE | YES: These use the default value, which currently is 4.
[If you use any other unsigned integer]: The maximum number of client-side prefetch rowsets to cache.
The minimum is 2, the maximum is 32, and the default is 4. - SERVERPREFETCH=x
This option enables or disables the server-side PreFetch capability. It is optional and is valid only when you specify PREFETCH=.
Not specified: Uses the PREFETCH= (client-side) value.
0 | OFF | FALSE | NO: These disable the server-side PreFetch capability (client-side only).
1 | ON | TRUE | YES: These use the default, which currently is 4.
[If you use any other unsigned integer]: The maximum number of server-side prefetch rowsets to cache.
The minimum is 2, the maximum is 32, and the default is 4. - PREFETCHROWS=x
This setting is the suggested number of rows for the server-side prefetch rowset.
This setting is optional.
The minimum is 10, and the maximum is 10,000. - PREFETCHBYTES=x
This setting is the suggested number of bytes for the server-side prefetch rowset.
This setting is optional.
The minimum is 200 KB, and the maximum is 2 MB.
Here is an example of a SAS Federation Server LIBNAME statement that uses these options:
/* using a default number of prefetch rowsets and a default row-array size. */
libname A fedsvr readbuff=500 noprompt="driver=remts;server=localhost;port=24141;uid=sasfedadm@saspw;pwd=xxx;conopts=(dsn=base); prefetch=true;";
/* A connection to enable PREFETCH on both the client and the server */
/* using 3 prefetch rowsets (client), */
/* 6 prefetch rowsets (server), and 2,000 prefetch rows per rowset. */
libname B fedsvr readbuff=500 noprompt="driver=remts;server=localhost;port=24141;uid=sasfedadm@saspw;pwd=xxx;conopts=(dsn=base); prefetch=3;serverprefetch=6;prefetchrows=2000";
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 TS1M5 | 9.4 TS1M6 |
| Linux for x64 | 4.2 | 4.2 | 9.4 TS1M5 | 9.4 TS1M6 | ||
An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdatesA fix for this issue for SAS Threaded Kernel Extensions for FedSQL and DS2 Standalone 9.4_M6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E5Q.html#63718A fix for this issue for SAS Threaded Kernel 9.4_M6 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E2G.html#63718A fix for this issue for SAS Threaded Kernel 9.4_M5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C1S.html#63718A fix for this issue for SAS Federation Server 4.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Y46.html#63718| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-02-25 11:11:18 |
| Date Created: | 2019-02-21 13:58:37 |