Themis Inc. - DB2 LUW Administration Training Class/Course from Themis

DESCRIPTION (Return to Top)
This course is designed to review the concepts and components of DB2 version 9.5 for LINUX, UNIX and Windows. This course has 3 major sections: basic administration, advanced recovery and performance and tuning. 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 and large objects 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. Performance and tuning issues will be reviewed and applied in workshops.

AUDIENCE (Return to Top)

Database administrators.

OBJECTIVES (Return to Top)

After completing this course the student should be able to:

Understand the basic concepts and facilities of DB2.
Create instances, databases and relational objects to support application development and user data access.
Understand row compression and range partitioning on tables to improve performance
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 and gather snapshot information for analysis.
Know how the DB2 Optimizer can be influenced to aid performance.
Use performance enhancing techniques for supporting applications.
Use EXPLAIN tools and techniques to improve SQL performance
Alter the configuration of DB2 to improve performance

TOPICS (Return to Top)

The DB2 Family
Getting started with DB2 (INSTANCES)
DB2 and GUI
Creating databases and tablespaces
Creating Tables and other objects
TRIGGERS, UDT and UDF
DB2 LOCKING
DB2 Security
DB2 Data Management
IMPORT/EXPORT/LOAD utilities
Basic Database Recovery
Disaster Recovery for tables and tablespaces
Incremental backup and recovery techniques
Data Access Techniques
The DB2 Optimizer
DB2 Operational Model
DB2 Configuration Parameters

PREREQUISITES (Return to Top)

Relevant Operating Systems experience (UNIX, LINUX or Windows). Knowledge of relational database theory and SQL. Previous experience of using DB2 or another relational database is recommended.