Posted on 6/4/2010
In our 20th show, we were joined by special guest Ergin Babani, IBM Developer, Continuing Engineering Team. Ergin shared with us tips and best practices for using DB2 REDISTRIBUTE. During our lively Q&A session, we were joined by Katherine Kurtz, IBM, on the IBM Smart Analytics Systems Best Practices team. Learn more about DB2 REDISTRIBUTE best practices...
To download a recorded replay of Episode #20, right click on the link below and choose "Save As... "
Episode 20, 2010 June 4, DB2 LUW REDISTRIBUTE with Ergin Babani, IBMDuring the Q&A period, Kate Kurtz mentioned a best practices paper on data skew and REDISTRIBUTE. Here is the URL:http://www.ibm.com/developerworks/data/library/techarticle/dm-1005partitioningkeys/ Join The DB2Night Show™ LinkedIn GroupThe 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 MomentProcessing workload should be evenly balanced across your DB2 LUW database partitions. If you have several partitions but one or a few are carrying a lion's share of the processing burden, then you database performance will suffer due to workload imbalance and processing skew. DBI's Brother-Panther® for DB2 LUW makes it easy to detect load imbalance and skew with a single mouse click - see a summary of partition performance and workload percentages in an instant.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. |