Usage Note 20350: CLUSTER CREATE with unique indexes is slow
 |  |  |  |  |
When creating a cluster that has unique indexes defined in the member tables, the CLUSTER CREATE command can take a long time to complete because the unique indexes must be validated.
Starting with SPDS Server 4.4 TSM2, a change has been made that should improve performance.
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 | Solaris | 4.4 | 9.1 TS1M3 | ||
| Microsoft Windows NT Workstation | 4.4 | 9.1 TS1M3 | ||||
| Solaris for x64 | 4.4 | 9.1 TS1M3 | ||||
| 64-bit Enabled Solaris | 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 AIX | 4.4 | 9.1 TS1M3 | ||||
| 64-bit Enabled HP-UX | 4.4 | 9.1 TS1M3 | ||||
| AIX | 4.4 | 9.1 TS1M3 | ||||
A fix for this issue for SPD Server 4.4 is available at:
http://www.sas.com/techsup/download/hotfix/spds44.html#020350| Type: | Usage Note |
| Priority: | |
| Topic: | System Administration ==> Servers ==> SPDS |
| Date Modified: | 2007-06-21 15:34:46 |
| Date Created: | 2007-06-06 16:08:40 |