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

The DB2Night Show #146: 5+ Cool Tricks for DB2 LUW, Adam Storm, IBM STSM

January 30, 2015, 4:48 pm
Posted by Scott in DB2 LUW
Adam Storm on LinkedIn

Special Guest: Adam Storm, Master Inventor & STSM, IBM Canada Lab

5+ Cool Tricks for DB2 LUW

100% of our audience learned something! Based on his popular and humorous IDUG presentations, Adam treats our audience to his wit and wisdom for DB2 LUW --- and even includes a bonus trick! #6! You will learn about STMM - how it works and ideas for monitoring it, a secret decoder ring for db2diag.log, Workload Manager and how to pull pranks on your friends, how NOT to use db2dart, and more! Enjoy...

Show Host Scott Hayes Commentary

If you don't like the way STMM works, blame Adam - he was the chief architect of it back in DB2 V9.1. He shares his email address at the end of the presentation. I think STMM has improved since its inception, but still wish that we had the ability to set ceilings and floors (max and min) sizes for each memory area controlled by STMM. Remember that shuffling memory allocation from one area to another only serves to compensate for physical design flaws whilst mitigating application issues. During DBI's short commercial, I showed how increasing a bufferpool size drove CPU utilization to 100%. Moving memory merely moves or mitigates bottlenecks. But I'm not here to preach from my STMM soap box - Adam's presentation was funny, informative, useful, helpful, and valuable. 100% of our attendees learned something, so odds are high that you will too!

Here's just a few things you are going to learn about: STMM inner workings, STMM monitoring, db2diag.log, Workload Manager (WLM), db2dart, recent performance improvements in BLU, and more!

A message from our sponsor:
DBI Software

Don't fast forward through today's educational commercial from DBI! Adam showed a cool way to parse STMM logs, turn them into Excel spreadsheets, and then graph the data. Looking at the graph, Adam noticed some significant dips but could offer no explanation for the dips. The Excel graphs were naked - without context of other events occurring in the environment. In DBI's commercial, you'll see trend charts that include significant events plotted on the charts in context. We could see that, when the bufferpool size was increased, CPU utilization spiked to 100%. There is "data" and there is "information" - make sure you know the difference. And when you are ready to turn Information into actionable Insights, be sure to Contact DBI.

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!


We've got GREAT PRIZES, wonderful, loving, kind, and helpful JUDGES, generous SPONSORS, and now we NEED YOU to BECOME A CONTESTANT! Don't be shy! Give it a try! You'll have over a 75% chance of winning a $50 Gift Certificate! Our Top 10 Finalists will be competing for a free IDUG Badge with $1500 travel allowance! Or a free seat at The DB2 Symposium with $1000 travel allowance! Or an Apple iPad!

But, never mind the prizes! As many of our former winners will tell you, do it for your career! Past participants have received raises, bonuses, promotions, invitations to speak at IDUG or write papers, made new friends and contacts, and, yes, some nearly doubled their income! THE DEADLINE TO SUBMIT A CONTESTANT APPLICATION HAS BEEN EXTENDED TO 5TH FEBRUARY 2015 AT 5PM CST.

2014 Top 20 Replays of DB2 LUW Shows

Did you see the list of our Top 20 DB2 LUW Shows in 2014? Did you notice that 6 of the Top 20 were DB2's GOT TALENT shows? Get involved and advance your career! Just sayin' icon_wink


Alex Pauliah at Dealer Track in Dallas Texas completed our survey after Episode #145 "db2pd Party with Melanie Stopfer, IBM" 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!!!

Get the Download Replays

WMV Format - approximately 85MB

To download a recorded replay of Episode #146 in WMV format, right click on the link below and choose "Save As..."
Episode #146, 30 January 2015, 5+ Cool Tricks with DB2 LUW, Adam Storm, IBM!

MP4 Format - standard resolution - 127MB

Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the MP4 ( M4V ) format!

PDF Handout

If you are a member of IDUG and attended IDUG in Phoenix or Prague, you can get a PDF of Adam's presentation from the IDUG conference "CD". If there are slides you really like, we suggest pausing your video playback, taking a screenshot, then pasting the picture into PowerPoint, Word, or other document software. This technique will also give you a place where you can make notes!

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! Let's get this tweeted and retweeted like crazy to celebrate Adam's contributions to the DB2 LUW community! Follow him at @stormadamj. We humbly also suggest you follow @srhayes, @dbisoftware, @db2performance, @db2nightshow, and @ibm_db2!

Printer friendly