Objectives

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.

Audience

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

Prerequisites

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

Duration

2 days

Outline for DB2 UDB Family: Introduction & Fundamentals

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
  • SYNONYM & ALIAS
  • 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
  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • COMMIT / ROLLBACK
  • 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.