Please take a moment to review our site. Our next meeting will be held Thursday, March 5, 2015 at the IBM Chicago Technical Exploration Center (TEC). The IBM TEC is located in the Hyatt Building on 71 South Wacker in Chicago.
A quick overview of the most interesting new features in DB2 11, as well as an update on recent enhancements that support Hybrid Cloud, Dev ops, and developer productivity.
10:30am - 10:45am
10:45am - 12:00pm
The Present and Future of Large Memory in IBM DB2 Jeff Josten, IBM
With the flattening of Moore's Law, processor speeds will not serve as a significant source of performance improvement in coming years. Database systems are looking to use large real memory to avoid I/O latency and processor overhead. IBM DB2 11 and future releases of DB2 are looking to use large real memories and IBM z/OS features, such as large page sizes and flash memory. This session highlights the potential performance benefits of large real memories and how the DB2 development team plans to exploit such opportunities.
12:00pm - 01:00pm
Lunch - free, onsite
01:00pm - 02:15pm
Safeguarding your SQL Performance Damen Anderson, Anixter
Good SQL performance is something developers and DBAs alike aspire to. SQL that performed well yesterday may have degraded seemingly overnight. This presentation will provide suggestions on where and how to look for clues about changes in performance for both dynamic and static SQL. The particulars of using plan management to revert to the prior or original copy of a package will be covered. Additionally, information will be presented on the identification of SQL "tricks" that may cause a problem as opposed to "tricks" that should not cause a problem. Finally, tips on how to code or recode troublesome queries will be covered.
02:15am - 03:30pm
DB2 for z/OS - SQL for the 21st Century: Overlooked Enhancements David Simpson, Themis
Are you still coding like it's the 90s? This session will cover some overlooked SQL enhancements in the latest releases of DB2 with a special focus on features that have been most useful in real DB2 environments.