Seminar - Cegos Integrata GmbH
Overview
This course provides a detailed exploration of essential data management, recovery, and maintenance techniques for IBM Db2 12.1 database administrators. Learners will gain the skills necessary to manage data movement, implement robust backup and recovery strategies, and monitor and maintain database performance in enterprise environments.
This course covers how to move and load data efficiently using SQL commands, the LOAD, IMPORT, and INGEST utilities, and procedures like ADMIN_MOVE_TABLE. The course then shifts focus to recovery operations, covering crash recovery, version recovery, roll-forward recovery, and the configuration of logging and backup policies, including high availability through HADR. In the final unit, learners will explore tools and commands for ongoing maintenance and performance tuning, including RUNSTATS, REORG, REORGCHK, event monitors, the Db2 Design Advisor, and diagnostic utilities such as db2diag, db2fodc, and db2trc.
Through a series of hands-on exercises, learners will practice loading and reorganizing large datasets using Db2 utilities, configuring and executing backup and recovery operations, analyzing system health and performance using monitoring functions, and capturing and interpreting diagnostic data for problem determination.
By the end of this course, learners will be proficient in managing data movement, implementing recovery procedures, optimizing performance, and diagnosing operati...
| Termin | Ort | Preis* |
|---|---|---|
| firmenintern | auf Anfrage | auf Anfrage |
Course Outline
Course Introduction
Unit 1: Data Movement and Loading Fundamentals
Unit 2: Backup and Recovery
Unit 3: Database Maintenance, Monitoring, and Problem Determination
Objective
After completing this course, learners should be able to:
Prerequisites
Participants should have the following:
Audience
This course is intended for relational database administrators (DBAs), system administrators, and technical support personnel responsible for managing, maintaining, and recovering IBM Db2 12.1 databases.
