The DB2Night Show #164: 8 High-Impact Performance Tuning Tips for DB2 LUW


Posted by scott on October 16, 2015, 6:26 pm
in DB2 LUW ( The DB2Night Show)







title="Ember Crooks on LinkedIn">
Ember Crooks, IBM DB2 GOLD Consultant



@ember_crooks


Special Guest: Ember Crooks

DB2 Lead DBA & Delivery Manager, Xtivia

IBM DB2 GOLD Consultant



8 High-Impact Performance Tuning Tips

for DB2 LUW OLTP & E-Commerce Databases



97% of our audience learned something! Want to make your OLTP databases run faster? Ember offered eight terrific tips and sage advice for getting maximum performance from your transactional databases! Index Read Efficiency, finding problem SQL, finding index solutions, finding bad indexes and dropping them, pruning data, HADR impacts, when to use STMM and when NOT to use it, using parameter markers or STMT_CONC, and optimal use of Solid State Disk (SSD). Watch and learn...








title="Ember Crooks on LinkedIn">
Ember Crooks, IBM DB2 GOLD Consultant



@ember_crooks


Special Guest: Ember Crooks

DB2 Lead DBA & Delivery Manager, Xtivia

IBM DB2 GOLD Consultant



8 High-Impact Performance Tuning Tips

for DB2 LUW OLTP & E-Commerce Databases



97% of our audience learned something! Want to make your OLTP databases run faster? Ember offered eight terrific tips and sage advice for getting maximum performance from your transactional databases! Index Read Efficiency, finding problem SQL, finding index solutions, finding bad indexes and dropping them, pruning data, HADR impacts, when to use STMM and when NOT to use it, using parameter markers or STMT_CONC, and optimal use of Solid State Disk (SSD). Watch and learn...






Show Host Scott Hayes Commentary



Ember has been attending my IDUG presentations for many years and it's been a pleasure to mentor her. No doubt, she's incredibly smart and talented. Somehow she's taken many of the things I've taught over the years and figured out how to do a better job presenting the ideas and concepts. Not only was Ember singing my songs today, but she's written some of her own hits too. Check out the SQL she wrote and shared in this presentation! It makes my brain hurt! Thank you Ember for an excellent presentation!


DB2 Certification Book Winner



Congratulations to John Leggio at NTT Data in Hauppauge New York - You won the DB2 LUW 10.1/10.5 DB2 Certification Study Guide! We'll be in touch to arrange shipping details.


More shows Featuring Ember Crooks



Check out these replays of past shows:







A message from our sponsor:

DBI Software


During today's quick 3 minute commercial, DBI demonstrated its new Advanced Index Benefit Analysis. When db2advis tells you that you can get a 98% cost improvement by creating several indexes, which indexes are the most beneficial? Which are marginally or minimally helpful? This challenge has plagued DBAs since Version 6 of DB2. Finally, DBI has automated answers for you! Don't skip the commercial!









Magic Hat Money

Working with DBI is like making money magically appear!


Typical customers enjoy 40-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. 8 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




Click Here for Replays



PDF Handout



A PDF handout was distributed to live show attendees. Do you like handouts? Join our shows live! If our guest makes handouts available, they'll be distributed via GoToWebinar during the live shows. On the GoToWebinar tool, there's a tab that has "+ Handouts". Click this and get the PDFs!


Sharing is Caring!


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=646