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

A fix for this issue for Scalable Performance Data Server 4.52 is available at:

A fix for this issue for SPD Server 4.4 is available at: