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

Duration: 5 days

Description 
Learn how to administer an IBM DB2 UDB. Take a fast path to advanced DB2 UDB administration skills for experienced database administrators on other relational database management systems, such as Oracle, Informix, Sybase, and DB2 for OS/390. Labs include using the Graphical User Interface (GUI) Control Center on a Windows operating system. The Control Center is common across all platforms and is applicable to all DB2 UDB server environments.

Topics

  • Understanding the DB2 UDB architecture
  • Utilizing DB2 UDB GUI Tools
  • Databases and Tablespaces
  • Administration of DB2 objects
  • File allocation with SMS and DMS
  • DB2 catalog tables
  • Fundamentals of Backup and Recovery
  • Monitoring and problem determination
  • Application performance
  • Security
  • Remote administration
  • Exploiting parallelism and SMP enablement
  • Advanced load and utility topics
  • Advanced tools
  • Referential integrity (Primary and foreign keys)
  • Data management
  • Loading and unloading data
  • Reorganizing data
  • Stored Procedures and Stored Procedure Builder
  • User-Defined Functions
  • Database Triggers
  • Visual Explain and Efficiency Considerations
  • Database tuning
  • Application tuning
  • Data Security

Prerequisites

  • Trubix’s IBM DB2 UDB Administration 1 course
  • Skilled DBA with IBM DB2 UDB database


 
 
 

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