Seminar - Cegos Integrata GmbH
Overview
This course provides learners with a comprehensive exploration of advanced techniques for managing and recovering data in Db2 12.1 environments. It begins with methods for efficiently moving and loading data, enabling database administrators to migrate schemas, relocate data, and integrate with external sources while maintaining system stability.
The course covers advanced backup and recovery strategies, from incremental backups and redirected restores to dropped table recovery and logical backups. Learners will also explore Db2 features that support high availability and disaster recovery, as well as specialized tools such as split mirror technology and the Db2 Advanced Recovery Feature.
Through a series of hands-on exercises, learners will practice applying these advanced techniques in real-world scenarios. Activities include using the LOAD utility with advanced options, moving data between databases with db2move and schema copy procedures, executing redirected restores, and recovering dropped tables. Participants will also gain practical experience with database maintenance tasks such as running RUNSTATS, reorganizing tables and indexes with REORG, and applying autonomic features to automate recurring maintenance operations.
By the end of this course, learners will be able to confidently manage complex data movement, implement robust backup and recovery procedures, and use Db2’s autonomic featur...
| Termin | Ort | Preis* |
|---|---|---|
| firmenintern | auf Anfrage | auf Anfrage |
Course Outline
Unit 1: Data Movement and Loading
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 experienced database administrators, system administrators, and technical professionals who manage Db2 environments and need to expand their expertise in advanced data movement, backup, recovery, and maintenance. It is also suitable for application developers and data engineers who work closely with Db2 databases and want to strengthen their understanding of utilities, schema handling, and performance optimization.
