IBM Db2 12.1: Data Management and Recovery for Relational DBAs

Course overview

This course provides a detailed exploration of essential data management, recovery, and maintenance techniques for IBM Db2 12.1 database administrators.

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 operational issues in Db2 12.1 databases—ensuring high availability and reliability in production environments.

Who should attend

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.

Prerequisites

Participants should have the following: • Completion of CLA90G: IBM Db2 12.1 Essentials for Relational DBAs or equivalent knowledge • Basic knowledge of relational database concepts • Foundational experience working with Db2 environments • Familiarity with SQL and command-line utilities

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

• 2LA92G — IBM Db2 12.1: Advanced Data Management and Recovery for Relational DBAs (Advanced)
• B6359G — IBM Cognos Analytics: Author Reports Advanced (v11.2) (Advanced)
• 0A069G — IBM SPSS Modeler Foundations (V18.2) (Basic)
• 0A079G — Introduction to Machine Learning Models Using IBM SPSS Modeler (V18.2) (Basic)