We need to install datastage version 7.1 Enterprise edition on a Sun Solaris Unix box. Can anybody throw light on the following queries:
Whether machine with SMP architecture is better or MPP architecture is better for EE.
We want to use extensively the parallel extender facility available with EE.
Thanks
Mukund
Enterprise Edition OS requirement
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 103
- Joined: Tue Oct 14, 2003 4:07 am
SMP = Single big box with many CPUs, all running under one OS.
MPP = Many boxes with few/many CPUs, all networked together.
* * *
Both formats are well supported by DataStage Enterprise Edition. Each have their own advantages and disadvantages. Grid computing is a MPP concept that are being advocated by Oracle (despite not working TOO well in that avenue -- it's all marketing). It is also something that can be easily done with Orchestrate, but at a certain point, the network and the engine overheads will kill your performance, no matter how well distributed your job is designed.
It all is a factor of what your company need to have done, and what your company are willing to invest on.
I personally am very familiar with SMP, with only topical knowledge of MPP systems. Both works pretty well, with SMP providing the best performance of the two equally-numbered CPU systems, especially if you optimize your disk array for performance.
MPP = Many boxes with few/many CPUs, all networked together.
* * *
Both formats are well supported by DataStage Enterprise Edition. Each have their own advantages and disadvantages. Grid computing is a MPP concept that are being advocated by Oracle (despite not working TOO well in that avenue -- it's all marketing). It is also something that can be easily done with Orchestrate, but at a certain point, the network and the engine overheads will kill your performance, no matter how well distributed your job is designed.
It all is a factor of what your company need to have done, and what your company are willing to invest on.
I personally am very familiar with SMP, with only topical knowledge of MPP systems. Both works pretty well, with SMP providing the best performance of the two equally-numbered CPU systems, especially if you optimize your disk array for performance.