DB2 for z/OS migration - Query Performance Considerations
Project and Program:
Information Management,
Database
Tags:
Proceedings ,
2013 ,
SHARE in San Francisco 2013
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? 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?
This presentation outlines how best to navigate and exploit these 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. Thomas A. Beavin ; IBM Corporation
Back to Proceedings File Library