Problem Note 44863: Parallel index creation with SAS® Scalable Performance Data Server® on AIX 6.1 causes performance degradation
 |  |  |  |  |
When running SAS® Scalable Performance Data Server® on AIX 6.1, you might experience significant performance degradation if you create indexes asynchronously. On AIX 5.3, the same indexes are created more quickly.
There are two workarounds for this problem:
- Create serial indexes.
Creation time for serial indexes on AIX 6.1 is similar to creation time for parallel indexes on AIX 5.3. - Limit the number of indexes created asynchronously.
Do not create more than two or three indexes at a time.
Select the Hot Fix tab in this Note to access the hot fix for this problem.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SPDS | Scalable Performance Data Server | 64-bit Enabled AIX | 4.52 | 4.52 HF6 | ||
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#44863A fix for this issue for SAS Scalable Performance Data Server 4.53 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F61.html#44863| Type: | Problem Note |
| Priority: | medium |
| Topic: | System Administration ==> Servers ==> SPDS |
| Date Modified: | 2012-01-17 11:17:15 |
| Date Created: | 2011-11-11 11:20:31 |