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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | |||
A fix for this issue for Scalable Performance Data Server 4.52 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B57.html#40499A fix for this issue for SPD Server 4.4 is available at:
http://www.sas.com/techsup/download/hotfix/spds44.html#040499| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2010-08-03 18:57:45 |
| Date Created: | 2010-08-02 17:01:58 |