Db2 Administration for Linux, Unix and Windows v 10.x

PT0129
Training Summary
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.
Prerequisites
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.
Duration
4 Days/Lecture & Lab
Audience
This course is designed for database administrators.
Course Topics
The Db2 Family
  • Getting Started with Db2 (INSTANCES)
  • Db2 and GUI
  • Creating Databases and Table Spaces
  • Creating Tables and Other Objects
  • Column Organized Tables (BLU Acceleration)
  • TRIGGERS, UDT and UDF
  • Db2 LOCKING
  • Db2 Security
  • IMPORT/EXPORT/LOAD Utilities
  • Basic Database Recovery
  • Disaster Recovery for Tables and Table Spaces
  • Incremental Backup and Recovery Techniques

Related Scheduled Courses