Course Description
This course provides students with the knowledge and skills they need to perform the routine tasks of a DB2 Universal Database Systems Administrator. Through instructor presentations, they will learn about the tools and commands needed to configure and maintain instances and database objects. Through lab exercises, students will have the opportunity to practice the skills they've learned in a simulated database server environment.

Class Length
5 days

Objectives

• Configure and maintain DB2 instances.
• Manipulate databases and database objects.
• Optimise placement of data.
• Control user access to instances and databases.
• Implement security on instances and databases.
• Use DB2 activity monitoring utilities.
• Use DB2 data movement and reorganisation utilities.
• Develop and implement Database recovery strategy.
• Interpret basic information in the db2diag.log file.

Who will benefit from this course
Application developers, database and systems administrators, and technical support personnel.

Prerequisites

• Some experience with writing Structured Query Language scripts
• Knowledge of relational database design concepts
• Knowledge of UNIX operating system fundamentals and VI editor
• Knowledge of Windows GUI navigation skills.