Articles & Content
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.