Articles & Content

Archives

Monitoring your Database with Just SQL (D17)

Topic: 2009 EU

Subtopic: DB2 for LUW



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

OBJECTIVES:

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.