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.)
Problem Analysis: Approach and Tools (19 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.)
-1.png)
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.)
-1.png)
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.)
