This course is designed to review the concepts and components of DB2 UDB for 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.

LEARNING OBJECTIVES

After completing this course the student will be able to:

• Explain DB2 UDB for Windows concepts and facilities
• List and describe the components of DB2 UDB for Windows
• Administer a DB2 UDB database system using commands and GUI tools
• Create Instances, Databases, Tablespaces and Tables to support application development and user data access
• Discuss design issues such as referential Integrity, table check constraints, user defined data types and functions, and triggers.
• Use IMPORT, EXPORT and LOAD utilities to manipulate data
• Perform database and tablespace recovery
• Explain DB2 security
• List performance improvement techniques for supporting applications.
• Manage System Managed Storage (SMS) and Database Manage Storage (DMS) databases and understand data placement principles