DataStage Migration from Windows Server 2003 to Unix AIX

Bryceson · Post by **Bryceson** » Mon Jun 19, 2006 9:59 am

Folks,

We're currenlty running DataStage 7.5.1A on Windows environment and are moving to Unix AIX. The current environment has 5 projects running in Production. And we have set up (Development, Test and Production).

What are the necessary steps we should keep in mind or need to be aware during the process of Exporting/Importing DataStage Jobs from the old env. to the new env??. Has anybody been through this situation??

Does any one know any document or can explain how to go about?. I need to write up the migration plan from Windows 2003 to AIX that we can follow.

Any thoughts and ideas would be appreciates.

Thanks . . . . Bryceson

DSguru2B · Post by **DSguru2B** » Mon Jun 19, 2006 10:34 am

For a start off on this quickly, these are the things you need to consider for migration. Havent done this before, but will get more inputs for sure:

1. ODBC connections to be added to the odbc.ini and uvodbc.config files in the Ascential folder.

2. The directory structure for the jobs need to be created as per the requirements of the jobs and as required by AIX environment.

3. All the associated parameters for inputs,outputs,etc. need to be set in the parameter.ini file if used.

4. If not scheduling through director, then need to a scheduling tool to perform desired runs. for eg: Crontab, Tivoli,etc.

5. All the Jobs, Routines, Shared Containers and the Table Definitions need to be exported and then import them to Datastage repository when installation on AIX has occured.

6. After installation, Projects need to be created in the AIX environment.

These are what I could quickly collect. Lunch time now.

ArndW · Post by **ArndW** » Mon Jun 19, 2006 10:56 am

In my experience the problematic portion of this cross-platform migration is in finding all the places where paths have been hard-coded in Windows format and need to be changed to UNIX. In addition, if any user-coded functions use OS calls to get information or trigger work these need to be identified and changed as well. Depending upon the size of the application, this can add up to quite a few hours or work!

Bryceson · Post by **Bryceson** » Mon Jun 19, 2006 11:52 am

Thanks DSguru2B & ArndW . .

What about the installation effort of DataStage on AIX environment??. I know in Windows there is NO dsenv file, what are the things we need to watch in files like dsenv etc . . . Anything in particular at this level??.

Again I appreciated for your knowledge!!

Thanks . . . Bryceson

DSguru2B · Post by **DSguru2B** » Mon Jun 19, 2006 1:09 pm

dsenv file basically contains all the enivronment variables that the server will reference during its startup and other programs would reference from time to time, like scripts etc. More info on dsenv can be found in dsbooks under the pdf Install and upgrade guide. It even tells you what variables are to be kept in mind for an AIX platform.

kcbland · Post by **kcbland** » Mon Jun 19, 2006 3:38 pm

You'll have to make sure that your Unix box has all database OCI softwares installed with the correct library versions (ex: Oracle 32bit not 64bit)

You'll also need to make sure that the jobs have all appropriate file types selected. When you designed jobs with Sequential file stages on the Windoze system, they defaulted to DOS line terminators (CR/LF). This means on Unix you'll be reading and writing files with CR/LF, which will cause issues. You'll want to mass change all jobs to write Unix files. Consider text search and replace on the .dsx file and a quick method to mass change all jobs.