Verify Migration of Datastage from Test to Prod
Posted: Thu Jan 24, 2008 8:59 am
Hi
We have migrated datastage jobs from Test to Prod Environments (using Datastage Export and Import). However there is a requirement to verify that all the components have been successfully ported to new environment.
We have tried 2 approaches, but both of them have been denied by the testing group as "not acceptable"
The approaches we tried are
1) Manually Count the number of jobs/ routines/table definitions etc : This approach was marked unacceptable due to high scope for human error
2) Export the Migrated Project as .dsx file. Compare the .dsx file (from which the import happened) and the Exported .dsx file, using file comparison tools
This approach was denied as unacceptable due to differences that surface in the Date and Time values.
Is there a way we can verify whether all the components were successfully migrated ?
are there any known list of exceptions (eg: mismatch in date , time values) that can be used while comparing the dsx files
Please suggest
We have migrated datastage jobs from Test to Prod Environments (using Datastage Export and Import). However there is a requirement to verify that all the components have been successfully ported to new environment.
We have tried 2 approaches, but both of them have been denied by the testing group as "not acceptable"
The approaches we tried are
1) Manually Count the number of jobs/ routines/table definitions etc : This approach was marked unacceptable due to high scope for human error
2) Export the Migrated Project as .dsx file. Compare the .dsx file (from which the import happened) and the Exported .dsx file, using file comparison tools
This approach was denied as unacceptable due to differences that surface in the Date and Time values.
Is there a way we can verify whether all the components were successfully migrated ?
are there any known list of exceptions (eg: mismatch in date , time values) that can be used while comparing the dsx files
Please suggest