Team with the best
Db2® LUW Performance Tools
company in the World

The DB2Night Show #142: DB2 LUW Sage Performance Advice with Scott Hayes

November 14, 2014, 6:00 pm
Posted by Scott in DB2 LUW
Scott Hayes, President DBI Software, IBM DB2 GOLD Consultant
@srhayes :: @db2performance

Special Guest: Scott Hayes, DBI Software

Sage DB2 LUW Performance Advice
A "New" Way to Analyze Performance

100% of our audience learned something! Based on his IDUG Phoenix Top 10 presentation, Scott presents a new way to think about and analyze DB2 LUW performance. Today's show even includes a 6 minute video clip taken from IDUG in Prague. ATTENDEES will receive all the cool SQL commands electronically! Watch and learn...

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 gift certificate! We'll get this sent out within the next few weeks! THANK YOU FOR COMPLETING OUR POST-SHOW SURVEY!!!

Think About This

Larry 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!

A message from our sponsor:
DBI Software

Magic Hat Money 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! icon_biggrin

Share a great show with your friends and followers!

Printer friendly