There are only a few shows remaining in the rest of this season’s collection of DB2Night Show episodes. Mark your calendar for these up coming events and take a look at previous shows that you may have missed. The education opportunity to you is huge.
#53 - Don't flip out! How to stop your query access plans from flopping! (aka DB2 HINTS!)
Did you know you can "force" the DB2 LUW optimizer to choose a specific access strategy of your choosing? The secret is out...
Special guest John Hornibrook from the IBM Toronto Lab presented in Episode #52 where he talked about best practices for query tuning. In this show he’ll teach you how to exploit DB2 LUW Optimizer "hints", or, maybe more properly, how to tell the DB2 optimizer how to execute your queries.
Note that this show is scheduled for 90 minutes so that John can share all of his incredible presentation with you and have time for questions.
#z04 - What's new from the optimizer in DB2 10 for z/OS?
Terry Purcell, IBM SVL, SQL & Optimization
Monday May 23: 11am ET, 60 minutes
DB2 10 for z/OS is no exception to the goal of delivering incremental query optimization enhancements to the world’s most respected cost based optimizer. With skip-release migration supported, it is expected that many more customers may adopt DB2 10 in the coming year - so understanding the performance enhancements can be critical for those customers. Terry Purcell will share the insight uncovered from beta customer and early adopters, and provide the motivation for each enhancement including:
- “Safe” query optimization
- Improvements to complex OR and IN list processing
- RUNSTATS management and performance improvements
- And more!
#54 - DB2 9 LUW Core Engine Data Movement Utilities Overview with Oracle database comparisons
Burt Vialpando, Executive IT Specialist, IBMFriday June 3 - 11am ET, 60 minutes
Special guest Burt Vialpando from IBM presented in Episode #22 which was the 15th most downloaded show in 2010. He talked about Comparing DB2 LUW and Oracle, Architectures and Administration. In this episode, Burt will give you an overview of each of the DB2 core engine data movement utilities: Load, Import, Export (with db2look), db2move, ADMIN_COPY_SCHEMA, ADMIN_MOVE_TABLE, db2relocatedb, restore from backup and split mirror. These will be compared to each other so that you can get a good idea of when to use and not to use each of these. To help round out the discussion, a comparison to the Oracle database core engine data movement utilities will be made to these DB2 utilities.
#z05 - B2 V10 Migration Planning and Early User Experiences
John Campbell, IBM Distinguished EngineerMonday June 6: 11am ET, 60 minutes
In this episode, host Klaas Brant and guest John Campbell will introduce and discuss early experiences and lessons to be learned with DB2 10 for z/OS. It will provide quick hints on preparing for and executing the migration, performance expectations and opportunities, virtual storage constraint relief, some instrumentation changes, use of 1MB real storage frame size, use of hash access, value of rebind, etc. Key topics covered will include:
- Lessons learned
- Surprises and pitfalls
- Provide hints and tips
- Address some myths
- Provide additional planning information
- Provide usage guidelines
- Provide positioning on new enhancements
#55 - DB2 LUW Multi-Temperature Data Management
Kate Kurtz and IBM Smart Analytics Best Practices Team membersFriday June 17: 11am EDT, 60 minutes
Did you know that data has temperatures? Can data run a fever? What happens if your data catches a cold? Or rather, turns cold from hot? What can and should you do? What techniques are available for optimizing performance in databases where some data is more popular (hot) than other data?
In this episode of The DB2Night Show, various IBM experts will help us answer these challenging questions! Kate Kurtz along with team members from the IBM Smart Analytics Systems Best Practices team will share with us their expertise!
#56 Season #2 Finale! - Data Warehouse Performance Tuning!
Kate Kurtz and IBM Smart Analytics Best Practices Team membersFriday June 24: 11am ET, 60 minutes
Kate Kurtz and her IBM Smart Analytics Systems Best Practices team return again to share with us IBM recommendations and suggested best practices for optimizing performance of Data Warehouse Databases. If you're trying to make DPF or multi-partition databases run queries as fast as possible, then you should sign up for this show!
Hard to believe another season is over already! Thanks Scott Hayes and Klaas Brant for Entertaining, Informing, and best of all, EDUCATING us! We look forward to see what amazing ideas you come up with next season.