IBM Db2 12: Foundation for Relational DBAs

Course overview

This course provides relational DBAs with essential and advanced skills to manage, secure, recover, and optimize IBM Db2 v12.1 environments.

This course provides relational DBAs with essential and advanced skills to manage, secure, recover, and optimize IBM Db2 v12.1 environments. Beginning with foundational concepts, participants will learn how to install Db2, configure instances, manage storage, and create database objects using both command-line and GUI tools. The course then expands into practical techniques for data movement, backup and recovery, and high availability configurations, equipping learners to maintain data integrity and ensure business continuity.

Security and concurrency are addressed in depth, including the implementation of user access controls, role-based permissions, encryption methods, Row and Column Access Control (RCAC), Label-Based Access Control (LBAC), and Trusted Contexts for multi-tiered architectures. Participants will also explore Db2’s locking mechanisms and isolation levels to troubleshoot contention issues and manage concurrent workloads effectively.

Performance tuning and optimization are emphasized through detailed instruction on the query optimizer, indexing strategies, monitoring tools, and the use of EXPLAIN utilities. Learners will leverage the Db2 AI Optimizer, Design Advisor, and Data Management Console to analyze SQL access plans and improve system responsiveness across transactional and analytical workloads.

Through hands-on lab exercises and real-world scenarios, learners will gain the proficiency to manage Db2 environments efficiently and securely, diagnose issues quickly, and ensure high availability and performance in enterprise-scale deployments.

Who should attend

This course is intended for relational database administrators, system administrators, and IT professionals responsible for managing, securing, recovering, and optimizing IBM Db2 v12.1 environments. It is also suitable for security specialists, performance engineers, and support staff who work with Db2 systems in enterprise settings or are preparing for Db2 certification.

Prerequisites

Participants should have the following skills: • Basic knowledge of relational database concepts • Familiarity with operating systems (Linux/Unix/Windows) • Exposure to database administration tasks

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)