Don’t miss out on our upcoming seminars . There are limited places so register now to avoid disappointment
DB2 for z/OS Seminars
REGISTER NOW
More detail
8:40am – Meeting the business analytics and data warehousing needs of your users
In this session, IBM will share insight on today’s business environment and its impact on an IT organization’s ability to deliver a competitive Business Analytics and Data Warehousing strategy. You will learn how DB2 for z/OS combined with other Business
Analytics offerings from IBM provide the industry’s only end to end solution on a single platform that is capable of scaling to meet the breath of business users needs for complete and accurate business information faster and better with less resource and expense. The
solution offers flexible deployment options including IBM Smart Analytics System 9600 and is designed to meet the business challenges of today and your evolving business needs going forward to help optimize business performance.
9:50am – DB2 for z/OS: Version 10 including migration strategy for DB2 9 or DB2 10
This session will recap the key features of DB2 9 for z/OS, followed by a look at DB2 10, the next release of DB2. If your organization needs to lower operating costs through CPU cycle reductions while still building a strong foundation for SOA and XML initiatives, you’ll learn how much DB2 10 will have to offer. Database administrators will find improved database performance, scalability and availability, while memory management is dramatically reduced, so growth is much simpler. You’ll also have more flexible security to help with regulatory compliance. A wide range of enhancements improve the functionality and performance of ERP applications and data warehousing. Application
developers will learn about the second release of pureXML, which improves the SQL and XML interface to access XML data stored in a native format. We’ll also discuss powerful new SQL enhancements, including improved SQL and data definition compatibility with other DB2 platforms, which makes porting much easier.
11:00am – Gain insight into DB2 9 and DB2 10 for z/OS performance updates and save costs
In this session, we will discuss the latest updates for system and application performance on IBM DB2 9 and DB2 10 for z/OS. Beginning with performance impact and tuning at the system and application level, we’ll have a special focus on topics requested by product representatives and field inquiries. This session will also over DB2 10 for z/OS and its improved performance and scalability – including general CPU usage reduction and scalability, buffer management, and insert and select functionality – in addition to the reduction of virtual storage constraints. Other topics include improvements to DDF, JDBC, SQLPL and line-of-business performance. You’ll also learn how DB2 9 and DB2 10 interact with IBM z10 and z11 processors.
1:00pm – What’s new for SQL optimization in DB2 9 and DB2 10 for z/OS
Reducing the total cost of ownership is everyone’s challenge, and it’s one of the key benefits of query optimization. Since its initial inception in DB2® for z/OS®, the cost-based Optimizer has continually evolved to deliver expert-based query and workload
analysis and many other performance-enhancing functions. Based on the latest use by customers, the Optimizer delivers even more in DB2 10. This session will show you how the Optimizer in DB2 10 for z/OS can help reduce your total cost of ownership. We’ll discuss incremental query optimization enhancements available with the upcoming release of DB2 10 that build on DB2 9 enhancements, such as global query optimization. This session will cover the insight discovered in early usage, provide the reason for each enhancement and highlight the most important enhancements. Topics will include enhanced plan management; “safe” query optimization; improvements to complex OR and IN list processing; and, RUNSTATS management and performance improvements.
2:10pm – Administering and Optimizing Your DB2 9 & 10 for z/OS Environment
The life of a database administrator (DBA) is not easy these days. Database performance issues, worries about data corruption and loss, expanding business requirements, and rising charge-back costs are just a few of the trends that are causing DBA staffs to be stretched to the breaking point. So when do you have time to learn about new features in DB2 10 for z/OS and exploit DB2 9 enhancements? Even if you have decided that there are new DB2 10 features such as temporal data and hash tables that you can’t wait to implement, what’s the best way to manage and monitor them? How do you take advantage of the new security roles and make them work for you? This session takes a deeper look at some of the features in DB2 10 for z/OS and how to effectively manage and monitor them.
3:20pm – How to streamline your DB2 for z/OS utility processing
Most DB2 applications are global non-stop, requiring almost 100% accessibility. Availability demands reduce the amount of time available to perform necessary routine tasks, such as utility maintenance on the underlying data and objects stored in DB2 for z/OS that support critical business applications. In addition, companies are looking for ways to streamline DB2 utility processing to maximize system and personnel resources. How valuable would it be to maximize your use of IBM DB2 Utilities Suite for z/OS for both DB2 9 and DB2 10? What if you could establish DB2 utility practices at a company level and know that they would be monitored and adhered to? Do you want to reduce your batch window during utility sort processing to improve availability and performance? How important would it be to run utilities only on objects when and if it’s necessary? The answer to these questions and more will be revealed in this session.
