Windows Vs UNIX

elavenil · Post by **elavenil** » Tue Nov 21, 2006 7:39 am

We are in the process of starting the DW project for one of the bank. DataStage EE licence has been purchased and we are planning to use Windows OS for the development and AIX for production. I would llike to have the following info when the jobs are migrated to prod from devt environment.

1. Parallell processing capablity

2. Node configuration

3. Difficulties in Migration

Thanks in advance.

Regards
Elavenil

DSguru2B · Post by **DSguru2B** » Tue Nov 21, 2006 7:50 am

Wow, did you get your answer already.
Stick to one platform throughout. Either windows or unix. Search this forum for which one to use and which one not to.
Parallel process and Node configuration wont be a challenge. But cant say about migration. Plus if a single platform is adhered to, it becomes easy to script and code when necessary. What if you want to script a shell, and want to test it along with your job, how are you going to do that.

kcbland · Post by **kcbland** » Tue Nov 21, 2006 8:50 am

You're in for difficult times. You'll have to avoid any Windoze functionality when developing, therefore, you'll have to parameterize all directory paths including the slashes so that you can correctly move to the unix environment. You'll also have to parameterize all calls to operating system commands (DSExecute, etc). so that the correct call is made for the environment.

You really should be on one consistent platform.

DSguru2B · Post by **DSguru2B** » Tue Nov 21, 2006 9:01 am

kcbland wrote:You're in for difficult times.

You can say that again, and louder

ray.wurlod · Post by **ray.wurlod** » Tue Nov 21, 2006 12:17 pm

Parameters, my friends, and more parameters. Don't do ANYTHING platform-specific.

The migration itself is quite straightforward; it is exactly the same technique you would use on homogenous platforms.

You WILL need to recompile everything on the AIX machine, since it will use a different C++ compiler, and you will need to configure data sources on both machines, but possibly using different methods. For example ODBC on UNIX is configured by editing the .odbc.ini file.

Dont forget, too, that security is done differently.

Oh, yeah, the bugs are different too.

kduke · Post by **kduke** » Tue Nov 21, 2006 8:58 pm

There is no way I would do this. I would buy a small AIX box before I would develop on Windows and implement on UNIX. I would do LINUX before Windows. I think this is a very bad idea. I think the UNIX versions are all better than Windows anyway.

This is just my opinion. I hope it works for you.

Nageshsunkoji · Post by **Nageshsunkoji** » Wed Nov 22, 2006 6:08 am

Hi Elavenil,

After all these posts and from my experiecnce, it is always better to choose UNIX environment rather than Windows. It will be very helpful in the sense of security and maintaince.

aakashahuja · Post by **aakashahuja** » Wed Nov 22, 2006 6:52 am

I would vote for UNIX too.

kduke · Post by **kduke** » Wed Nov 22, 2006 7:28 am

I do prefer UNIX but that was not my point. Developing in one OS and implementing in another is bad even if it is 2 versions of UNIX. It is worse when it is Windows and UNIX. Just like Ray says the bug lists are different. Something may work fine in Windows and fail in production.

You have made your implementation very difficult.