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

The DB2Night Show #169: DB2 LUW WLM (Workload Manager) Monitoring Features

January 22, 2016, 2:19 pm
Posted by Scott in DB2 LUW
Michael Tiefenbacher on LinkedIn

Special Guest: Michael Tiefenbacher
Manager Business Services & Data Management Specialist at ids-System

Facilitate WLM Functions and Tools to Improve Your DB2 LUW Monitoring

100% of our audience learned something! If you don't have tools, you need to be clever about monitoring DB2 with built-in monitoring capabilities. During this show, Michael does a great job of explaining how DB2 Workload Manager (WLM) features and functions can be used for capturing and analyzing SQL, histograms, and system statistics. Enjoy the replay ...

Show Host Scott Hayes Commentary

Michael was kind enough to provide a PDF handout so you can easily reference his materials (copy and paste his sample commands). Nonetheless, make sure you watch the video replays as well so that you can fully understand and appreciate what Michael is teaching. Also, some of the commentary is funny.


Our call for contestants is NOW OPEN! Only 20 slots available! Unlike prior years, contestants will only present ONCE! And, every Contestant will earn an honorarium prize ranging from $10 to $75 just for giving a short 7 minute presentation!

Like learning about IBM DB2 LUW?

These upcoming events might interest you!
  • The DB2Night Show #170 29 JAN 2016: DB2 Data Security 102: Details and Registration
  • How to Tune DB2 LUW in Minutes! Sponsored by DBI Software on 18 FEB 2016 11am CST: Details and Registration Link
  • DB2's GOT TALENT 2016! New Format - Simpler - Less Time - More Fun and Learning! Each Contestant will present ONLY ONCE for a maximum of 7 minutes! Every Contestant is a Winner! Judges will critique and score each presentation, and scores are used to determine Contestant honorarium award! The DB2 Community benefits from a BUFFET of DB2 and IBM Technology Knowledge! Register once for all four shows on February 19 & 26 and March 4 & 11 !

A message from our sponsor:
DBI Software

Let's just cut to the chase. DBAs spend hours and hours trying to figure out which indexes are the most beneficial, which to create, and which, if any, might be harmful. During this show's quick commercial, DBI demonstrated AUTOMATED Advanced Index Benefit Analysis. You can spend hours doing the benefit analysis and calculations by hand, or you can get an accurate index benefit analysis with DBI in under a minute. Ready to save time and tune confidently? Contact DBI Now

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!

Get the Download Replays

WMV Format - approximately 72MB

To download a recorded replay of Episode #169 in WMV format, right click on the link below and choose "Save As..."
Episode #169, 22 January 2016, Facilitate WLM Functions and Tools to Improve Your DB2 LUW Monitoring

MP4 Format - standard resolution - 118MB

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

BONUS! PDF Handout!

A PDF handout is provided as reference material so that you can copy and paste many of the SQL commands. The PDF, alone, is not a substitute for what you will learn by watching the video replays. If you PROMISE to watch the video replays, then you are granted permission to CLICK HERE for the PDF.

Did you learn something from this show?

Share a great show with your friends and followers!

Printer friendly