DB2 10 for z/OS Migration & query performance considerations
Replay: Available for your convenience, register now.
Developed for: IT and enterprise architects; IT managers; data analysts; database administrators and managers; system programmers; operations managers
Technical level: Intermediate
The IBM® DB2® for z/OS® Optimizer is continually evolving with each release, and for static SQL, REBIND is recommended to take advantage of new optimizations. But how do you minimize your exposure to access path regression for static SQL? What about dynamic SQL? And then there are the RUNSTATS enhancements that came in DB2 9 and more in DB2 10. Can you model the potential impact before you get to production? What about data sharing co-existence? The questions seem endless.
Join us for this complimentary webcast as we outline how best to navigate and exploit the RUNSTATS enhancements, to make the most of Plan Management, and do proactive access path analysis. Whether you are migrating from DB2 V8 to DB2 9, DB2 V8 to DB2 10, or DB2 9 to DB210, this webcast will give you important information to improve your migration.
Don’t miss this unique opportunity to learn from two of IBM’s most esteemed DB2 for z/OS technical experts.
Attendees will receive a complimentary new publication IBM DB2: The Past, Present & Future – 30 Years of Superior Innovation. This special 30th anniversary ebook includes whitepapers from both presenters.
Join us after the webcast for a live question-and-answer session. This webcast will also be available for replay after the event.