Upgrade to V2R6

Tools

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
N/A

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.

Re: Upgrade to V2R6

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