Articles & Content
Topic: 2009 EU
Subtopic: DB2 for LUW
DATE: 2009-10-8 (11:00 - 12:00)
SPEAKERS: Chris Eaton (IBM Toronto Lab)
DB2 9 now offers very useful administrative views that are built into the server. These views can help monitor database status, system performance, database health as well as help diagnose database problems. The big benefit is that you can do this with simple SQL statements in your very own simple scripts. Chris will take you through these new administrative views and you will walk away with a set of scripts to get you started.
EXP. LEVEL: Intermediate,Advanced
Introduction to the DB2 9 administrative views
Queries to monitor database status
Queries to monitor database performance
Queries to monitor database health
Queries to diagnose database problems
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.