Profile

e-Catalog

Contact

Search

Cart

IBM DB2 Universal Database 5.0: Monitoring DB2 Activity

Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	4 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

Audience

Database administrators responsible for DB2 databases and data storage

Prerequisites

A basic understanding of DB2 and DB2 fundamentals; completion of the courses DB2 Universal Database 5.0: Database Planning and Installation and DB2 Universal Database 5.0: Security and Instances

Course Aim

To provide a DB2 database administrator with the knowledge required to monitor and modify a DB2 instance or database

Learning Objectives

Locate and modify instance and database configuration settings. Understand the use of buffer pools. Capture and analyze explain data. Use the Snapshot Monitor and the Event Analyzer. Change monitor types.

Topics Covered

DB2 performance - DB2 memory usage - Changing memory parameters - Managing the database buffer pool - Hands-on: Changing a buffer pool size - The Configuration SmartGuide - Hands-on: Changing the BUFFPAGE size SQL monitoring - Query compilation - Explain tables - Gathering explain data - Analyzing explain data Database monitoring - Overview - Using the Snapshot Monitor - Changing monitor values - Analyzing Snapshot Monitor data Event monitoring - Overview - Creating event monitors - Hands-on: Removing an event monitor - The Event Analyzer - The Performance Monitor