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


Posted by scott on November 14, 2014, 6:00 pm
in DB2 LUW ( The DB2Night Show)







title="Scott Hayes on LinkedIn">
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...








title="Scott Hayes on LinkedIn">
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.


Congratulations!



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 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 title="Press Release: DBI and HealthPlan Services celebrate DB2 LUW successes!">SUCCESS STORY with
HealthPlan Services, do your target="NEW" title="Learn about the high cost of 'free' tools and do your due diligence">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?
target="NEW" title="Let's have a conversation - Contact DBI">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! href="http://www.linkedin.com/groupRegistration?gid=2761037" target="NEW" title="New Window: Join The DB2Night Show LinkedIn Group">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!
















Post from : http://www.dbisoftware.com/blog/db2nightshow.php
Printed from : http://www.dbisoftware.com/blog/db2nightshow.php?id=528