Manta alt

YOUR IBM i TRAINING SOURCE

You must allow the browser to execute JavaScript programs if you want to view product information. If your browser is set up to execute JavaScript programs, the problem is that the product ID was incorrect. Use the menu bar above to find the desired product.

Overview

This course introduces you to DB2, the relational database management system that is part of every IBM i computer system. The course begins by describing basic database concepts, focusing in particular on relational databases. It then describes the DB2 implementation of a relational database. The course provides a detailed description of physical files, logical files, and the products and tools that are used with a DB2 database. It ends with a description of the tools and products that are used in a distributed database environment.

Approximate Study Time: 90 minutes

Objectives

After completing this course, you should be able to:

  • Identify the advantages database management systems offer over a traditional file system
  • Describe the structure of a relational database and use relational database terminology
  • Describe the DB2 implementation of a relational database
  • Name and describe the types of physical files and logical files that IBM i supports
  • Describe the structure of a physical file and a logical file
  • Identify the different ways in which a physical file and a logical file can be defined and created
  • Identify and describe the tools available to a user for accessing a DB2 database
  • Identify and describe the different ways in which an application program can access a DB2 database
  • Describe the processing capabilities in a distributed database environment
  • Describe the functions and capabilities of the various tools and products available for a distributed database environment
  • Identify the function and capabilities of a trigger program

Topic Outline

DB2 Concepts

Physical Files

Logical Files

Accessing a Database

Database Tools and Products

Audience

This course is intended for anyone who will be working with a DB2 database. This audience includes:

  • Programmers and application developers who will be creating DB2 databases and developing applications that process DB2 databases
  • System administrators who will be responsible for managing a DB2 database
  • Managers and other users who will be defining and running database queries

The course is also recommended for anyone who wants to learn DB2 concepts and capabilities.

Prerequisites

This course assumes that you have a basic knowledge of IBM i facilities. You can satisfy this prerequisite by successfully completing the Introduction to the IBM i Environment series.