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

  This course can be requested in your area here.

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.

  • 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

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.


Copyright © 2018 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media