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

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

October 16, 2015, 6:26 pm
Posted by Scott in DB2 LUW
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 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. 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? 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

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!

Printer friendly