Monitoring a DB2 UDB database


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
To explain how to monitor a DB2 UDB

Target Audience
Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator

Prerequisites
A good knowledge of database concepts, database creation and procedures, daily administration tasks, and a good working knowledge of SQL

Expected Duration (hours)
2.6

Lesson Objectives

Monitoring a DB2 UDB database

  • monitor DB2 UDB states using the snapshot monitoring utility.
  • manage event monitors and view collected event monitor data.
  • capture and return System Monitor information.
  • distinguish between the methods for collecting and viewing Explain data.
  • use Visual Explain to read SQL statements.
  • use Visual Explain.
  • use Memory Visualizer and the Health Center to monitor a database.
  • recognize when you should use the Governor and the Query Patroller.
  • monitor a database.

    • Course Number:
    217411_eng