Articles & Content
Topic: 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
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.