DB2 Overview

Duration

2 - 3 hours

Overview

Audience

Computer personnel needing an introduction and overview to DB2

Prerequisites

Basic understanding of Data Processing concepts

Objectives

After completing this course, the student should be able to -
  • Understand the concepts of DB2
  • Understand the basics of SQL
  • Stop/Start the system
  • Monitor and Restart the system

Course Content

Module 1 OVERVIEW OF DB2

  • Introduction, DB2, SQL
  • Tables
  • Security
  • Availability and Recoverability

Module 2 OVERVIEW OF STRUCTURED QUERY LANGUAGE

  • Execution from TSO
  • Command Syntax of Common SQL Statements

Module 3 DB2 OPERATIONS

  • Starting/ Stopping DB2 Subsystem
  • Entering Commands To DB2
  • Monitoring DB2 Subsystem

Module 4 DB2 RECOVERY AND RESTART FACILITIES

  • Log and Bootstart Data Set
  • Termination and Restart of the DB2 System
  • Case Examples of DB2 Failures
 
© Copyright 2007. All rights reserved. Interskill Learning, Inc.