Adfor S.p.a.

DB2 10 for LUW Advanced Database Recovery

Adfor S.p.a.

Chiedi informazioni a un consulente Emagister

Informazioni importanti

Tipologia Corso
Metodologia Online
Inizio Scegli data
  • Corso
  • Online
  • Inizio:
    Scegli data

Gain a deeper understanding of the advanced recovery features of DB2 10 for Linux, UNIX, and Windows database environments with single and multiple partition databases. This course will demonstrate the planning and utilization of a wide variety of DB2 recovery facilities in a series of database recovery scenarios participants view during lab demos using DB2 Advanced Enterprise Edition 10.5 for Linux. If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course. Objective Describe the unique recovery planning requirements for DB2 10 single partition and multiple partition databases Explore the DB2 for Linux, UNIX and Windows recovery facilities and database configuration options Plan the implementation of automated archival and retrieval of database logs Recover a DB2 table following a DROP TABLE command issued in error Utilize the REBUILD option of the RESTORE Utility to recover a full or partial database copy using either database or table space backups Plan and execute the recovery of table spaces to a selected point in time Effectively utilize incremental backup and restore to reduce the size and duration of DB2 database backups Describe the database crash recovery processing performed when there is an unplanned outage of a DB2 database server and select database configuration options to minimize the restart time . Utilize the redirected restore option to recover DB2 data to alternate disk configurations and invoke the db2relocatedb command to alter the configuration of a DB2 database Execute recovery scenarios, including loss of DB2 log data using the DB2 log mirroring option, and configure a database for automatic backups List the benefits and limitations of disaster recovery alternatives including...

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
Inizio Scegli data

Domande più frequenti

· A chi è diretto?

This advanced course is for experienced database administrators who plan and implement recovery and high availability plans for DB2 10 for Linux, UNIX and Windows databases using single or multiple partition databases. The lab exercises can be performed using a single partition or a multiple partition database using DB2 Advanced Enterprise Edition 10.5 for Linux. This course is appropriate for those using DB2 in a z/Linux environment.

· Requisiti

You should complete: DB2 10 for LUW: Basic Administration for Linux and Windows (CL2X3G) or DB2 10 for LUW: Basic Administration for AIX (CL213G) or DB2 10.1 for Linux, UNIX, and Windows Quickstart for Experienced Relational DBAs (CL484G) or have equivalent experience


Senza valutazione
Valutazione del corso
Lo consiglia
Valutazione del Centro

Opinioni sul corso

Non ci sono ancora opinioni su questo corso
* Opinioni raccolte da Emagister & iAgora

Cosa impari in questo corso?

Web master


Unit 1: DB2 Database Recovery Review Exercise 1: Configuring DB2 for Recovery Unit 2: DB2 Recovery Log Management Exercise 2: Managing DB2 Log Files Unit 3: DB2 Dropped Table Recovery Exercise 3: DB2 Dropped Table Recovery Unit 4: Database Rebuild Support Exercise 4: Database Rebuild Support Unit 5: Table Space Recovery Exercise 5: Table Space Point-in-Time Recovery Unit 6: DB2 Incremental Backup and Recovery Exercise 6: Incremental Backup and Restore Unit 7: DB2 Database Crash Recovery Exercise 7: Database Crash Recovery Unit 8: DB2 Database and Table Space Relocation Exercise 8: DB2 Table space Relocation Unit 9: DB2 Additional Recovery Facilities Exercise 9: Additional Recovery Facilities Unit 10: Using Split Mirror Database Copies Exercise 10: Working with using split mirror database copies Unit 11: High Availability Options for DB2 LUW Unit 12: DB2 High Availability Disaster Recovery (HADR) – Introduction Exercise 11: Implementing a HADR Standby Database Unit 13: DB2 High Availability Disaster Recovery (HADR) – Standby Database options Exercise 12: Implementation of Multiple Standby databases and Reads on a Standby Database Unit 14: DB2 pureScale Database Recovery Considerations Unit 15: DB2 Partitioned Database Recovery Considerations"

Gli utenti che erano interessati a questo corso si sono informati anche su...
Leggi tutto