IBM have released a tool that makes product upgrades and environment management and job deployment and regression testing easier.
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 PDF doc 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.
=========================================================================================
Migrating to InfoSphere Information Server, Version 8.5 and Version 8.7
Technote (troubleshooting)
Problem(Abstract):
IBM offers a Concierge Program for free to provide guidance on the best approach to migrate to Information Server, Version 8.5 or Version 8.7. Hundreds of customers have taken advantage of the program. InfoSphere Information Server, Version 8.5 and Version 8.7 does not support upgrade in place. There are multiple ways to migrate to Information Server, Version 8.5 or Version 8.7 depending on the version of DataStage or Information Server you are migrating from, the Information Server products installed, and other factors. The Concierge Program is offered to all customers, but it is particularly important for customers using the InfoSphere Foundation Tools (Business Glossary, Metadata Workbench, FastTrack, Information Analyzer) to contact the Concierge Program for guidance and the recommended tools for migration.
In order for IBM to assist you, please send an email message to isconcierge@us.ibm.com. If you are a customer in Japan, please send an email message to InfoSphr@jp.ibm.com. You will be contacted with information and assistance to complete your migration.
Resolving the problem:
In your email message, please provide the following information:
Your name
Company name and address
Contact phone number
Your email address
Name of your IBM Account Representative, if known
Ref: http://www-01.ibm.com/support/docview.wss?uid=swg21445403
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 PDF doc 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.
=========================================================================================
Migrating to InfoSphere Information Server, Version 8.5 and Version 8.7
Technote (troubleshooting)
Problem(Abstract):
IBM offers a Concierge Program for free to provide guidance on the best approach to migrate to Information Server, Version 8.5 or Version 8.7. Hundreds of customers have taken advantage of the program. InfoSphere Information Server, Version 8.5 and Version 8.7 does not support upgrade in place. There are multiple ways to migrate to Information Server, Version 8.5 or Version 8.7 depending on the version of DataStage or Information Server you are migrating from, the Information Server products installed, and other factors. The Concierge Program is offered to all customers, but it is particularly important for customers using the InfoSphere Foundation Tools (Business Glossary, Metadata Workbench, FastTrack, Information Analyzer) to contact the Concierge Program for guidance and the recommended tools for migration.
In order for IBM to assist you, please send an email message to isconcierge@us.ibm.com. If you are a customer in Japan, please send an email message to InfoSphr@jp.ibm.com. You will be contacted with information and assistance to complete your migration.
Resolving the problem:
In your email message, please provide the following information:
Your name
Company name and address
Contact phone number
Your email address
Name of your IBM Account Representative, if known
Ref: http://www-01.ibm.com/support/docview.wss?uid=swg21445403
this is very usefull.i like your idea..even i want to implement it.can you help me out on this?
ReplyDeleteThanks for your feedback.
DeleteI have updated the article with more information on the same.
Please check the Ref Link attached to the article.
Keep watching this blog for more on Datastage and related topics.
TheAzure Migrate serviceallows you to quickly assess the suitability of a set of virtual machines (VMs) in Azure for migration to Azure, even if you do not have physical access to them. It can also be used to assess the suitability of on-premises VMs before migrating them to Azure.
ReplyDelete