Return to Catalog Home     Return to Curriculum Listing

Db2 13 – Managing Db2 Operations on z/OS

Duration

4 hours

Overview

The Db2 13 – Managing Db2 Operations on z/OS 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. You will be introduced to Db2 stored procedures on z/OS, and see how they are created and managed.

Audience

Operations staff responsible for monitoring and managing Db2.

Prerequisites

Basic knowledge of data processing concepts and successful completion of the Db2 13 – Db2 Fundamentals course, or equivalent knowledge.

Objectives

After completing this course, the student should 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
• Create a stored procedure on z/OS

Course Content

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
Controlling Log Activity
Terminating Utilities

Introducing Db2 Stored Procedures on z/OS

The Need for Db2 Stored Procedures
Internal and External Stored Procedures
Supplied Stored Procedures
Autonomous Procedures
Creating Db2 Stored Procedures
CREATE Options
Maintaining and Controlling Db2 Stored Procedures

Search our catalog