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

Catalog Home Databases, Business Intelligence & Data Science Db2 for LUW

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

  Add Course to watch list
  View full course outline
  Request in your area

There are no scheduled dates for this course.

  Available by Request

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.

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.

4 Days/Lecture & Lab

This course is designed for database administrators.

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)
  • Db2 Security
  • Basic Database Recovery
  • Disaster Recovery for Tables and Table Spaces
  • Incremental Backup and Recovery Techniques

Copyright © 2018 ProTech. All Rights Reserved.

Sign In Create Account


Social Media