SAP Database Administration (DB2 LUW)

This course will prepare you to manage IBM Db2 for LUW 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, and recognize performance bottlenecks.

Retail Price: $2,250.00

Next Date: Request Date

Course Days: 3


Request a Date

Request Custom Course


Who Can Benefit

  • Database Administrator
  • System Administrator
  • Technology Consultant

Prerequisites

  • Essential:
       -SAPTEC SAP NetWeaver Application Server - Fundamentals
  • Recommended:
       -SAP system administrators should attend the course ADM100
       -Basic knowledge of administering at least one operating system

Course Content

  • Db2 Basics
       -Products, versions, and essentials
       -User and security management
       -Engine dispatchable units (EDUs)
       -Configuration
       -Memory management
  • Storage Management
       -Storage concepts and layout
       -Tablespace types
       -SAP tablespace pools
  • Table and Index Maintenance
       -Reorganization strategy
       -Statistics collection
       -Data compression
       -Advanced techniques of storing table and index data
  • Log File Management
       -Transaction log files
       -Db2 log file management
       -Logging tools and log file handling
  • Database Backups
       -Backup architecture including reasons and strategy for backups
       -Backup types and tools
       -Monitoring and validating backups
       -Advanced backup techniques
  • Recovery
       -Understanding the need to prevent data loss and disaster recovery
       -Recovery techniques
  • Performance Monitoring and Tuning
       -Monitoring performance
       -Key performance indicators
       -Db2 cost-based optimizer
       -Tuning SQL statements
       -Monitoring and tuning tools
  • Problem Analysis
       -Support and maintenance processes and collecting support data
       -Problem analysis tools
       -Information sources
  • Infrastructure Options
       -Db2 BLU Acceleration
       -Database partitioning feature (DPF)
       -Multidimensional clustering
       -HADR and Tivoli System Automation
       -Db2 pureScale cluster solution


Sorry! It looks like we haven’t updated our dates for the class you selected yet. There’s a quick way to find out. Contact us at 502.265.3057 or email info@training4it.com


Request a Date