DB2 for z/OS Migration - Query Performance Considerations
Speaker:Terry Purcell, Senior Technical Staff Member, DB2 for z/OS Optimizer Development, IBM Software Group
Replay: Available for your convenience, register now.
Developed for: IT and enterprise architects and managers; database administrators and managers; system programmers; and, 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 then in DB2 10. Can you model the potential impact before you get to production? What about data sharing co-existence?
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, from V8 to DB2 10 or DB2 9 to DB2 10, you’ll come away with practical tips for a more effective migration that makes full use of incremental query optimization enhancements.
Join us after the webcast for a live question-and-answer session. The webcast will also be available for replay after the event.