Page 1 of 1
Performance differences in Operating Systems
Posted: Tue May 02, 2006 11:53 am
by jshurak
Does anyone have experience in running datastage on different operating systems?
We are currently running datastage in a Windows environment and we are considering running it on a unix environment. Are there any noticable benefits to switching over to a Unix environment?
Posted: Tue May 02, 2006 1:16 pm
by kcbland
Sure, Unix machines scale into monster sizes with hundreds of CPUs and GBs of RAM with lightning fast disk darms.
Posted: Tue May 02, 2006 2:04 pm
by DSguru2B
There is definetly no doubt in switching to unix :D
![Cool 8)](./images/smilies/icon_cool.gif)
Posted: Thu May 04, 2006 7:36 am
by Ultramundane
I would suspect that the windows server version supports bcp for MsSQL. Thus, I would suspect that the windows version would toast Unix when putting data away directly to MsSQL.
If you are heavy MsSQL or only MsSQL I would consider staying on the windows version.
Posted: Thu May 04, 2006 2:45 pm
by ray.wurlod
Apart from that, beware of any hard-coded pathnames. UNIX servers don't understand what to do with drive letters and gets backslashes in pathnames wrong too! There is a UNIX-based ODBC driver for SQL Server, but clearly - as pointed out - that is not as slick as keeping everything in Bill's domain.
Setting up ODBC on UNIX is done the same was as for Windows 3.1 and earlier - editing an odbc.ini file. Anyone remember that?
If you ever decide to go the parallel jobs route, then UNIX is a much more stable platform than Windows. The only parallel-jobs version of DataStage for Windows (7.5x2) is decidedly flaky.