Articles & Content

Archives

Green Light, Go! Building Your Own DBA Dashboard (B03)

Topic: 2008 NA

Subtopic: DB2 for z/OS



DATE: 2008-5-19 (01:30 PM - 02:30 PM)
SPEAKERS: Chris Skelnik (TransUnion)

In most shops, DBAs need to access a variety of monitors, tools, and reports to get a feel for how their DB2 for z/OS systems are running. Given the complexity of DB2, finding the pertinent information you need can be overwhelming, time-consuming, and sometimes feels like trying to find a needle in a haystack. Frustrated by these issues, we decided to create our own DBA Dashboard. This web-enabled portal pulls together existing information about applications, subsystems, DASD, DB2 internals, and more. Written using PHP and DB2, and complete with built-in charting tools, the Dashboard presents just the information we deem important to troubleshoot, trend, monitor, and better manage our DB2 environments. This presentation will describe what we did, why we did it, and how you can do the same, along with plenty of examples of the Dashboard in action.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

The Expanded Role of the DBA - Trending, Forecasting, Fortune-Telling

Understanding the Problem: Stovepiped Performance Reporting and Monitoring

Build Your Own Dashboard Without Buying Anything

Use Your Dashboard to Answer DBA, Application, and (most importantly) Management Questions

Pictures Speak Louder Than Words - The Benefits of a Visual Tool



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.