Problem Note 40499: SAS® Scalable Performance Data Server® queries limited to 4 hash joins
If you are running SAS® Scalable Performance Data Server 4.5 TSM2 or earlier, the maximum number of hash joins for a query is limited to 4. After applying this hot fix, you will be able to increase the number of hash joins with the new SQL option RESET MAXHASHJOIN, using one of the following methods:
To use the new RESET option with explicit SQL:
execute(reset maxhashjoin=<number>) by sasspds;
To use the new RESET option with implict SQL:
%let SPDSSQLR=maxhashjoin=<number>;
To use the new RESET option in the server parm file:
SQLOPTS="reset maxhashjoin=20";
This problem is fixed with SPD Server 4.4 TSM11 and SAS 9.1.3.
Operating System and Release Information
| SPDS | Scalable Performance Data Server | Microsoft Windows Server 2003 Datacenter 64-bit Edition | 4.5_M2 | 4.5_M2 | | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 4.5_M2 | 4.5_M2 | | 9.2 TS2M3 |
| Microsoft® Windows® for x64 | 4.5_M2 | 4.5_M2 | | 9.2 TS2M3 |
| Microsoft Windows 2000 Advanced Server | 4.5_M2 | 4.5_M2 | | 9.2 TS2M3 |
| Microsoft Windows 2000 Datacenter Server | 4.5_M2 | 4.5_M2 | | 9.2 TS2M3 |
| Microsoft Windows 2000 Server | 4.5_M2 | 4.5_M2 | | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.5_M2 | 4.5_M2 | | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.5_M2 | 4.5_M2 | | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Standard Edition | 4.5_M2 | 4.5_M2 | | 9.2 TS2M3 |
| Microsoft Windows XP Professional | 4.5_M2 | 4.5_M2 | | 9.2 TS2M3 |
| 64-bit Enabled AIX | 4.5_M2 | 4.5_M2 | | 9.2 TS2M3 |
| 64-bit Enabled HP-UX | 4.5_M2 | 4.5_M2 | | 9.2 TS2M3 |
| 64-bit Enabled Solaris | 4.5_M2 | 4.5_M2 | | 9.2 TS2M3 |
| HP-UX IPF | 4.5_M2 | 4.5_M2 | | 9.2 TS2M3 |
| Linux | 4.5_M2 | 4.5_M2 | | 9.2 TS2M3 |
| Linux for x64 | 4.5_M2 | 4.5_M2 | | 9.2 TS2M3 |
| Solaris for x64 | 4.5_M2 | 4.5_M2 | | 9.2 TS2M3 |
*
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: | 2010-08-03 18:57:45 |
| Date Created: | 2010-08-02 17:01:58 |
