DataStage Project Migration from HP-Unix to SUSE Linux/AIX

harshkohli · Post by **harshkohli** » Wed Aug 22, 2012 1:12 pm

We are currently running DataStage 7.5.1 on HP-Unix. Our company is planning to migrate from HP Unix to SUSE Linux and want to use another AIX server for DataStage jobs where DataStage is already installed. All our data/scripts etc. will be on SUSE Linux and for DatsStage jobs we want to utilize AIX server (as DataStage is already installed). Can anyone suggest what is easiest way of achieving this? We have approx. 200 DataStage jobs which are currently running thru Unix scripts and scheduled using CA-Unicentre. In the new environment we will be using Autosys as the scheduling tool. Any help on this will be greatly appreciated. I am looking for a solution where minimal effort is required for changing scripts/jobs etc.

Thanks

ArndW · Post by **ArndW** » Thu Aug 23, 2012 1:06 am

Most jobs will seamlessly re-compile and run identically on another OS, and going from one unix variant to another is less problematic than between Windows and UNIX.

There is no magic method to convert scripts calling CA-Unicenter to automagically use Autsys if they contain scheduler-specific calls and codes.

What sort of solution are you looking for assistance with?

harshkohli · Post by **harshkohli** » Thu Aug 23, 2012 11:27 am

My main concern is 2 different boxes with different operating systems in our new environment : SUSE Linux for Data/Scripts etc. and AIX for DataStage. So my questions is:
1. We can export our DataStage projects from existing HP Unix environment and then import them to AIX environment and recompile. But since our scripts/data will be on SUSE Linux, how and where our jobs will run. For example, if one of our process has 10 jobs (pl/sql, ftp etc.) and only one of them is DataStage job then 9 jobs need to run on SUSE Linux and 1 job need to run on AIX. So how we are going to accomplish this?

Thanks

chulett · Post by **chulett** » Thu Aug 23, 2012 12:03 pm

Your jobs run on the ETL Server, period... so AIX. Your scripts really should be moved to the ETL server as well if the jobs run them or they run your jobs. Your "data" can be anywhere, depending on exactly what it is you mean by data. Please clarify.

harshkohli · Post by **harshkohli** » Thu Aug 23, 2012 1:00 pm

By data I mean the input files. We will get the input files on SUSE Linux server and also we will be running some pl/sql or sql*loader jobs on SUSE Linux server. Some of our processes also use name and address cleansing software (Trillium) which will also be running on SUSE Linux. Since we don't have DataStage installed on the SUSE Linux server, we have to use AIX server for DataStage jobs. Do we need to ftp input/output files between SUSE Linux and AIX servers?