The DB2Night Show #120: Tuning SAP on DB2 LUW with Martin Hubel

Martin Hubel on LinkedIn
Follow @mhubel on Twitter!

Special Guest: Martin Hubel, MHC, IBM DB2 GOLD Consultant and Information Management Champion

Tuning SAP on DB2 LUW

100% of our studio audience learned something! During this episode of The DB2Night Show™, Martin offered many valuable suggestions for tuning SAP in a DB2 LUW environment based on his experiences at several clients. This presentation has "meat on its bones"! Learn about dropping indexes, adding indexes, block based bufferpools, STMM, Vector I/Os and more! Watch and learn...


A message from our sponsor:
DBI Software

Today's "DBI Commercial" was very educational, so don't fast forward through it! Previously on The DB2Night Show and at IDUG conferences (Orlando, Melbourne, and Barcelona 2013), Scott Hayes has presented on DB2 10.1 and the new Index Jump Scans. During our commercial, we compared the performance of DB2 V9.7 versus DB2 10.1 FP3 in a high volume OLTP e-commerce environment. A number of SQL statements in the 4,200+ statement workload benefited from Index Jump Scans. Pay attention! You'll see reduced Index Logical Read costs, lower CPU, and some faster response times!

Our #1 Job is helping you look great!
Our #2 Job is giving you the documentation to prove it!

Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs.

Show Host Scott Hayes Commentary

Martin cracks me up. He has a wonderfully dry and cynical sense of humor. More importantly, he brings to the DB2 community insights from his practical, hands-on, real-world experiences. I'm blessed to call him a friend and thankful that he shares hosting The DB2Night Show with me.

With 100% of our studio audience learning something, I trust you'll find some gold nuggets in this show that will be helpful to you. While focused on SAP, some of Martin's advice is applicable to OLTP databases in general. Enjoy!

Five quick questions and a chance to win a
$50 Amazon.com Gift Card

May we please have your help? DBI is developing some new banner ads for 2014 and we're soliciting input on ad concepts from the DB2 community. We have a very short SurveyMonkey survey where we present four ad concepts and ask for your feedback. One survey participant will win a $50 Amazon.com gift card on December 20th 2013! CLICK HERE to take the survey. Thank you!!!

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!

Insider Information

Here's another great reason to join The DB2Night Show LinkedIn Group: SECRET INSIDER INFORMATION. Every once in awhile, we run shows where EVERYONE in our studio audience can be a prize winner! JUST SHOW UP and COLLECT! We only announce these special shows within The DB2Night Show LinkedIn group!

Everyone that attended Episode #110 Database Performance Trends and gave us the prize word SLIPPERS won a $10 gift certificate to Amazon.com, Lowes.com, or Starbucks, or we made donations to the American Red Cross or Big Brothers Big Sisters - at the choice of each show attendee! IT PAYS TO LEARN DB2 on The DB2Night Show!

Congratulations!

Congratulations to Shelley Mizerak at IBM in Oconomowoc Wisconsin! You've won a $25 Amazon.com gift card! Thank you for completing the survey after show #119 DB2 LUW Potluck and IBM IOD Insights!

To all of our winners - please be patient on these gift cards. We issue them every four to five or so shows because bulk gift card orders save time.

Get the Download Replays

WMV Format - approximately 58MB

To download a recorded replay of Episode #120 in WMV format, right click on the link below and choose "Save As..."
Episode #120, 13 December 2013, Tuning SAP on DB2 LUW with guest Martin Hubel

MP4 Format - standard resolution - 103MB

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: