View Printable Version

D02 - Facilitate WLM functions and tools to improve your monitoring

Session Number: 3087
Track: D - DB2 for LUW II
Session Type: Podium Presentation
Primary Presenter: Michael Tiefenbacher [ids-System GmbH]
Time: Nov 16, 2015 (11:30 AM - 12:30 PM)

Speaker Bio: Michael works as a consultant, architect and trainer for DB2 LUW and Data Warehousing.
He graduated with a Master of Science from the Institute of Technology in Munich and started out as a trainer for DB2 when he introduced the IBM Business Intelligence course curriculum in Germany. With more than 15 years experience in teaching and many years of projects and consultancy work, Michael is increasingly focussed on the architecture and implementation of Data Warehouse projects (from ETL to the creation of analytical reports).
DB2 Monitoring is one of his main and favorite topics with practical experience from customer projects.
Michael is a frequent speaker at conferences and was awarded as IBM Champion from 2010 to 2015 and he is one of the RUG-Leader of the DeDUG user group and honored as IBM Gold Consultant in 2015.
Audience experience level: Intermediate
Presentation Platform: DB2 for Linux, UNIX, Windows
Presentation Category: Performance
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, New Users
Objective 1: Introcude WLM, its architecture and monitoring functions
Objective 2: Show an overview of the WLM table functions and its use for
Objective 3: Dive into the WLM event monitors. Focus on SQL statement monitoring and retrieving statstics from the statistic event monitor.

Abstract:  One part of WLM (Workload Management) is monitoring. And these monitoring features are very powerful and can be used even without a WLM license.
In this session we will focus how these tools can help to complete and improve your DB2 monitoring. It will be clearly shown what is possible without license and which additional use one gets having the license i.e in one of the Advanced Editions.

For questions or concerns about your event registration, please contact