Description
For over 15 years, SIXE has been delivering IBM training worldwide. Get the best instruction from our specialists across Europe and Latin America.
→ View the full course page with detailed syllabus and format options
Course details
| SIXE code: SXDB2AL01 | Category: DB2 / Db2 12.1 LUW |
| Delivery: On-site and remote | Duration: 4 days |
| Release: Db2 12.1 (mod pack 12.1.5) | Labs: Real AIX and Linux environments |
| Languages: English, Spanish and French | Replaces: CL2X3G / CL2X3GES (retired) |
Who this course is for
System administrators, database administrators (DBAs) and technical staff who manage or will manage Db2 on AIX or Linux in production environments.
Prerequisites:
- Basic AIX or Linux skills: shell, permissions and filesystem
- SQL knowledge: DDL, DML and authorisation statements
- Basic relational concepts: tables, indexes, views and joins
What your team will learn
On completing the course, participants will be able to:
- Install and configure Db2 12.1 instances and databases on AIX and Linux
- Design storage for performance and growth
- Create and manage the objects that make up a well-designed database
- Move data efficiently, choosing the right tool for each scenario
- Define a backup strategy and recover to a point in time
- Configure high availability and automate failover
- Monitor the engine and diagnose performance issues with confidence
- Manage concurrency across users without unnecessary blocking
- Configure security, access control and data encryption
Course structure
Four days following a progressive arc. Each day builds on the previous one and ends with hands-on labs on real environments.
Day 1 — Environment and databases
Db2 12.1 installation, administration tools, instance and database creation, and storage design.
Day 2 — Objects and data movement
Schema design, tables, indexes, constraints, partitioning, temporal and columnar tables. Loading and unloading data with different strategies depending on volume and availability requirements.
Day 3 — Recovery and monitoring
Logging strategies, backup and point-in-time recovery. High availability with HADR and automated failover. Maintenance, engine monitoring and problem diagnosis.
Day 4 — Concurrency and security
Locking, isolation levels and contention resolution. Security model: authentication, authorisations, roles, row and column level access control, encryption and auditing.
Hands-on labs · In-house materials and documentation
Instructors
The vast majority of our courses are delivered directly by our engineers. This is the only way we can guarantee the highest quality. We complement all training with in-house materials and labs, based on our experience during the deployments, migrations and courses we have delivered over the years.
Added value
Our courses are tailored to the role. Beyond commands and tasks, we focus on solving the problems that arise in the day-to-day work of each team, providing the knowledge and skills required for each project. Our documentation is based on the latest version of each product.
Need to adapt this syllabus to your requirements? Interested in other courses? Get in touch.
On-site delivery locations
- Spain: Madrid, Seville, Valencia, Barcelona, Bilbao, Málaga, Canary Islands, Balearic Islands
- Latin America: Mexico City, Bogotá, Lima, Quito, Buenos Aires, Santiago de Chile, San José and Montevideo
- Africa: Equatorial Guinea (Malabo)
- Online: Anywhere else
