SUPPORT / SAMPLES & SAS NOTES
Usage Note 20333: Parallel join may fail for when joining two very large tables
 |  |  |  |  |
When using SPD Server, attempting to use a parallel join to join two very large tables may cause the process to fail with the following error message:
SPDS_ERROR: Inalid value for the -6949672 option.
This error will be followed by parallel join failures messages in the SAS® log.
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 | 4.4 | 9.1 TS1M3 | ||||
| 64-bit Enabled Solaris | 4.4 | 9.1 TS1M3 | ||||
| Solaris for x64 | 4.4 | 9.1 TS1M3 | ||||
| Linux on Itanium | 4.4 | 9.1 TS1M3 | ||||
| HP-UX | 4.4 | 9.1 TS1M3 | ||||
| HP-UX IPF | 4.4 | 9.1 TS1M3 | ||||
| 64-bit Enabled HP-UX | 4.4 | 9.1 TS1M3 | ||||
| Tru64 UNIX | 4.4 | 9.1 TS1M3 | ||||
| 64-bit Enabled AIX | 4.4 | 9.1 TS1M3 | ||||
| AIX | 4.4 | 9.1 TS1M3 | ||||