Problem Note 30504: Materialized views are not rebuilt after adding a new cluster member
With SAS SPD Server 4.4 TSM1, if you add a new cluster member that has a
Materialized view, the Materialized view is not rebuilt.
This problem is fixed in SAS SPD Server 4.4 TSM3, which can be obtained
with the latest SPD Server hot fix.
Operating System and Release Information
| SPDS | Scalable Performance Data Server | 64-bit Enabled Solaris | 4.4 | 4.4 | | 3.0 TS M0 |
| 64-bit Enabled HP-UX | 4.4 | 4.4 | | 3.0 TS M0 |
| Solaris for x64 | 4.4 | 4.4 | | 3.0 TS M0 |
| Tru64 UNIX | 4.4 | 4.4 | | 3.0 TS M0 |
| 64-bit Enabled AIX | 4.4 | 4.4 | | 3.0 TS M0 |
| HP-UX IPF | 4.4 | 4.4 | | 3.0 TS M0 |
| Windows | 4.4 | 4.4 | | 3.0 TS M0 |
*
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.
This code will reproduce the error:
libname tmp sasspds "tmp" server=localhost.5400 user='anonymous' IP=YES;
data tmp.a;
a="a";key=1;
run;
data tmp.b;
b="b";key=1;
run;
proc sql _method;
create table work.joined as
select a.a, b.b, . as c
from tmp.a, tmp.b
where a.key = b.key;
quit;
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2007-11-27 17:45:05 |
| Date Created: | 2007-11-08 12:47:10 |
