The Db2Night Show™ Sponsored by DBI Software

Educate | Inform | Entertain

The Db2Night Show has the simple mission of building a fun, interactive community around Db2. Each episode will include fun stuff, information, tips, and special guests who are industry experts.
SEASON #14 : FOURTEEN YEARS of FREE Db2 Education!

Unless otherwise noted, all shows start at 11 am Eastern time. Adjust accordingly for Daylight Savings and International locations.

The DB2Night Show #28: DB2 LUW Range Partition Tables, Mike Winer, IBM STSM

Posted on 9/11/2010

DB2 LUW Range Partitioning Tables - The Important Stuff

Emphasis on DB2 9.7 Updates

In episode #28, special guest Mike Winer, IBM STSM & DB2 Kernel Architect, shared with us the latest news and enhancements for Range Partitioned Tables in DB2 9.7. Mike specifically discussed Partitioned Indexes and their many benefits, impacts on DB2 logging, high availability during DETACH, and REORG implications and improvements. Watch this replay and see what you missed, or watch it again for review...


To download a recorded replay of Episode #28, right click on the link below and choose "Save As... "
Episode 28, 2010 September 10, DB2 LUW Range Partitioned Tables - The Important Stuff - with Mike Winer, IBM STSM & DB2 Kernel Architect

Mike offered some outstanding slides and reference material during his talk. To protect the intellectual property of our guests, The DB2Night Show ordinarily does not share guest slide decks. However, as an exception to the rule, Mike has kindly given permission to make excerpts of his material available via PDF: CLICK HERE for PDF (5 reference slides).Be sure to watch the entire show replay to benefit fully from Mike's expertise on this high performance topic.

Join The DB2Night Show™ LinkedIn Group

The DB2Night Show™ now has a LinkedIn Group. The group is an open group. Join to receive LinkedIn group updates including future shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group!

Our Shameless Marketing Moment

During today's quick commercial break, DBI briefly demonstrated the advanced graphical trending capabilities of Brother-Panther® for DB2 LUW.

We looked at a stock price chart and examined the important value of having events plotted on the chart. We compared this chart to Brother-Panther's trend charting capabilities. We think you'll agree that a chart that plots changes and events on the chart is much more helpful to understanding the chart movements. If you're in the market for DB2 LUW tools, don't settle for inferior performance trend charts that don't tell you about important changes and when they occurred.

DBI's Brother-Panther® for DB2 LUW makes it easy to analyze SQL workloads for any period of time and discover real root cause problematic SQL like no other tools can (thanks to Patented technology).

DBI's comprehensive performance and configuration repository with the industry's best trend graphs enable you to monitor and manage your databases with confidence, improve stability, and achieve scalability with existing hardware.

Our #1 Job is helping you look great!
Our #2 Job is giving you the documentation to prove it!

Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs.