DB2 for LUW Database Administration and Performance

PT8057
Summary
This course makes your life as a DB2 LUW DBA more productive. Over four days, this course covers the roles of the DBA and the activities that are important to the success of DB2. A special emphasis is placed on performance topics. This class uses hands-on and paper exercises to reinforce the topics covered. This class is current to DB2 10.5.NOTE: The outline below contains more information than is possible to cover in 4 days. This is done to allow customization to meet your needs. It is possible to teach about 28 hours of topics within 4 days. Some chapters do depend on others, and some topics provide additional detail. Questions regarding your requirements are welcome to provide the best possible training experience.
Prerequisites
There are no prerequisites for this course
Duration
4 Days/Lecture & Lab
Audience
Database Administrators and System Administrators
Topics
  • Object Management
  • Logical To Physical Transformation
  • Key System Parameters
  • Buffer Pool Optimization
  • Table Spaces & Partitioning
  • Utilities
  • Index Design
  • Access Path Selection
  • Evaluating SQL Performance
  • Advanced access paths topics
  • Concurrency Control
  • Security
  • Backup and Recovery
  • Getting Around in Linux

Related Scheduled Courses