Learning Material

Before embarking on your learning journey, don't miss this pre-read: Curious about the speakers in our videos?

The following videos teach you the Db2 essentials:

Naming Conventions (2 min.)

Architecture (9 min.)

Statement Processing (10 min.)

Layout and Storage (14 min.)

Client Connectivity (19 min.)

Additional Features (9 min.)

Db2 Configuration (15 min.)

Db2 Mod Pack and Fix Pack Update (13 min.)

Db2 Version Upgrade (18 min.)

Problem Reporting (4 min.)

Authentication and Authorization (9 min.)

Privileges and Authorities (5 min.)

Roles (11 min.)

Fundamentals (18 min.): Get an overview of the do's and don'ts of good database storage design and learn the basics about data pages, record identifiers, slot directories, index trees, and more.

Storage Concepts and Tablespace Types (23 min.)

Reclaimable Storage (11 min.)

SAP Tablespace Pools (13 min.)

More information about tablespace pools: SAP Note 2267446

More information about table conversion using the DB6CONV program: SAP Note 1513862

Table and Index Maintenance (15 min.)

Fundamentals (19 min.)

Logging Mechanism (18 min.)

Advanced Log Space Management (ALSM) (5 min.)

More information about ALSM: Blog post on SAP community

More information about the Db2 process model: IBM Db2 documentation (non-SAP website)

Reasons for Backups (2 min.)

Backup Architecture (13 min.)

Backup Types (11 min.)

Backup Tools (13 min.)

Backup Monitoring (4 min.)

Database Backup: Validation (14 min.)

Database Backup: Advanced Technologies (13 min.)

Recovery Techniques: Overview (10 min.)

Recovery Techniques: Restore (10 min.)

Recovery Techniques: Rollforward (13 min.)

Performance: Statement Tuning (8 min.)

Performance: Memory (15 min.)

Db2 Cost-Based Optimizer (9 min.)

Performance Optimization for SAP BW Systems on IBM Db2 (9 min.)

Introduction (10 min.)

Db2 BLU Acceleration in SAP Business Warehouse (SAP BW) (11 min.)

Conversion from a row- to column-organized layout of your SAP BW objects (12 min.)

More information about SAP systems with Db2 BLU Acceleration: SAP Note 1825340 and SAP BW on IBM Db2 Administration Guide

Db2 BLU Acceleration: Considerations for Migrating from or to IBM Db2 (11 min.)

Introduction (12 min.)

DPF Layout (8 min.)

Conversion to Multiple Partitions (7 min.)

Supported IBM Db2 Versions and Fix Pack Levels:

SAP Note 101809

Supported IBM Db2 Database Features:

SAP Note 1555903

SAP Standard Parameter Settings (SAP Notes):
Db2 12.1, Db2 11.5, Db2 11.1, Db2 10.5

SAP on Db2 for LUW Community:

Main Page

All guides at a glance:

SAP Help Portal