Description
Course information
IBM code: CLA90G
Category: IBM Db2 / Administration
Modality: Online and Presential
Duration: 2 days
Level: Basic-Intermediate
Certification: IBM Official
Who is it aimed at?
This course is specially designed for:
- Database administrators starting their career or changing technology
- System administrators who need to manage Db2 environments
- Developers working with IBM Db2 databases
- IT professionals looking for data management specialization
- Technical consultants implementing Db2-based solutions
Prerequisites
To get the most out of this training, participants should have:
- Basic knowledge of relational database concepts
- Familiarity with operating systems (Linux/Unix/Windows)
- No previous experience with Db2 required – perfect for beginners
Learning objectives
At the end of this course, participants will be able to:
- Compare features and use cases of different editions of Db2
- Explain Db2 versioning model and manage Mod Packs, Fix Packs and Service Builds
- Using the Command Line Processor (CLP) to execute SQL and system commands
- Create, configure and manage Db2 instances using command line and GUI tools
- Configuring database parameters with commands such as GET/UPDATE/RESET DB CFG
- Creating and managing database objects: schemas, tables, indexes, views and triggers
- Implement external tables for data loading from various sources
- Executing maintenance utilities: EXPORT, IMPORT, RUNSTATS, REORG
- Perform backup, restore and recovery operations to ensure data availability.
- Apply troubleshooting techniques using diagnostic logs and system views
Complete syllabus
Module 1: Introduction to IBM Db2 12.1
- Db2 architecture and main components
- Product editions: features and limitations
- Versioning model and update strategies
- Appropriate use cases for each edition
Module 2: Installation and configuration
- Preparation of the environment and system requirements
- Step-by-step installation process
- Creation and configuration of Db2 instances
- Initial configuration and validation
Module 3: Management tools
- Command Line Processor (CLP): advanced usage
- Data Management Console and GUI tools
- Command line utilities for administrative tasks
- Integration with development tools
Module 4: Database management
- Database creation and configuration
- Storage management and tablespaces
Module 5: Database objects
- Creation and management of schemas, tables and indexes
- Implementation of views, aliases and triggers
- Referential integrity and constraint management
- External tables for various data sources
Module 6: Maintenance and optimization
- EXPORT and IMPORT utilities for data management
- RUNSTATS for query optimization
- REORG for performance maintenance
- Proactive optimization strategies
Module 7: Backup and recovery
- Backup strategies: full, incremental and delta backups
- Disaster recovery planning
Module 8: Troubleshooting and diagnostics
- Analysis of diagnostic logs
- Use of system views for monitoring
- Identification and resolution of common problems
- Advanced diagnostic tools
Practical methodology
Our hands-on approach ensures that each theoretical concept is reinforced with real-world practical exercises. Participants will work in labs that include:
- Complete Db2 installation from scratch
- Creation of databases with customized configuration
- Implementation of complex objects with dependencies
- Execution of maintenance utilities in real time
- Simulation of failures and recovery procedures
- Performance analysis and query optimization
Our differential value
At SIXE we don’t just teach Db2, we train complete administrators. Our certified instructors provide:
- Real-world experience in enterprise implementations
- Case studies based on real projects
- Best practices developed in the field
- Documentation updated with the latest versions
- Post-course support to resolve doubts
Training modalities
Online training
Interactive sessions with remote labs and full access to Db2 environments. Ideal for professionals looking for flexibility without sacrificing quality.
On-site training
Immersive experience in our specialized classrooms with dedicated equipment. Available in multiple cities:
Spain: Madrid, Barcelona, Valencia, Seville, Bilbao, Malaga
Latin America: Mexico City, Buenos Aires, Bogota, Santiago, Lima, Quito, and more
Latin America: Mexico City, Buenos Aires, Bogota, Santiago, Lima, Quito, and more
Start your career as a DBA Db2 Certified DBA
Don’t miss the opportunity to master one of the most powerful databases on the market. With limited places to guarantee personalized attention, we assure you an exceptional learning experience.
