Special Guest: Scott Hayes, DBI Software
Sage DB2 LUW Performance Advice
Show Host Scott Hayes Commentary
For many years, I've been writing blogs and teaching at IDUG about DB2 LUW Performance Monitoring and Tuning. You can find links to cost metrics, ratios, rules of thumb, index design topics, and more within the popular blog DB2 LUW Performance Blog - Greatest Hits. While all these metrics are still valid and helpful, it occurred to me that my "secret sauce for success" over the years has been from even more valuable information: WEIGHTS. If you need to make a DB2 database run crazy fast, then you need to take as much weight out of the workload as quickly as possible. If you enjoy this replay and find it helpful, please tell your friends and peers.
Lloyd Grendys at BCBS IL in Chicago IL completed our survey after Episode #141 "DB2 Cancun Shadow Tables with Iqbal Goralwalla" and has won a $25 Amazon.com gift certificate! We'll get this sent out within the next few weeks! THANK YOU FOR COMPLETING OUR POST-SHOW SURVEY!!!
Think About ThisLarry Ellison resigned shortly after IBM released DB2 BLU V10.5 Cancun. Hmmm. Makes you wonder, doesn't it? Is Larry saying "Uncle?"
In other news, the State of Oregon is suing Oracle over a failed Obamacare website. That's a darn shame because others in the health care industry are enjoying great success with IBM DB2. Choose wisely.
Like learning about IBM DB2 LUW?These events might interest you!
- The DB2Night Show #143 12 DEC 2014 on HADR & TSAMP with guest Ember Crooks, IBM DB2 GOLD Consultant, Xtivia: Details and Registration
- How to Tune DB2 LUW in a Minute sponsored by DBI Software on 5 DEC 2014 2pm CST: Details and Registration Link
A message from our sponsor:
Working with DBI is like making money magically appear!
Typical customers enjoy 30-60% CPU utilization reductions in the first week, plus measurably faster transaction and query response times. More importantly, your time savings will be substantial! Read our newest SUCCESS STORY with HealthPlan Services, do your due diligence, and speak with as many references as you have time to call.
We saved a health care company $250,000 in one afternoon, solved a performance problem in two hours that two senior DBAs were unable to solve in six months, and we have helped top brand name retailers achieve top ranked e-Commerce performance on Black Friday multiple years in a row. 7 of the Top 25 Retailers, plus others, plus top Banks, State Governments, Manufacturers, Insurers, and more rely on DBI. How can we help you? Contact DBI
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!
Get the Download Replays
WMV Format - approximately 80MB
To download a recorded replay of Episode #142 in WMV format, right click on
the link below and choose "Save As..."
Episode #142, 14 November 2014, DB2 LUW Sage Performance Advice with host and guest Scott Hayes!
MP4 Format - standard resolution - 165MB
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!