DB2 Overview

Duration

2 to 3 hours

Overview

Audience

Personnel requiring an introduction to DB2.

Prerequisites

Basic knowledge of Data Processing concepts.

Objectives

After completing this course, the student will be able to:
• Define the concepts of DB2
• Define the basics of SQL
• Identify how to start and stop the system
• Identify how to monitor and restart the system

Course Content

Overview of DB2

Introduction, DB2, SQL
Tables
Security
Availability and Recoverability

Overview of Structured Query Language (SQL)

Command Syntax of Common SQL Statements

DB2 Operations

Starting/ Stopping DB2 Subsystem
Entering Commands to DB2
Monitoring DB2 Subsystem

DB2 Recovery and Restart Facilities

Log and Boot Start Data Set
Termination and Restart of the DB2 System
Case Examples of DB2 Failures

Accessing DB2 Using SPUFI

Execution from TSO