Articles & Content


Monitoring your Database with Just SQL (D17)

Topic: DB2 for LUW

Subtopic: 2009

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

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.