SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 44863: Parallel index creation with SAS® Scalable Performance Data Server® on AIX 6.1 causes performance degradation

DetailsHotfixAboutRate It

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:

  1. Create serial indexes.
    Creation time for serial indexes on AIX 6.1 is similar to creation time for parallel indexes on AIX 5.3.
  2. 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 FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SPDSScalable Performance Data Server64-bit Enabled AIX4.524.52 HF6
* 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.