Web Age Solutions Inc
Providing Technology Training and Mentoring For Modern Technology Adoption
Web Age Aniversary Logo
US Inquiries / 1.877.517.6540
Canadian Inquiries / 1.877.812.8887
Course #:WA1342

DB2 UDB Administration for Unix and Windows II Training

This course is designed to review the concepts and components of DB2 for UNIX and/or Windows. 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. Program design issues will be considered which effect concurrency, integrity and performance. DB2 administration functions and utilities will be reviewed and applied in workshops.

  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
  • Relevant Operating Systems experience (AIX or Windows).
  • Knowledge of relational database theory and SQL.
  • Previous experience of using DB2 is recommended.
  Three days.

Outline of DB2 UDB Administration for Unix and Windows II Training

Day 1

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

Day 2

  • Creating Tables and other objects
  • DB2 Security

Day 3

  • DB2 Utilities
  • IMPORT/EXPORT/LOAD utilities
  • Database Recovery
  • Performance for Applications
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
US Inquiries / 1.877.517.6540
Canadian Inquiries / 1.877.812.8887