DB2 for LUW: Introduction & Fundamentals

This course introduces and explains the fundamental principles of the Db2 for Linux, UNIX and Windows family of products. The course focuses on the relational theory and concepts, and how Db2 adheres to them. It also introduces the basic concepts of DB2 data storage, SQL, Db2 utilities, and the use of Db2 Interactive (Db2i) and the relevant centres.

Delegates will learn how to 

·         describe the relational theory and concepts

·         list the objects used to store Db2 data

·         understand the use of Structured Query Language

·         describe the functions available with Db2 Interactive (Db2i)

·         list the utility jobs available for Db2.    


All IT professionals who need to understand the full range of the Db2 for LUW family of products.

Overview of DB2 for Linux, UNIX and Windows

Command Line Processor (CLP) and GUI Usage

The DB2 Environment

Creating Databases and Data Placement

Creating Database Objects

Moving Data

Backup and Recovery

Locks and Concurrency

Database Maintenance, Monitoring and Problem Determination


Database Rebuild Support

DB2 Database and Table Space Relocation

Using Explain Tools

Using Indexes for Performance

Advanced Monitoring

A basic understanding of IT, with some exposure to database technology as a user.

Program Details
Duration 2 Days
Capacity Max 12 Persons
Training Type Classroom / Virtual Classroom

Can't find what you're looking for? Let us know if you have a query or cannot find what you are looking for.