 | Level: Introductory Roger E. Sanders (rsanders@netapp.com), Senior Manager - IBM Alliance Engineering, Network Appliance, Inc.
05 Jul 2006 This tutorial introduces you to the set of monitoring tools that are available with DB2® 9 and to show you how each are used to monitor how well (or how poorly) your database system is operating. This is the fourth tutorial in a series of seven that you can use to help prepare for the DB2 9 for Linux®, UNIX®, and Windows™ Database Administration Certification (Exam 731). Objectives - Capture snapshots using GET SNAPSHOT or SQL functions
- Create and activate event monitors
- Configure the health monitor using the Health Center
- Capture and analyze explain/Visual Explain information
- Identify the functions of DB2's problem determination tools (for example, db2pd and db2mtrk)
Prerequisites
To take the DB2 9 DBA exam, you must have already passed the DB2 9 Fundamentals exam 730.
If it's available, we recommend that you take the DB2 Fundamentals tutorial series before starting this series. If the Fundamentals series is not yet available, it's fine to do this DBA series first.
To help you understand some of the material presented in this tutorial, you should be familiar with the following terms:
-
Structured Query Language (SQL): A standardized language used to define objects and manipulate data in a relational database.
-
DB2 optimizer: A component of the SQL precompiler that chooses an access plan for a Data Manipulation Language (DML) SQL statement by modeling the execution cost of several alternative access plans and choosing the one with the minimal estimated cost.
System requirements
You do not need a copy of DB2 to complete this tutorial. However, you will get more out of the tutorial if you download the free trial version of IBM DB2 9 to work along with this tutorial.
Duration
Less than one hour
Formats html, pdf
| | | |
