- Home
- Catalog
- Courses
- Database Curriculum
- Managing DB2 Operations
Managing DB2 Operations
Duration
3 to 4 hours
Overview
Audience
Operations staff responsible for monitoring and managing DB2.
Prerequisites
Basic knowledge of Data Processing concepts
Completion of the DB2 Overview 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 ImplementationDB2 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 AttributesStarting 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 ScenariosGathering 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 770-872-4278
