Our Finalists and their Topics
- Mary, db2move
- Norberto, db2top
- Ahmad, db2look
- JB, db2dart
- Thiru, db2caem
- Momi, DB2 z/OS report utility
- Bob, db2dart
John presented on using db2look with DB2 z/OS. Unfortunately for John, he didn't capture enough votes to continue and our judges did not save him.
Raja had planned on talking about db2advis but was absent from today's show. He is disqualified from continuing.
Congratulations!Congratulations to Meir Sebbag! Meir voted in the 4 March 2011 DB2's GOT TALENT Finals Round 1 and was randomly selected (live on the air! ) to win a $25 Amazon.com Gift Certificate! Watching the Replay and Voting can be REWARDING!
Watch the ReplayTo download a recorded replay of Episode #45, right click on the link below and choose "Save As..."
Episode 45, 11 March 2011, DB2's GOT TALENT Finals Round #2.
Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the M4V ( MP4 ) format!
Vote for your favorite finalists!If you were in our studio audience, or if you downloaded and watched the replay, PLEASE VOTE for your favorite Contestants here: https://www.surveymonkey.com/s/DB2TalentFinals2
We will randomly select a voter to win a $25 Amazon.com electronic gift certificate. Limit one vote per computer. The polls close at 3pm Central on 17 March 2011. The Top 5 Finalists that receive the most votes will compete again on 18 March 2011.
Thank you to all of our finalists! We appreciate your willingness to share your DB2 knowledge with the DB2 community. Be sure to spread the word about this replay, The DB2Night Show, and make sure your friends and business contacts vote!
Join The DB2Night Show™ LinkedIn GroupThe DB2Night Show™ now has a LinkedIn Group. The group is open to any LinkedIn member. 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!
DBI's Shameless Marketing Moment
During today's quick commercial break, DBI demonstrated best practices for using the db2advis command with Brother-Panther®. We analyzed the SQL workload for the entire month of February 2011, then passed the four most costly SQL statements to db2advis as a workload. db2advis, the IBM DB2 Design Advisor, works BEST when a workload of multiple SQL statements is passed into it. In the demonstration, the db2advis command gave advice for reducing the workload cost by over 99%! As Finalist Norberto pointed out, the db2top command is a useful tool for analyzing real-time performance - but DBI's Brother-Panther allows you to analyze SQL workloads for any timeframe of interest!
Have you read these DB2 LUW Performance blogs? You should!
- DB2 LUW Performance: Following my own Advice and Thankful
- DB2 LUW Performance: Are you REALLY ready for Production?
- DB2 LUW Performance Analysis and Tuning Workshop at IDUG NA, Anaheim, CA - Details and Preparation Instructions
- DB2 LUW Performance Analysis and Tuning Workshop at The DB2 Symposium, Dallas, Texas - Details and Preparation Instructions
Please look for DBI's new ad in IBM Data Management Magazine. Our ad is on the inside back cover. Look for instructions on how you can get a new white paper "IBM DB2 LUW Critical Performance Measurements" which provides SQL commands and actionable tuning advice!
Our #2 Job is giving you the documentation to prove it!