Articles & Content


Using the New Administrative Views in DB2 9 to Monitor Your Database (E07)

Topic: 2008 NA

Subtopic: DB2 for LUW

DATE: 2008-05-20 (01:30 PM - 02:30 PM)
SPEAKERS: Chris Eaton (IBM Toronto Lab)

In previous releases, IBM had shipped a set of user defined table functions to give you SQL access to snapshot data. Now in DB2 9 there are a set of administrative views that you can query directly from SQL to get both snapshot information as well as high value monitoring information about your database and the operating system that database is running on.Join Chris as he takes you through the new administrative views and gives you SQL statements you can use right away to monitor the performance and health of your DB2 9 database.

EXP. LEVEL: Beginner,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!

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.