Web Age Solutions Inc
Providing Technology Training and Mentoring For Modern Technology Adoption
Web Age Aniversary Logo
US Inquiries / 1.877.517.6540
Canadian Inquiries / 1.877.812.8887
Course #:WA2280

DB2 UDB: Linux/UNIX/Windows Introduction Training

This course introduces and explains all aspects of relational technology as implemented by DB2 UDB for Linux, UNIX and/or MS Windows. The course is designed for applications programmers, designers, analysts and DBAs who have used DB2 in a mainframe environment. The presentation combines formal tuition with practical workshop sessions.


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.


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.


Those attending the course should be familiar with computing environments.


2 days

Outline of DB2 UDB: Linux/UNIX/Windows Introduction Training

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


8. Other Options

  • Journals, Replication Center, Task Center, Event Analyzer, Health Center, Indoubt Transaction Manager, Memory Visualizer, and Configuaration Assistant.
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
US Inquiries / 1.877.517.6540
Canadian Inquiries / 1.877.812.8887