Why do we need to Export and Import DataStage jobs
After developing the jobs, we need to migrate that job to QA or Production server. In order to do this, we need to export our jobs and import them into QA or Production server.
However, we may have some other processes before importing the jobs into QA/Production servers like uploading .dsx file into version control or migration tools like StarTeam or IBM RTC tools..etc. I had experience with these tools and you may have used different tool or some people don’t use any tools to store the .dsx files at all.
Procedure to Export DataStage Jobs:
Give the file name and path (where do you want to store the dsx file) in ‘Export to file’ box.
Click on ‘Export’.
You can see a file name with the given name and with extension as ‘.dsx’.
.dsx file name can be anything, need not be same as exported job name.
Here I showed only exporting single job, however you can export multiple jobs at once by selecting all the jobs.Other way to export the jobs is from the ‘Export’ menu.
Procedure to Import DataStage jobs:
You need to very careful while importing the jobs. Because it replaces the existing job which has the same name, once it is replaced it can not be rolled back. So it is good to take backup of existing job before importing the jobs.
Go to “Import” in the menu, Select “DataStage Components…”