Objectives:
  After completing this course the student should be able to:
  • Understand the basic concepts and facilities of DB2.
  • Create instances, databases and relational objects to support application development and user data access.
  • Use IMPORT, EXPORT and LOAD utilities to manipulate data.
  • Perform database and tablespace recovery
  • Understand the basic security features of DB2.
  • Understand and control the locking behaviour of DB2
  • Know performance enhancing techniques for supporting applications.
Target Audience:
  Database administrators
Prerequisite:
 
  • Relevant Operating Systems experience (AIX or Windows).
  • Knowledge of relational database theory and SQL.
  • Previous experience of using DB2 is recommended.
Duration:
  Three days.

Outline for DB2 UDB Administration for Unix and Windows II

Day 1

  • The DB2 Family
  • Getting started with DB2 (INSTANCES)
  • Creating databases and tablespaces

Day 2

  • Creating Tables and other objects
  • TRIGGERS, UDT and UDF
  • DB2 LOCKING
  • DB2 Security

Day 3

  • DB2 Utilities
  • IMPORT/EXPORT/LOAD utilities
  • Database Recovery
  • Performance for Applications