This course is designed to review the concepts and components of Db2 version 10.5 for LINUX, UNIX, and Windows. This course has two major sections: basic administration and advanced recovery. 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. Application design issues will be considered which effect concurrency, integrity, and performance. Db2 administration functions and utilities will be reviewed and applied in workshops. Snapshot commands and administrative views will be used to gather data. Db2 “BLU Acceleration” via column organized tables will be studied.
4 Days/Lecture & Lab
This course is designed for database administrators.
Before taking this course, students should have relevant operating systems experience (UNIX, LINUX or Windows). Students also need knowledge of relational database theory and SQL. Previous experience of using Db2 or another relational database is recommended.