Training Schedule Training Schedule

(ADM535) Database Administration (DB2 LUW)
Code: ADM535 v17
Type: null
Tuition (USD): $2250
Length: 3 Days
Have a question?

Contact Us

character(s) remaining

Contact us for upcoming dates.
Skills Gained:
1) Manage DB2 in an SAP environment using the administration tools provided by SAP system and DB2 2) Implement appropriate database backup and recovery strategies 3) Understand performance and tuning 4) Recognize performance bottlenecks
Who Should Attend?
Database Administrator System Administrator Technology Consultant
Prerequisites:
  • Essential: SAPTEC - Fundamentals of SAP NetWeaver Application Server
  • Recommended: SAP system administrators should attend the course ADM100 AS ABAP Administration I; Basic knowledge of administrating at least one operating system
What You Will Learn:
  • 1) Basics
  • a) Understanding DB2 products and versions
  • b) Describing DB2 essentials
  • c) Describing user and security management
  • d) Explaining DB2 EDUs, starting and stopping
  • e) Describing DB2 configuration
  • f) Understanding DB2 memory management
  • 2) Storage Management
  • a) Describing DB2 storage concepts
  • b) Explaining tablespace types and techniques
  • c) Explaining SAP Tablespace Pools
  • d) Describing the legacy DMS tablespaces
  • e) Choosing storage layout
  • 3) Table and Index Maintenance
  • a) Describing the quality of data storage
  • b) Deciding the best reorganization strategy
  • c) Setting up statistics collection in production systems
  • d) Describing and using data compression features
  • e) Understanding advanced techniques of storing table and index data
  • 4) Log File Management
  • a) Explaining the transaction log file content
  • b) Understanding DB2 log file management
  • c) Explaining the DB2 logging tools
  • d) Explaining log file handling
  • 5) Database Backups
  • a) Explaining reasons for backups
  • b) Describing the backup architecture
  • c) Explaining backup types
  • d) Explaining backup tools
  • e) Monitoring backup
  • f) Validating backup
  • g) Implementing advanced backup technologies
  • h) Implementing backup strategy
  • 6) Recovery
  • a) Understanding the need to prevent data loss and disaster recovery
  • b) Explaining recovery techniques
  • c) Understanding special recovery techniques
  • 7) Performance Monitoring and Tuning
  • a) Monitoring performance
  • b) Assessing key performance indicators
  • c) Describing DB2 cost-based optimizer
  • d) Tuning SQL statement
  • e) Using monitoring and tuning tools
  • 8) Problem Analysis
  • a) Understanding the support and maintenance processes for DB2 database servers and collect support data
  • b) Using problem analysis tools
  • c) Describing sources of information
  • 9) Infrastructure Options
  • a) Understanding DB2 BLU Acceleration
  • b) Describing database partitioning feature
  • c) Understanding multi-dimensional clustering
  • d) Describing HADR and Tivoli System Automation
  • e) Describing DB2 pureScale cluster solution
Course Info:
Course based on software release: IBM DB2 for LUW 10.5; SAP NetWeaver Application Server 7.40

Course notes and announcements:

1) 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.

This is a SAP CERTIFIED Course. Your course will include Full Class Delivery of the comprehensive standard SAP curriculum agendas, SAP Certified Instructor, Demonstration and Presentation, Student Hands on exercises, Access to SAP Hosted servers/training environment, SAP Certified e-book participant guides and SAP Certified Hard copy participant guides

This 3 day instructor led course qualifies for 24 CPE Credits. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations. CPE Credits are not available for virtual live classroom sessions.

With virtual live classroom training you get comprehensive training from SAP experts using seamless over-the Web connectivity. The same content delivered in SAP's traditional "brick and mortar" classrooms is presented during virtual live classroom deliveries. As in SAP's traditional classrooms, SAP virtual live classroom stresses hands-on learning providing each registered student with exclusive access to live SAP systems throughout each course. Each Virtual Live class is taught by a SAP Certified Instructor and will include an e-book student guide for you to download and keep. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations. CPE Credits are not available for virtual live classroom sessions.