Description
Course data
| IBM code: CL801GES / CL801G | Category: DB2 / DB2 pureScale |
| Modality: Online and Face-to-Face | Duration: 3 days |
| Version: DB2 11.5 | Language: English/Spanish |
Target audience
This intermediate course is intended for experienced DB2 LUW database administrators who need to implement and manage DB2 pureScale environments for high availability and scalability.
Prerequisites
Must have completed one of the following courses:
- DB2 10 for LUW: Basic Administration for Linux and Windows (CL2X3G) o
- DB2 10 for LUW: Basic Administration for AIX (CL213G) o
- DB2 10 for Linux, UNIX and Windows: Quick Start for Experienced Relational DBAs (CL485G)
Or have equivalent experience in DB2 administration.
Certified instructors
The vast majority of the IBM courses we offer are taught directly by our IBM certified engineers. This is the only way to guarantee the highest quality. We complement all training with our own materials and laboratories, based on our experience during the deployments, migrations and courses we have conducted over the years.
Added value with SIXE
Our courses are deeply oriented to the role to play. It is not the same the needs of mastering a technology for a team of developers, as it is for the people in charge of deploying and managing the infrastructure. That is why, beyond commands and tasks, we focus on solving real problems that arise in the day-to-day work of each team. Providing them with the knowledge, skills and skills required for each project.
News 2025:
- Compatibility with DB2 11.5 and latest versions
- Integration with Microsoft Azure and AWS
- New monitoring and diagnostic functionalities
- Updated best practices for high availability
Course agenda and syllabus
Unit 1: Introduction to DB2 pureScale
- pureScale cluster architecture and components
- Differences with traditional DB2
- Use cases and business benefits
Unit 2: DB2 pureScale Database Internals
- Cluster Facilities (CF) and Members
- Global Lock Manager (GLM)
- Global Buffer Pool
Unit 3: Managing a pureScale DB2 Cluster
- Cluster administration commands
- Member management and CF
- Maintenance operations
Unit 4: Planning a pureScale DB2 Cluster
- Hardware and software requirements
- Sizing and topology
- Network and storage considerations
Unit 5: Installation of a pureScale DB2 Cluster
- Preparation of the environment
- Step-by-step installation process
- Verification and initial testing
Unit 6: Migration to DB2 pureScale
- Migration strategies
- Migration tools
- Minimization of downtime
Unit 7: Backup and Recovery in DB2 pureScale
- Specific support strategies
- Recovery in cluster environments
- Online and offline backup
Unit 8: High Availability Behavior
- Automatic failover
- Fault tolerance
- Availability testing
Unit 9: Storage Management
- Shared storage
- Clustered tablespace management
- Storage optimization
Unit 10: Performance Monitoring and Management
- Specific monitoring tools
- Key cluster metrics
- Performance optimization
Unit 11: Problem Solving
- Diagnosis of cluster problems
- Logs and specific traces
- Troubleshooting tools
Unit 12: Customer Availability and Workload Management
- Load Balancing
- Connection management
- Workload management in cluster
Course customization
Do you need to adapt this syllabus to your specific needs? Are you interested in other DB2 courses? Contact us without obligation for a customized proposal.
Classroom training locations
Spain
Madrid, Barcelona, Valencia, Seville, Bilbao, Malaga, Seville, Bilbao, Malaga
Argentina
Buenos Aires, Córdoba
Chile
Santiago de Chile
Colombia
Bogota, Medellin, Cartagena, Cali
Mexico
Mexico City, Guadalajara, Monterrey, Mexico City
Peru
Lima
Portugal
Lisbon, Porto, Braga
Other countries
Bolivia (La Paz), Costa Rica (San Jose), Ecuador (Quito), Paraguay (Asuncion), Uruguay (Montevideo)
Why choose SIXE for your DB2 pureScale training?
- 15+ years of experience in official IBM training
- Certified instructors with real project experience
- Flexible modality: face-to-face, online or hybrid
- International coverage in Spain and Latin America
- Practical laboratories with real scenarios
- Documentation updated to the latest versions
- Post-course support to resolve doubts
