WA1674 DB2 Administration for Linux, Unix and Windows Training and Courseware

This course is designed to review the concepts and components of DB2 version 9 for Linux, UNIX and Windows. DB2 commands and SQL will be used to focus on DB2 administration activities. The relationships between object components will be presented along with communication and security aspects. Design issues of referential Integrity, table check constraints, user defined data types and functions, triggers, large objects and MDC will be reviewed. Program design issues will be considered which effect concurrency, integrity and performance. DB2 administration functions and utilities will be reviewed and applied in workshops.
What you will learn

At the end of this course, students will be able to:

  • Create instances, databases and relational objects to support application development and user data access.
  • Use IMPORT, EXPORT and LOAD utilities to manipulate data.
  • Perform basic and advanced database and tablespace recovery.
  • Understand the basic security features of DB2.
  • Understand and control the locking behaviour of DB2.
  • Know methods of supporting application development.
  • Use advanced features for REORG, RUNSTATS and LOAD utilities.
  • Know performance enhancing techniques for utilities.
  • Use EXPLAIN tools and techniques.
  • Review Multi-Dimensional Clustering (MDC).
  • Alter the configuration of DB2 to enable automatic maintenance of DB2 tables.
Audience
Database administrators
 
Prerequisites
  • Relevant Operating Systems experience (Linux, UNIX or Windows).
  • Knowledge of relational database theory and SQL.
  • Previous experience of using DB2 is recommended.
 
Duration
Five days.
More Information
Schedule this course
Course Outline
Download this page as a word document
Learn more about the courseware