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

  • Technology Consultant

Prerequisites

Essential

  • TADM10SAP NetWeaver AS Implementation & Operation I
  • TADM12SAP NetWeaver AS Implementation & Operation II
  • Sound knowledge of database administration

Recommended

  • SAP system administrators should attend the courseADM100System 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