Administration training for
IBM Db2 12
on AIX and Linux
Hands-on SIXE training for Db2 12 production administration: deployment, backup, security, performance and the new Pacemaker-based high availability. On-site or remote, in English, Spanish and French.
Companies that trust SIXE
Db2 administration has changed with version 12
IBM retired version 10 — the basis of the classic CL2X3G course — and between 11.5 and 12.1 introduced over 200 changes that directly affect a DBA's daily work.
The most significant for anyone running Db2 on Linux: Pacemaker replaces Tivoli SA MP (TSAMP) as the cluster manager for high availability. Training on v10 materials means learning procedures that no longer exist.
This course starts from scratch on Db2 12 and focuses on what you actually manage on AIX and Linux.
Db2 LUW stands for Linux, UNIX and Windows — the engine is the same across all three platforms. This course is delivered and practised on AIX and Linux, the environments where our clients' critical workloads run.
What your team will be able to do
Every module translates into a concrete skill your team applies from day one.
What Db2 12 brings that your team will need to manage
The open-source cluster manager that replaces TSAMP: faster failure recovery and simpler HADR operations.
Isolates sets of tables within a single database for better segmentation and governance.
Native embeddings and similarity search in SQL — the foundation for AI use cases without a separate vector store.
Federated access to Snowflake, Oracle 23ai, MariaDB, MongoDB and SAP directly from Db2.
Multiple threads per tablespace for faster backups and asynchronous history file maintenance.
Online schema evolution with DROP and RENAME, and table moves with zero downtime.
Four phases, from deployment to optimisation
Course content
Eight modules built around what a DBA actually does. Each one describes what you will learn to manage.
Deploying Db2 12 on AIX and Linux, managing instances and initial environment setup.
Automatic storage, tablespaces, table partitioning and capacity planning.
Backup strategies, recovery, rollforward and designing a reliable backup policy.
Authentication, authorisation, trusted contexts and data encryption at rest and in transit.
Monitoring capabilities, problem diagnosis and query tuning techniques.
Configuring HADR with Pacemaker, synchronisation modes and automated failover.
Columnar tables for analytics, online schema maintenance and data movement with zero downtime.
Load and export, reorganisation, statistics collection and the day-to-day command-line toolkit.
What the course includes
Labs on real environments
Guided practice on real AIX and Linux systems — not slides. You deploy, break and recover.
Reference documentation
Key DBA reference guides for use after the course.
Certificate and digital badge
SIXE certificate of completion and a verifiable Credly badge for your LinkedIn profile.
Direct access to the instructor
Questions answered during the course by consultants who run Db2 in real projects.
Who this course is for
Database administrators
DBAs running Db2 on AIX or Linux who want to master version 12 properly.
Systems teams
Systems administrators who support Db2 environments and need to understand backup, HADR and performance.
Teams upgrading to v12
Organisations moving from Db2 10 or 11 that need a clear path to version 12.
Recommended prerequisite: basic AIX or Linux administration and SQL knowledge. No prior Db2 experience required — if your team already has it, we adjust the pace and go deeper into v12 changes.
Training delivered by consultants who work with Db2
Our instructors are IBM Champions
The IBM Champion designation recognises deep technical expertise and sustained contribution to the IBM community. Your team learns from professionals who run Db2 day in, day out on real projects.
Need active-active high availability?
When your Db2 must stay online and scale horizontally, this course is the foundation — the pureScale course is the next step.
Db2 pureScale: deployment and administration
Multiple Db2 instances sharing a filesystem via IBM Storage Scale (GPFS) in active-active mode. IBM's answer to Oracle RAC, end to end.
View the pureScale courseLUW + pureScale in a single course
If your team needs both, we design a tailored combined track — Db2 12 administration plus pureScale — optimising schedule and budget.
Request the combined trackBefore enrolling your team
Does this replace the CL2X3G course?
CL2X3G covered Db2 10, a version IBM has since retired. This course is SIXE's own update to Db2 12, with current content and tooling, focused on AIX and Linux.Does it cover version 12 changes?
Is the course remote or on-site?
What prior knowledge does the team need?
Does it also apply to Db2 on Windows?
What if we also need pureScale?
Get your team up to speed on Db2 12
We put together a proposal with syllabus, format and dates, tailored to your team's level and your AIX or Linux environment.
Blog!
Our mission
SIXE ensures that your infrastructures based on IBM®, Red Hat®, Canonical®, and SUSE® technologies remain stable, secure, and optimized for as long as you need them.
At SIXE, we are committed to sustainability. That’s why we help you design, implement, and maintain durable and efficient technological solutions.
