Description
Course information
IBM code: CLA96G
Category: IBM Db2 / Advanced Administration
Modality: Online and Presential
Duration: 28 hours (4 intensive days)
Level: Intermediate-Advanced
Certification: IBM Official
Who is it aimed at?
This advanced course is specially designed for:
- Relational database administrators looking to specialize in Db2
- Experienced DBAs migrating from other database platforms
- Data architects who design enterprise solutions with Db2
- System administrators responsible for critical Db2 environments
- Technical consultants implementing Db2 solutions in large organizations
- IT professionals seeking official IBM certification in Db2 administration
Prerequisites
To take full advantage of this advanced training, participants should have:
- Strong knowledge of relational database concepts
- Practical experience in database administration
- Advanced familiarity with Linux/Unix/Windows operating systems
- Previous experience in enterprise database administration tasks.
- Basic knowledge of SQL and stored procedures
Objectives of the course in advanced administration for relational DBAs
At the end of this intensive course, participants will have mastered:
- Complete Db2 lifecycle management: versioning, Mod Packs, Fix Packs and Cumulative Service Builds
- Advanced database configuration:
- Db2 professional utilities: EXPORT, IMPORT, RUNSTATS and REORG for maximum optimization
- Critical load operations: configuration and monitoring
- Enterprise recovery techniques: schema-level logical backup, redirected restore and split-mirror copies
- Proactive maintenance
- Advanced concurrency management: blocking mode analysis and performance impact prediction
- Enterprise security management
- Intelligent optimization: automated statistics profiles and Design Advisor
- Real-time monitoring: SQL table functions and administrative views
Complete training program
Module 1: Architecture and advanced Db2 version management
- Db2 versioning model: enterprise upgrade strategies
- Management of Mod Packs, Fix Packs and Cumulative Service Builds
- Migration planning in production environments
- Best practices for version maintenance
Module 2: Instance Configuration and Administration
- Advanced installation and configuration of Db2 instances
- Storage management and enterprise tablespaces
- Configuration of critical performance parameters
- Command line tools and graphical interfaces
Module 3: Advanced management of database objects
- Creation and optimization of complex schemas, tables and indexes
- Implementation of materialized views and business triggers
- Referential integrity management in distributed environments
- External tables for heterogeneous source integration
Module 4: Advanced Data Movement Techniques
- EXPORT and IMPORT operations for large volumes
- Configuration and monitoring of critical LOAD operations
- Board state evaluation and conflict resolution
- Data migration strategies between environments
Module 5: Backup, recovery and high availability
- Enterprise backup strategies: full, incremental, and continuous
- Advanced recovery techniques: schema-level and redirected restore
- Implementation of split mirror copies for fast recovery
- Business continuity and disaster recovery planning
Module 6: Security and advanced access control
- Implementation of Row and Column Access Control (RCAC)
- Label-Based Access Control (LBAC) Configuration
- Trusted Contexts management for multi-tier architectures
- Authority Management: SECADM, DBADM, ACCESSCTRL, DATAACCESS
- Encryption techniques and protection of sensitive data
Module 7: Concurrency and lock management
- In-depth analysis of Db2 blocking mechanisms
- Setting insulation levels for maximum performance
- Solving containment and deadlock problems
- Concurrent workload optimization
Module 8: Performance Tuning and Optimization
- Proficiency with Db2 Query Optimizer and Db2 AI Optimizer
- Advanced indexing and partitioning strategies
- Use of Design Advisor for automatic recommendations
- Analysis of access plans with EXPLAIN utilities
- Monitoring with Data Management Console and native tools
Module 9: Proactive maintenance and automation
- Configuration of automated statistics profiles
- Scheduled execution of RUNSTATS, REORG and REORGCHK
- Implementation of preventive maintenance routines
- Continuous optimization strategies
Module 10: Business Monitoring and Diagnostics
- Use of SQL table functions for real-time monitoring
- Analysis of administrative views and historical data
- Implementation of proactive alerts and performance thresholds
- Advanced troubleshooting and incident resolution techniques
Hands-on methodology with real cases
Our hands-on approach ensures that each advanced concept is mastered through intensive labs that simulate real business environments:
- Complete installation of Db2 v12.1 in multiple configurations
- Configuring high availability environments with replication and clustering
- Multi-layered security implementation with RCAC, LBAC and Trusted Contexts
- Optimization of mixed workloads (OLTP and OLAP)
- Simulation of critical failures and business recovery procedures
- Real-time performance analysis with professional tools
The SIXE difference: more than training, professional transformation
At SIXE we not only teach Db2, we train managers prepared for the most demanding challenges:
- IBM certified trainers with real-world experience in large deployments
- Cloud-based labs with 24/7 access during the entire course
- Updated technical documentation with the latest versions and patches
Flexible training modalities
Live online training
Interactive sessions with full access to Db2 remote labs. Enjoy the flexibility of online learning without sacrificing the quality of the hands-on experience. Includes recordings for later review.
Intensive classroom training
Full immersive experience in our specialized centers with dedicated Db2 infrastructure. Direct networking with peers and immediate access to expert instructors.
Spain: Madrid, Barcelona, Valencia, Seville, Bilbao, Malaga
Latin America: Mexico DF, Buenos Aires, Bogota, Santiago, Lima, Quito
Latin America: Mexico DF, Buenos Aires, Bogota, Santiago, Lima, Quito
Customized in-company training
We fully tailor the content to the specific needs of your organization, including use cases from your own Db2 infrastructure and challenges particular to your industry.
