Looking to expand your SAP knowledge using trusted resources? Our DB2 LUW Administration for SAP (ADM535), latest book from SAP Learning Hub, is your key to mastering SAP systems and processes. Perfect for students, professionals, and SAP enthusiasts, this book provides verified content straight from the source.
Unit 1: Basics
Lesson: DB2 Products and Versions
Lesson: DB2 Essentials
Lesson: DB2 Connect and Security
Lesson: DB2 EDUs, Starting and Stopping
Lesson: DB2 Configuration
Lesson: DB2 Memory Management
Unit 2: Storage Management
Lesson: Fundamentals
Lesson: Tablespace Types and Techniques
Lesson: SAP Tablespace Pools
Lesson: Excursus - Legacy DMS Tablespaces
Lesson: Storage Layout Hints
Unit 3: Table and Index Maintenance
Lesson: Quality of Data Storage - REORGCHK
Lesson: Table and Index Reorganization
Lesson: Statistics Collection - RUNSTATS
Lesson: Data and Index Compression
Lesson: Further Techniques
Unit 4: Log File Management
Lesson: Log File Fundamentals
Lesson: Logging Mechanism
Lesson: Logging Information
Lesson: Log File Handling
Unit 5: Database Backups
Lesson: Reasons for Backups
Lesson: Backup Architecture
Lesson: Backup Types
Lesson: Backup Tools
Lesson: Backup Monitoring
Lesson: Backup Validation
Lesson: Advanced Backup Technologies
Lesson: Backup Strategy
Unit 6: Recovery
Lesson: Recovery - Necessity to be Prepared
Lesson: Recovery Techniques
Lesson: Recovery - Additional Information
Unit 7: Performance Monitoring and Tuning
Lesson: Performance Monitoring
Lesson: Memory
Lesson: Cost-Based Optimizer
Lesson: Statement Tuning
Lesson: Monitoring and Tuning Tools
Unit 8: Problem Analysis
Lesson: Problem Reporting
Lesson: Problem Analysis Approach and Tools
Lesson: Sources of Information
Unit 9: Infrastructure Options
Lesson: DB2 BLU Acceleration
Lesson: Database Partitioning Feature (DPF)
Lesson: Excursus - Multi-Dimensional Clustering (MDC)
Lesson: HADR and Tivoli System Automation
Lesson: DB2 pureScale Cluster Solution