I was just analysing on a generic basis what OS will be better for processing high volume jobs(> 1 mill rows). Unix or Windows?
I have never worked on Windows before, hence would greatly appreciate if anybody who has worked on Windows can point out the drawbacks on working on a Windows server while processing server jobs with huge vols of data.
Thanks.
DataStage server job performance on Unix Vs Windows
Moderators: chulett, rschirm, roy
DataStage server job performance on Unix Vs Windows
This post is by Durga Prasad
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You're not comparing apples with apples so most comparisons are probably unfair.
The thing I most like about UNIX over Windows is the infrequency with which the machine has to be re-booted - that is, its "up time".
On identical hardware there theoretically should be little difference between Windows and UNIX, since the underlying software is, to all intents and purposes, identical. Parallel jobs may be more costly on Windows because of the extra layer of software (MKS Toolkit) and because of the fact that Windows is a messaging operating system.
The thing I most like about UNIX over Windows is the infrequency with which the machine has to be re-booted - that is, its "up time".
On identical hardware there theoretically should be little difference between Windows and UNIX, since the underlying software is, to all intents and purposes, identical. Parallel jobs may be more costly on Windows because of the extra layer of software (MKS Toolkit) and because of the fact that Windows is a messaging operating system.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
Re: DataStage server job performance on Unix Vs Windows
The Windows version will give you a SQL Enterprise stage which can be used for doing bulk loads to SQL Server. That might be important for doing a lot of SQL Server work.
Maybe what OS the developers are most familiar with could be an issue as well?
Other than that, the Unix version will probably be more stable and faster.
Maybe what OS the developers are most familiar with could be an issue as well?
Other than that, the Unix version will probably be more stable and faster.