2013 IBM zEnterprise Technology Summit

Gain insight that you can take action on with the latest innovations in mainframe technology

.

Track 2: DB2 10 for z/OS: Performance and Optimization Best Practices

Developed for: DB2 DBAs, database architects and managers

Agenda
Time Session Title
8:30 a.m. Introduction and welcome
8:40 a.m. DB2 10 for z/OS: Performance best practices
9:40 a.m. Break
9:50 a.m. DB2 for z/OS migration: Query performance considerations
10:50 a.m. Break
11:00 a.m. DB2 design for high availability and scalability
12:00 p.m. Lunch
1:00 p.m. Stored procedure monitoring and analysis
2:00 p.m. Break
2:10 p.m. Why IBM zEnterprise analytics, why now?
3:10 p.m. Break
3:20 p.m. The benefits of zEnterprise analytics: client use cases and performance results
4:20 p.m. Close

Abstract

8:40 a.m. - DB2 10 for z/OS: Performance best practices

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.


9:50 a.m. - DB2 for z/OS migration: Query performance considerations

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.


11:00 a.m. - DB2 design for high availability and scalability

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.


1:00 p.m. - Stored procedure monitoring and analysis

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.


2:10 p.m. - Why IBM zEnterprise analytics, why now?

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.


3:20 p.m. - The benefits of zEnterprise analytics: client use cases and performance results

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.


4:20 p.m. - Close




3 of 8 pages | Previous | Next


Registration

Upcoming Events

Twitter updates from IBM System z Events

SystemZEvents