DB2 Administration for Linux, UNIX and Windows

    

Summary:
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.

Duration:
5 Days/Lecture & Lab

Audience:
This course is designed for database administrators.

Topics:

• The DB2 Family
• Getting started with DB2 (INSTANCES)
• Workshop
• 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:
Students should have relevant operating systems experience (UNIX, LINUX or Windows), and knowledge of relational database theory and SQL. Previous experience of using DB2 or another relational database is recommended.

Last Update: February 10, 2012