Datatrain
Partners
Login
  Username
  Password
  Partner Login
 
Forgot Password?
Register Now!
Partners
Interskill Mainframe Training Newsletter - April ´17
Interskill Mainframe Training Newsletter - August ´16
Interskill Mainframe Training Newsletter - June ´15
Past Issues

Partners
Mainframe Links
Mainframe Facts - Did you know?



DidYouKnow


More facts...

Course Catalog » Database Curriculum » DB2 Operations Series V11

Managing DB2 Operations V11

Duration
4 hours

Overview

Description

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

Course Catalog » Database Curriculum » DB2 Operations Series V11
 
 
 
  © All rights reserved. Interskill Learning Pty Ltd.
website designed & developed by blueapple
  HomeAbout UsProductsDemonstrationCourse CatalogDistributorsSite Map
    AOL Logo Interskill IBM