IDUG DB2 Tech Conference EMEA 2011
Clarion Congress Hotel, Prague, Czech Republic
14 - 18 November, 2011

View Printable Version

The proactive DBA

Session Number: 1830
Track: DB2 for LUW Lessons Learned (D)
Session Type: Podium Presentation
Primary Presenter: Michael Tiefenbacher [ids-System GmbH]
Time: Nov 14, 2011 (11:30 AM - 12:30 PM)
Room: Leo

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 about 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). Michael was awarded as IBM Information Champion in 2010 and in 2011.
Audience experience level: Select a Value
Presentation Category: Data Management
Presentation Platform: Select a Value
Audiences this presentation will apply to: Database Administrators
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), High Availability (DB2 for LUW), SQL and XML Features
Objective 1: Why is it important to pro-actively show that you as DBA do a great job.
Objective 2: What do DBA do today to "sell" what they do?
Objective 3: Which monitor elements can be used as KPI (key performance indicator) for the performance and stability of your DB2 databases.
Objective 4: Which monitors and functionalities can I use to efficiently provide these KPIs?
Objective 5: How can I convert monitor data into a presentable and understandable format (without extra costs).

Abstract:  Today DBAs often only just react. They react on errors, performance issues and whatever is accused to be a DB2 problem. It is time now to proactively show how successful the DBA really is and who stable and fast DB2 runs. This presentation suggest some techniques to demonstrate the power of DB2 by suggesting some KPIs, showing how to efficiently monitor them and finally how these collected information can be presented in a "manager-suited" format.

For questions or concerns about your event registration, please contact