← All courses

🔷 IBM Db2

The engine behind a great deal of banking and insurance — Db2's dialect, its catalog, isolation and locking vocabulary, and what changes when the data lives on z/OS.

No lessons published yet — this is the roadmap, so you can see exactly what the course will cover before it lands.

Before you start: Learn SQL — Series 1 and Series 2. Db2's SQL is close to the standard, so most of what you know transfers directly. This track is the remainder — the catalog, the isolation vocabulary, the error codes and the platform differences.

Short on time? The 11 episodes marked core are the shortest path to being productive at work. Start there and pick up the rest whenever a job asks for them.

Series 1 · Db2 Essentials

connecting, the catalog, and the dialect differences

  1. 01

    LUW and z/OS — One Dialect, Two Products, and How to Connect to Each

    coreintermediatecoming soon
  2. 02

    SYSIBM.SYSDUMMY1, DECIMAL and Collation — The Dialect's Own Corners

    coreintermediatecoming soon
  3. 03

    SYSCAT and SYSIBM — Reading a Schema You Inherited

    coreintermediatecoming soon
  4. 04

    SELECT FROM FINAL TABLE — Db2's Answer to RETURNING, and MERGE

    coreintermediatecoming soon
  5. 05

    Packages and BIND — When the Access Plan Was Chosen, and Why a REBIND Changes It

    intermediatecoming soon
  6. 06

    db2 backup, restore and rollforward — and Why Circular Logging Loses Today

    coreintermediatecoming soon
  7. 07

    Project — Answer a Question From an Unfamiliar Db2 Schema

    coreintermediate#projectcoming soon

Series 2 · Concurrency and Performance

isolation spelled UR/CS/RS/RR, and reading an access plan

  1. 01

    UR, CS, RS and RR — The Same Four Levels Under Different Names

    coreadvancedcoming soon
  2. 02

    Reading SQLCODEs — -911, -803, +100 and What Each One Is Telling You

    coreadvancedcoming soon
  3. 03

    EXPLAIN, Explain Tables and db2exfmt — Getting an Access Plan Out of Db2

    coreadvancedcoming soon
  4. 04

    RUNSTATS and Index Design — Why the Plan Was Fine Last Month

    coreadvancedcoming soon
  5. 05

    Tablespaces, Bufferpools and BLU — The Physical Layer You Cannot Ignore

    advancedcoming soon
  6. 06

    Materialized Query Tables — the Summary Db2 Substitutes Without Asking

    advancedcoming soon
  7. 07

    Project — Diagnose a Slow Db2 Query From Its Access Plan

    coreadvanced#projectcoming soon

Not here, on purpose

  • SQL itself — covered in Learn SQL
  • Database administration — HADR, storage groups, security — not covered. In this course, Series 1 · 22 teaches backup, restore and rollforward on LUW, because logging mode is a decision made before the data matters; HADR and storage groups stay with the DBA
  • COBOL, CICS and mainframe application development — not covered. Series 1 · 20 explains what a bound package is because a query author meets one, and stops there