Home About Courses Schedule Services Webinars Contact Search

Db2 for LUW Database Administration

SEE SCHEDULE

Duration: 4 Days

Method: Instructor led, Hands-on workshops

Price: $2450.00

Course Code: DB3016



Audience

Database Administrators and System Administrators.

Description

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. Extra time is spent on performance topics. This class uses hands-on and paper exercises to reinforce the topics covered.

Prerequisites

Intended for people wanting DBA knowledge or DBAs with experience on another DBMS.

Topics

  1. Object Management
    • Types of objects and their relationships
    • Test and production
    • Alter and migration
  2. Utilities
    • Loading and moving data
    • Reorganizing tables and indexes
    • RUNSTATS
    • Integrity checking
  3. Key System Parameters
    • Heaps, Servers, and Thresholds
    • Optimizing Sort performance
    • Using the snapshot monitor for system monitoring
  4. Buffer Pool Optimization Techniques
    • Types of physical I/O
    • A buffer pool tuning methodology
    • Number and size of buffer pools
    • Object placement
  5. Table Spaces Design
    • DMS, SMS & Automatic storage
    • Table design
    • Data compression
  6. Index Design
    • Index structure and MDC indexes
    • When to use indexes
    • Index redesign
  7. Access Path Selection
    • Types of access paths
    • Range delimiting and sargable predicates
    • Factors used in access path selection
    • Db2 catalog statistics used
    • Join methods and subselects
  8. Evaluating SQL Performance
    • Explain tables, db2expln, db2exfmt
    • Monitoring using Db2 catalog information
    • Design Advisor
    • Event Monitors
  9. Security
    • Interfaces to OS security
    • Security administration
  10. Backup and Recovery
    • Recovery concepts
    • Backup strategies
    • Recovery planning
    • HADR