Articles & Content


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

Topic: DB2 for LUW

Subtopic: 2008

DATE: 2008-10-14 (15:30 - 16:30)
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


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.