DB2 UDB for iSeries Fundamentals (OL45)

Format

Classroom

Duration

2.0 Day(s)

Description

DB2 UDB for iSeries is one of our industry's best kept secrets. In this course, we will examine how it is implemented and integrated into the architecture of the iSeries. You will learn about its many functions and features.
This course will also introduce you to Structured Query Language (SQL) and Operations Navigator.

Audience

Database administrators and application programmers who need to manage or implement an iSeries database.
The typical attendee will have had experience with IBM's DB2 on another platform or another relational database

Prerequisites

At a minimum, you should have a general background in information processing and be familiar with database concepts.
A broad level of experience in database products will enhance the benefit that you will obtain from this class.

Objectives

After completing this course, the student should be able to:
* List four iSeries Database Objects
* Use both DB2 UDB SQL and Native terminology to describe objects and operations
* Describe the use of Referential Integrity and Triggers
* State four ways that SQL can be used in programs
* Describe the process to create DB2 UDB objects
* Use Interactive SQL and Operations Navigator to create basic DB2 UDB objects
* List two performance tools that can be used to improve DB2 UDB performance
* Explain the role of the Database Administrator
* Explain the purpose of journaling and commitment control
* Explain the considerations of Distributed Data