Problem Note 39713: Required SAS® Scalable Performance Data Server 4.52 hot fix removes JOIN optimization change
 |  |  |  |  |
SAS® Scalable Performance Data Server 4.52 included an optimization change that addressed a STAR-JOIN WHERE-clause restriction. This change may cause additional problems that could result in a data integrity problem if your SQL JOINs contain post-WHERE clause statements.
To determine which version of SAS Scalable Performance Data Server you are running, follow the instructions in SAS KB0036131.
You should see a separate entry for the Scalable Performance Data Client, for the Server, and for the SMC plug-in.
If you are running SAS Scalable Performance Data Server 4.52, this hot fix is required.
Click 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 Server 2003 Datacenter Edition | 4.52 | 4.52 HF3 | 9.2 TS2M3 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.52 | 4.52 HF3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.52 | 4.52 HF3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 4.52 | 4.52 HF3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 4.52 | 4.52 HF3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 4.52 | 4.52 HF3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| 64-bit Enabled HP-UX | 4.52 | 4.52 HF3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 4.52 | 4.52 HF3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| HP-UX IPF | 4.52 | 4.52 HF3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Linux for x64 | 4.52 | 4.52 HF3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Linux on Itanium | 4.52 | 4.52 HF3 | 9.2 TS2M3 | 9.2 TS2M3 | ||
| Solaris for x64 | 4.52 | 4.52 HF3 | 9.2 TS2M3 | 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#39713A fix for this issue for SPD Server 4.4 is available at:
http://www.sas.com/techsup/download/hotfix/spds44.html#039713| Type: | Problem Note |
| Priority: | alert |
| Topic: | System Administration ==> Servers ==> SPDS |
| Date Modified: | 2010-11-16 11:24:31 |
| Date Created: | 2010-05-20 16:43:09 |