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, IBM
During 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 #2 Job is giving you the documentation to prove it!