This is more than a Migration Assistant, it is useful for migrating between DataStage versions but it is also useful for migrating DataStage jobs from a development environment to testing and production. It is useful for managing duplicate versions of jobs, executing test plans or job documentation.
The DataStage Migration Assistant can be downloaded here and according to the support website:
The Job Migration Test Assistant tool is a web-based application which assists in migration of DataStage projects from previous releases into the 8.5 release. The Job Migration Test Assistant can compare the status of DataStage jobs or sequences between the older version and the newer version, and perform difference analysis including job level or table schema level checks. Reports can be genrated based on anomalies in the data between the versions.It is downloaded through the IBM Fix Central website which means anyone can access it. There is a catch – the product requires a DB2 repository and it comes with a JMTA_DDL_DB2.sql script. Information Server can store its repository on DB2, SQL Server or Oracle so there will be some sites out there without DB2. You can use the free express version of DB2 or the version that comes bundled with Information Server.
It comes with a couple prerequisites – two interim fixes for Information Server 8.5.
Migration Assistant for Upgrades
Here is a screenshot of the DataStage job overview showing jobs in the new environment of various statuses – Failed, Not Completed, Compiled, Ran Successfully and Ran with Warnings. It has another graph for the new environment – Missing and New.
Migration Assistant for Environment Management
There is a lot more to the product than just upgrading DataStage. The Migration Assistant can help to migrate between environments on the same version – for example synchronising your development, test and production environments. Finding duplicate jobs between projects and merging them.
There is a tree for comparing objects between environments and comparing DataStage jobs:
Migration Assistant for Testing
The Migration Assistant has some functions to help unit test an environment upgrade. These same test functions can help for any type of DataStage testing – you can keep using the Migration Assistant as part of your standard test plan. You can compare a release of DataStage jobs with the previous release by comparing a UAT test environment to a production environment, or by comparing a test environment to a test baseline environment. With regression testing the baseline you are comparing against needs to be similar to the new set of jobs being tested.
It provides a regression testing check – the ability to find any link in any job that has a row count that is different to the regression test baseline.
Another regression testing feature is the log compare – this will compare all the logs for one environment against the logs in another environment to try and find something that is different in a DataStage job – such as a new warning, or an abort or unusual information messages. There is currently no other feature in any Information Server product that lets you compare DataStage log messages.