IBM Db2 12.1: Data Management and Recovery for Relational DBAs [2LA91G]
- Type product
IBM Db2 12.1: Data Management and Recovery for Relational DBAs [2LA91G]
Opleiderscore:
Beschrijving
Ontdek de verschillende trainingsmogelijkheden bij Global Knowledge
Online of op locatie er is altijd een vorm die bij je past.
Kies op welke manier jij of je team graag een training wilt volgen. Global Knowledge bied je verschillende trainingsmogelijkheden. Je kunt kiezen uit o.a. klassikaal, Virtueel Klassikaal (online), e-Learning en maatwerk. Met onze Blended oplossing kun je de verschillende trainingsvormen combineren.
OVERVIEW
This course provides a detailed exploration of essential data management, recovery, and maintenance techniques for IBM Db2 12.1 database administrators. Learners will gain the skills necessary to manage data movement, implement robust backup and recovery strategies, and monitor and maintain database performance in enterprise environments.
This course covers how to move and load data efficiently using SQL commands, the LOAD, IMPORT, and INGEST utilities, and procedures like ADMIN_MOVE_TABLE. The course then shifts focus to recovery operations, covering crash recovery, version recovery, roll-forward recovery, and the configuration of logging and backup policies, including high availab…
Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
Ontdek de verschillende trainingsmogelijkheden bij Global Knowledge
Online of op locatie er is altijd een vorm die bij je past.
Kies op welke manier jij of je team graag een training wilt volgen. Global Knowledge bied je verschillende trainingsmogelijkheden. Je kunt kiezen uit o.a. klassikaal, Virtueel Klassikaal (online), e-Learning en maatwerk. Met onze Blended oplossing kun je de verschillende trainingsvormen combineren.
OVERVIEW
This course provides a detailed exploration of essential data management, recovery, and maintenance techniques for IBM Db2 12.1 database administrators. Learners will gain the skills necessary to manage data movement, implement robust backup and recovery strategies, and monitor and maintain database performance in enterprise environments.
This course covers how to move and load data efficiently using SQL commands, the LOAD, IMPORT, and INGEST utilities, and procedures like ADMIN_MOVE_TABLE. The course then shifts focus to recovery operations, covering crash recovery, version recovery, roll-forward recovery, and the configuration of logging and backup policies, including high availability through HADR. In the final unit, learners will explore tools and commands for ongoing maintenance and performance tuning, including RUNSTATS, REORG, REORGCHK, event monitors, the Db2 Design Advisor, and diagnostic utilities such as db2diag, db2fodc, and db2trc.
Through a series of hands-on exercises, learners will practice loading and reorganizing large datasets using Db2 utilities, configuring and executing backup and recovery operations, analyzing system health and performance using monitoring functions, and capturing and interpreting diagnostic data for problem determination.
By the end of this course, learners will be proficient in managing data movement, implementing recovery procedures, optimizing performance, and diagnosing operational issues in Db2 12.1 databases—ensuring high availability and reliability in production environments.
OBJECTIVES
After completing this course, learners should be able to:
- Execute SQL-based data movement operations using INSERT, MERGE, and TRUNCATE statements
- Configure and monitor load operations using Db2 commands (LIST UTILITIES, MON_GET_UTILITY, and LOAD_QUERY) and assess table states
- Apply the ADMIN_MOVE_TABLE stored procedure to relocate tables online
- Configure and manage database and log backup strategies using parameters such as LOGARCHMETH1, NEWLOGPATH, LOGFILSIZ, and backup options including incremental and encrypted backups
- Implement High Availability Disaster Recovery (HADR) configurations and describe enhancements for automated failover using Pacemaker
- Apply advanced recovery techniques such as schema-level logical backup and restore, redirected restore, and split mirror copies to support complex enterprise recovery scenarios
- Perform database maintenance tasks using RUNSTATS, REORG, and REORGCHK to optimize performance
- Access and interpret diagnostic logs using db2diag, PD_GET_DIAG_HIST, and db2 support
- Use advanced troubleshooting tools, including db2fodc and db2trc to capture data for problem resolution
CONTENT
Course Introduction
Unit 1: Data Movement and Loading Fundamentals
Unit 2: Backup and Recovery
Unit 3: Database Maintenance, Monitoring, and Problem Determination
Blijf op de hoogte van nieuwe ervaringen
Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.