Post Verification things after migrating to 8.5

[karthi_gana]

All,

What are all the ethings we need to verify once we migrated all our jobs from 8.1 to 8.5 version?

We are going to migrate all our jobs to 8.5 this sunday. It would be great if anybody provide me the post verification steps.

I need the verification steps

a) From a Developer perspective

b) From an ADMIN perspective

[karthi_gana]

any inputs?

[Ravi.K]

Do a run in 8.5 and 8.1 then compare the results using any comparision utility for accuracy.

[ray.wurlod]

any inputs?

Why are you so impatient, particularly on weekends? Get a life.
People post as and when they can on DSXchange, and are under no compulsion to do so. It's an all volunteer site.

[PaulVL]

Check you DB2 stages. Patch up the environment before the users hop in. you may find your oddities during the recompile phase.

[vmcburney]

What you should have done is gone to 8.7 instead of 8.5, used the IBM Concierge service to help with the upgrade, got a copy of the Migration tool that helps check job status and row counts across all jobs prior to and after the upgrade.

Since you haven't planned ahead you need to do treat this as a straight regression test, you need uniform runs across the 8.1 and 8.5 environments. This may mean duplicating a database target schema so you can compare 8.1 loaded tables to 8.5 loaded tables. Run row count comparisons between the two databases.