SUPPORT / SAMPLES & SAS NOTES
Usage Note 20168: Parallel JOIN with GROUPBY and HAVING clause my cause memory trash
 |  |  |  |  |
With SPD Server 4.4, if you have a parallel JOIN with a GROUPBY that includes a HAVING clause, a memory trash may occur. Problems may also occur on queries that contain WHERE clauses when the SQL Base is later used as a user proxy.
Select 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* | |||
| SPDS | Scalable Performance Data Server | Microsoft Windows NT Workstation | 4.4 | 9.1 TS1M3 | ||
| Solaris for x64 | 4.4 | 9.1 TS1M3 | ||||
| Solaris | 4.4 | 9.1 TS1M3 | ||||
| 64-bit Enabled Solaris | 4.4 | 9.1 TS1M3 | ||||
| Linux on Itanium | 4.4 | 9.1 TS1M3 | ||||
| HP-UX | 4.4 | 9.1 TS1M3 | ||||
| AIX | 4.4 | 9.1 TS1M3 | ||||
| HP-UX IPF | 4.4 | 9.1 TS1M3 | ||||
| 64-bit Enabled HP-UX | 4.4 | 9.1 TS1M3 | ||||
| 64-bit Enabled AIX | 4.4 | 9.1 TS1M3 | ||||