IBM Db2 12.1: Advanced Data Management and Recovery for Relational DBAs

Course overview

Learn advanced Db2 12.1 skills in data movement, backup, recovery, and maintenance with hands-on practice to optimize performance and protect enterprise databases.

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 features to sustain database performance and availability. They will be equipped with the expertise needed to reduce downtime, optimize efficiency, and safeguard critical enterprise data in advanced Db2 deployments.

Who should attend

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.

Prerequisites

Participants should have the following: • Completion of CLA90G/2LA90G: IBM Db2 12.1 Essentials for Relational DBAs or equivalent knowledge • Completion of course CLA91G/2LA91G: Data Management and Recovery for Relational DBAs • Prior experience with Db2 database administration • Familiarity with Db2 utilities such as BACKUP, RESTORE, LOAD, and RUNSTATS • Working knowledge of SQL and database objects (tables, indexes, and schemas) • Basic understanding of database recovery concepts • Hands-on practice in managing Db2 environments

Delivery formats

• • Instructor-led online (virtual classroom)
• • Instructor-led on-site at your premises
• • Self-paced online training
• • Private/closed group delivery for corporate teams

Digital badge

Delegates completing this course are eligible for an IBM digital badge, issued via Credly. View the badge

Related and follow-on courses

• 0A069G — IBM SPSS Modeler Foundations (V18.2) (Basic)
• 0A079G — Introduction to Machine Learning Models Using IBM SPSS Modeler (V18.2) (Basic)
• 0G51BG — Statistical Analysis Using IBM SPSS Statistics (V26) (Intermediate)
• 0G53BG — IBM SPSS Statistics Essentials (V26) (Basic)