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 #:WA2278

DB2 UDB Family: Introduction & Fundamentals Training

This course introduces and explains the fundamental principles of the DB2 UDB family of products. The course focuses on the relational theory and concepts, and how DB2 adheres to them. It also introduces the basic concepts of DB2 data storage, SQL, DB2 utilities, and the use of DB2 Interactive (DB2I) and the relevant centres.


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

  • describe the relational theory and concepts
  • list the objects used to store DB2 data
  • understand the use of Structured Query Language
  • describe the functions available with DB2 Interactive (DB2I)
  • list the utility jobs available for DB2.


All IT professionals who need to understand the full range of the DB2 UDB family of products.


A basic understanding of IT, with some exposure to database technology as a user.


2 days

Outline of DB2 UDB Family: Introduction & Fundamentals Training

1. DBMS Overview

  • A database is...
  • DB2 is...
  • Hierarchical database structure
  • Network database structure
  • Relational database structure
  • Table structure
  • DB2 family & versions.

2. Relational Theory & Concepts

  • E F Codd
  • The relational model
  • Structure: tables, rules for columns and rows, keys, Primary and Foreign keys
  • Manipulation: relational algebra, project, Restrict, join, UNION
  • Domain and user-defined Integrity
  • Entity and Referential Integrity
  • Referential Integrity: INSERT, UPDATE, DELETE.

3. DB2 Data & System Overview

  • DB2 objects
  • the DB2 database
  • Tablespace and Instance
  • Tablespace formats
  • Table
  • View
  • Index
  • Index structure
  • Storage group
  • User defined datasets
  • Schema
  • Trigger
  • DB2 catalog & directory
  • DB2 address spaces
  • DB2 attachments
  • Buffer Pools & Hiperpools
  • DB2 logging.

4. Structured Query Language Overview

  • Structured Query Language
  • Data Definition Language commands & examples
  • Data Control Language commands & examples
  • Data Manipulation Language commands
  • DB2 Optimizer.

5. DB2 Interactive (DB2I) and Command Center Overview

  • DB2I primary option menu
  • Panels: SPUFI defaults
  • Precompile
  • Option 5 - BIND / REBIND / FREE
  • Option 6 - RUN
  • Option 7 - DB2 commands
  • Option 8 - DB2 Utilities
  • Invoking DB2 Utilities.

6. DB2 Utilities Overview

  • Controlling Utilities
  • Backup & Recovery Utilities
  • Integrity & consistency utilities
  • General utilities
  • Stand-alone utilities.

7. The Centers

  • Development Center
  • Replication Center: Introduction, Create the capture control tables, Register a source table, Create the apply control tables
  • Task Center: Introduction, Creating a task
  • Event Analyzer
  • Health Center: How it works, Type of alert/action/indicators, Using, Configure, Recommendation Adviser
  • Indoubt Transaction Manager
  • Memory Visualizer
  • Configuration 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