Upgrade to V2R6

Tools
Enthusiast

Upgrade to V2R6

Hello fellow forum members, we at Bell Canada will be getting an upgrade from V2R5 to V2R6 in August of this year. Does anyone out there have any test plans available of what we should verify before and after the upgrade?

What I was thinking:

•Test all the join possibilities (inner, outer, union etc)
•Contact 5 supper users of EDW and request 2 scripts that they execute. test before and after effects
•Test before and after Collect stats
•Test random stored procedures for all key Bell applications
2 REPLIES
Enthusiast

Re: Upgrade to V2R6

If you have implemented PPI, I would test any queries against those tables. Also, save your before and after explain plans...that could be helpful if issues arise.
Enthusiast

Re: Upgrade to V2R6

thanks, we have PPI and will be keeping the before and after explains