Articles & Content


db2top Meets Admin Views! (D03)

Topic: 2009 NA

Subtopic: DB2 for LUW

DATE: 2009-5-12 (01:30 PM - 02:30 PM)
SPEAKERS: Ray Houle (Rayzr DB Services)

db2top meets Admin Views! A monitoring marriage made in heaven... well Toronto actually. Both db2top and Admin Views have been kicking around for several years, with their adolescence behind them they are now ready to team up to form a powerful "out of the box" monitoring solution. This presentation walks through the setup and configuration of the db2top tool. We will review a variety of usage scenarios going from the 10000 foot database view to drilling down to the smallest lock. We will also look into db2topís ability to acquire and visualize your monitoring data with spreadsheet graphics.Although db2top can provide great detail, I find Administration Views deliver a flexible monitoring alternative to the relatively structured presentation of db2top. Building on several of Chris Eatonís Admin Views, I share a few of my own favorites.

EXP. LEVEL: Beginner


Position the functionality delivered by db2top and the Administration views

Setting up and configuring db2top

How To navigate db2top

How To capture, export and visualize your db2top monitoring data in Excel

Present monitoring strategies identifying common performance issues using db2top in conjunction with useful Admin Views SQL statements

Click Here to Download

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