back to Course Categories | back | print
IBM DB2 UDB Database Administration I          

Duration: 5 days

Description 
This course will teach the core skills necessary to to manage a DB2/UDB database. An emphasis is placed on understanding the DB2/UDB architecture and good practices for a Universal Database Systems Administrator. Through instructor presentations, attendees 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.

Topics

  • Understanding the DB2/UDB architecture
  • Major DB2 components overview
  • Instance Creation
  • Managing Data Bases, Storage Groups, Tablespaces, Tables, Indexes, and Views
  • Synonyms, and Aliases online
  • Creating Indexes
  • Using Constraints
  • Introduction to GUI tools
  • Optimize placement of data
  • Control user access on instances and database
  • Use DB2 activity monitoring utilities
  • Use DB2 data movement and reorganization utilities
  • Interpret basic information in the db2diag.log file
  • Locking and Concurrency
  • Data Maintenance Utilities
  • Performance Monitoring
  • Security

Prerequisites

  • Some experience with SQL
  • Relational Database Design Knowledge
  • UNIX Operating System Knowledge
  • Windows Operating System Knowledge


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design