Interskill Learning Mainframe Training

American English British English Brazilian Portuguese French German Italian Russian Spanish (European) Spanish (Latin American)
+44 (0) 1625 441120

The Online Mainframe Training Specialists
Search   Course Catalog   Live Chat!  
Return to Catalog Home     Return to Curriculum Listing

Managing DB2 Operations v11

Duration

4 hours

Overview

The Managing DB2 Operations course looks at DB2 from an Operations viewpoint, describing DB2 startup and shutdown, common operator tasks, message interpretation and restart and recovery considerations. A number of commands used to analyze the status of DB2 components are discussed as well as the facilities associated with backup, recovery and restart.

Audience

Operations staff responsible for monitoring and managing DB2.

Prerequisites

Basic knowledge of Data Processing concepts. Completion of the DB2 Fundamentals course, or equivalent knowledge

Objectives

After completing this course, the student will be able to:

  • Define the general DB2 tasks performed by the Operator
  • Identify how to start and stop the DB2 subsystem
  • Display DB2 status and attributes
  • Identify how to backup, recover and restart the DB2 subsystem

Course Content

General DB2 Operations

Understanding DB2 Implementation
DB2 Startup Parameters
Common Operator Tasks
Entering DB2 Operator Commands
Interpreting DB2 Messages
Starting and Stopping DB2
DB2 Restart and Recovery Overview

Monitoring and Resolving DB2 Operational Problems

Displaying Database Status and Attributes
Starting and Stopping a Database
Displaying Buffer Pool Status
Displaying Utility Activity
Displaying Log Status
Displaying the Status of Threads
Canceling Threads
Modifying Log Defaults
Terminating Utilities

Identifying and Resolving DB2 System Problems

DB2 Problem Scenarios
Gathering Data for Problem Diagnosis
Running DB2 Dumps
Starting and Stopping DB2 Traces
DB2 Backup
DB2 Recovery Processes

Managing DB2 Operations Mastery Test

Looking for more information about Interskill Learning Products?
Contact our Learning Consultants or call us at +44 (0) 1625 441120