Course announcements

  • This course delivers in depth knowledge you need to know to keep DB2 running smoothly and efficiently in your SAP system environment. You will get to learn about the architecture of DB2 and understand how to use the administration tools to manage your system. Topics like storage management, backup and recovery, performance monitoring and tuning, problem analysis and troubleshooting are also discussed.

Goals

  • Manage DB2 in an SAP environment using the administration tools provided by SAP system and DB2
  • Implement appropriate database backup and recovery strategies
  • Understand performance and tuning
  • Recognize performance bottlenecks

Audience

  • Database Administrator
  • System Administrator
  • Technology Consultant

Prerequisites

Essential

  • SAPTEC SAP NetWeaver Application Server – Fundamentals

Recommended

  • SAP system administrators should attend the course ADM100 System Administration I for SAP S/4HANA and SAP Business Suite
  • Basic knowledge of administrating at least one operating system

Course based on software release

  • IBM DB2 for LUW 11.1 / SAP NW AS 7.50

Content

  • Basics
    • Understanding DB2 products and versions
    • Describing DB2 essentials
    • Describing user and security management
    • Explaining DB2 EDUs, starting and stopping
    • Describing DB2 configuration
    • Understanding DB2 memory management
  • Storage Management
    • Describing DB2 storage concepts
    • Explaining tablespace types and techniques
    • Explaining SAP Tablespace Pools
    • Describing the legacy DMS tablespaces
    • Choosing storage layout
  • Table and Index Maintenance
    • Describing the quality of data storage
    • Deciding the best reorganization strategy
    • Setting up statistics collection in production systems
    • Describing and using data compression features
    • Understanding advanced techniques of storing table and index data
  • Log File Management
    • Explaining the transaction log file content
    • Understanding DB2 log file management
    • Explaining the DB2 logging tools
    • Explaining log file handling
  • Database Backups
    • Explaining reasons for backups
    • Describing the backup architecture
    • Explaining backup types
    • Explaining backup tools
    • Monitoring backup
    • Validating backup
    • Implementing advanced backup technologies
    • Implementing backup strategy
  • Recovery
    • Understanding the need to prevent data loss and disaster recovery
    • Explaining recovery techniques
    • Understanding special recovery techniques
  • Performance Monitoring and Tuning
    • Monitoring performance
    • Assessing key performance indicators
    • Describing DB2 cost-based optimizer
    • Tuning SQL statement
    • Using monitoring and tuning tools
  • Problem Analysis
    • Understanding the support and maintenance processes for DB2 database servers and collect support data
    • Using problem analysis tools
    • Describing sources of information
  • Infrastructure Options
    • Understanding DB2 BLU Acceleration
    • Describing database partitioning feature
    • Understanding multi-dimensional clustering
    • Describing HADR and Tivoli System Automation
    • Describing DB2 pureScale cluster solution