Performance differences in Operating Systems

jshurak · Post by **jshurak** » Tue May 02, 2006 11:53 am

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?

kcbland · Post by **kcbland** » Tue May 02, 2006 1:16 pm

Sure, Unix machines scale into monster sizes with hundreds of CPUs and GBs of RAM with lightning fast disk darms.

DSguru2B · Post by **DSguru2B** » Tue May 02, 2006 2:04 pm

There is definetly no doubt in switching to unix :D

Ultramundane · Post by **Ultramundane** » Thu May 04, 2006 7:36 am

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.

ray.wurlod · Post by **ray.wurlod** » Thu May 04, 2006 2:45 pm

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.