Problem Note 18396: Queries or WHERE clauses run against large data sets can cause
SAS/SHARE® server to hang
With some queries or WHERE clauses that run against large data sets
through a SAS/SHARE server, the server might become unresponsive. For
example, a query such as the query shown below, when run against a table
that has 20 million observations, might not yield to other users or
requests.
select idvar from libref.table where lowcase(textvar) ? "some text"
The problem is that the underlying BASE engine yields only after a given
number of selected observations are read, rather than after raw
observations are read. In this situation, setting LRPYIELD= to a higher
value in PROC SERVER will not help.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS/SHARE | Microsoft Windows XP Professional | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Server | 9.1 TS1M3 | 9.2 TS1M0 |
| z/OS | 9.1 TS1M3 | 9.2 TS1M0 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | 9.2 TS1M0 |
| Linux | 9.1 TS1M3 | 9.2 TS1M0 |
| Linux on Itanium | 9.1 TS1M3 | 9.2 TS1M0 |
| HP-UX IPF | 9.1 TS1M3 | 9.2 TS1M0 |
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.2 TS1M0 |
| OpenVMS Alpha | 9.1 TS1M3 | 9.2 TS1M0 |
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.2 TS1M0 |
| Tru64 UNIX | 9.1 TS1M3 | 9.2 TS1M0 |
*
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.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2006-10-11 16:29:09 |
| Date Created: | 2006-08-31 10:06:05 |
