Track 2: DB2 10 for z/OS: Performance and Optimization Best Practices
Developed for: DB2 DBAs, database architects and managers
|8:30 a.m.||Introduction and welcome|
|8:40 a.m.||DB2 10 for z/OS: Performance best practices|
|9:50 a.m.||DB2 for z/OS migration: Query performance considerations|
|11:00 a.m.||DB2 design for high availability and scalability|
|1:00 p.m.||Stored procedure monitoring and analysis|
|2:10 p.m.||Why IBM zEnterprise analytics, why now?|
|3:20 p.m.||The benefits of zEnterprise analytics: client use cases and performance results|
DB2 10 for z/OS has numerous new functions and performance features that you can take advantage of – both “out-of-the-box and some that require user actions. This session focuses on new functions that require user actions to implement, such as INCLUDE index, inline-LOB, HASH access to data, Dynamic Statement Caching, UTS enhancements, and many more. We’ll describe the expected benefit from these features, including core considerations and best practices to get the most out of DB2 10 performance functions. The session includes various measurements conducted at IBM’s Silicon Valley Labs, plus feedback from customer experiences.
The IBM DB2 for z/OS Optimizer has evolved with each new release, and for static SQL, REBIND is recommended to take advantage of new optimizations. But how do clients minimize their 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 in DB2 10. Can I model the potential impact before I get to production? What about data sharing coexistence? The questions are endless, and this presentation will attempt to help. We’ll outline how to best navigate, and how to exploit, the RUNSTATS enhancements so you can make the most of plan management and proactive access path analysis – whether you are migrating from version 8 to 9, version 8 to 10 or version 9 to 10.
Are you overwhelmed by the growing amount of data in your environment? Are you maximizing application availability? As the number of tables with billions of rows continues to grow, so do the management challenges. In this session, we will discuss the challenges and solutions for optimum availability and performance, with techniques to efficiently and effectively manage very large amounts of data.
Monitoring and tuning stored procedure workloads have become more robust with new DB2 engine enhancements and IBM Tivoli® OMEGAMON XE Performance Expert (OMPE) for DB2 for z/OS Extended Insight functionality. This session will cover end-to-end stored procedure analysis and demonstrate new OMPE Extended Insight for stored procedures. Statement-level performance analysis will be covered for both stored procedure and non-nested applications. With a core understanding of DB2 engine-generated metrics and OMPE exploitation, you can enable optimal system tuning.
In this session, we will discuss the business critical requirements for analytics that organizations need to support in order to more effectively use their information to gain advantage over their competition. We will compare traditional analytic approaches with the advantages of a zEnterprise hybrid solution using DB2 for z/OS. We’ll offer a high level view of the end-to-end zEnterprise analytics solution from data warehousing to business intelligence to predictive analytics. You will gain a stronger understanding of how zEnterprise can deliver unprecedented mixed workload flexibility and virtualization while providing the most options for cost-effective standardization and consolidation.
Learn about case studies and performance testing results based on customer implementation and internal testing. These will demonstrate the technical and business benefits customers are achieving when integrating and optimizing DB2 Analytics Accelerator, Cognos BI and SPSS predictive analytics with DB2 for z/OS data. You will learn how the latest technologies can enable better reporting with improvements of up to 2000 times in query response rate; reduce host disk space for historical data by more than 95%; score in real time, the 3,000 to 5,000 transactions per second normally associated with a DB2 for z/OS application, without impacting SLA; and run business analytics at more than 90% capacity while supporting peak business user demands.