Objectives

On successful completion of this course attendees will be able to:

  • use Command Center, Control Center, or other SQL execution environment (e.g. WinSQL) to code SQL statements
  • use the System Catlaog
  • understand and control the locking strategy used by DB2 to maintain data integrity
  • describe the different development environments available
  • explain the use and implementation of the Development Center
  • list the different types of indexes and the use of Index Advisor
  • use Visual Explain
  • use and understand the Health Center to describe the development and execution of Utilities
  • explain the use of Journals
  • describe the Replication Center
  • explain the use of the Task Center
  • use the Event Analyzer
  • describe the Indoubt Transaction Manager
  • use the Memory Visualizer
  • describe the Configuration Assistant.

Audience

IT personnel who are exposed to, or required to write and perform activities associated with application development and implementation in a DB2 UDB Linux, UNIX, and/or Windows environment.

Prerequisites

Those attending the course should be familiar with computing environments.

Duration

2 days

Outline for DB2 UDB: Linux/UNIX/Windows Introduction

1. Introduction to DB2 under Linux/UNIX/Windows

  • Versions
  • system architecture.

2. Terms/Terminology

  • Database, Buffer Pool, Instance, Tablespace
  • Tables
  • Views
  • View Merge
  • Materialization
  • Columns
  • Nulls
  • Referential Integrity
  • Alias
  • Attributes.

3. DDL via CONNECT Commands or the Control Center

4. The Locking Strategy

  • Principles and implementation.

5. Indexing

  • The different types of index available, Index Advisor, creation, Visual Explain, and Muti Dimentional Clustering.

6. Stored Procedures and UDFs

  • Development using the Development Center
  • SPL
  • execution.

7. DB2 Utilities

  • REORG, RUNSTATS, BACKUP, RESTORE, LOAD,IMPORT and EXPORT.

8. Other Options

  • Journals, Replication Center, Task Center, Event Analyzer, Health Center, Indoubt Transaction Manager, Memory Visualizer, and Configuaration Assistant.