|
Special Guests: Ember Crooks, Rosetta, and Fred Sobotka, FRS Consulting
DB2 LUW Potluck - DB2 Experts Review Insights from IBM IOD 201388% of our studio audience learned something! 12% attended for the humor! During this episode of The DB2Night Show™, Ember and Fred shared with us what they learned and observed at IBM IOD 2013. Find HADR tidbits and more, plus some great advice if you are thinking about attending IBM Insights in 2014! Watch and learn... |
A message from our sponsor:
DBI Software
Today's "DBI Commercial" was very educational, so don't fast forward through it! Previously on The DB2Night Show and at IDUG conferences (Orlando, Melbourne, and Barcelona 2013), Scott Hayes has presented on DB2 10.1 and the new Index Jump Scans. During our commercial, we compared the performance of DB2 V9.7 versus DB2 10.1 FP3 in a high volume OLTP e-commerce environment. A number of SQL statements in the 4,600+ statement workload benefited from Index Jump Scans. Pay attention! You'll see reduced Index Logical Read costs, lower CPU, and some faster response times.
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.
Show Host Scott Hayes Commentary
I think this was a fun and informative show. Fred has a great sense of humor and Ember has terrific attention to details. I like having multiple guests. When one has trouble with their internet connection, we switch to the other! I suggest you follow them both on Twitter:
- Ember Crooks: @ember_crooks
- Fred Sobotka: @db2fred
At IDUG Barcelona, during the DB2 Experts panel, someone in the room asked intriguing questions about what tools people used. When asked "Who uses db2pd?" all of the hands went up. When asked "Who uses db2top?" all of the hands went up. When asked "Who uses Data Studio for database administration?" no one raised their hand. With as much as IBM has invested in Data Studio, I thought this was surprising and unexpected, so we asked today's studio audience what tools they use. Here are the results:
"Free" DB2 tools used by the DB2 Community
34% of today's audience indicated using an Advanced Edition of DB2 LUW which includes IBM OPM in the bundle, yet 0% of our audience indicated that they use it! If you want DB2 performance tools that you'll actually use every day, please refer to sponsor message and links above. 
Join The DB2Night Show™ LinkedIn Group
The DB2Night Show™ has a LinkedIn Group. The "closed" 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!
Insider Information
Here's another great reason to join The DB2Night Show LinkedIn Group: SECRET INSIDER INFORMATION. Every once in awhile, we run shows where EVERYONE in our studio audience can be a prize winner! JUST SHOW UP and COLLECT! We only announce these special shows within The DB2Night Show LinkedIn group!Everyone that attended Episode #110 Database Performance Trends and gave us the prize word SLIPPERS won a $10 gift certificate to Amazon.com, Lowes.com, or Starbucks, or we made donations to the American Red Cross or Big Brothers Big Sisters - at the choice of each show attendee! IT PAYS TO LEARN DB2 on The DB2Night Show!
Have you been Naughty or Nice in 2013?
We asked our registrants for this show if they'd been naughty or nice this year...
Congratulations!
Congratulations to Tom Clarke at Wells Fargo in Minneapolis Minnesota! You've won a $25 Amazon.com gift card! Thank you for completing the survey after show #118 on the 17 Laws of VLDB DB2 Databases!To all of our winners - please be patient on these gift cards. We issue them every four to five or so shows because bulk gift card orders save time.
Get the Download Replays
WMV Format - approximately 64MB
To download a recorded replay of Episode #119 in WMV format, right click on
the link below and choose "Save As..."
Episode #119, 8 November 2013,
DB2 LUW Potluck - Insights from IBM IOD 2013 with guests Ember Crooks and Fred Sobotka
MP4 Format - standard resolution - 107MB
Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the MP4 ( M4V ) format!
Did you learn something from this show?
See that "Mail this" link below? Click it and do a friend a favor - share this blog post and show with one of your friends or peers. THANKS!
Share a great show with your friends and followers:
Tweet