Articles & Content
Topic: 2008 EU
Subtopic: DB2 for LUW
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
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.