Transcription

1 DB2 9 for LUW Advanced Database Recovery CL492; 4 days, Instructor-led Course Description Gain a deeper understanding of the advanced features of DB2 9 for Linux, UNIX, and Windows database environments with single and multiple partition databases. Get practical experience in the planning and utilization of a wide variety of DB2 facilities in a series of database scenarios you complete during lab exercises using DB2 Enterprise 9.7 for Linux. The purpose of this course is to enable the learning to gain a deeper understanding of the advanced features of DB2 9 for Linux, UNIX, and Windows database environments with single and multiple partition databases. In this course, the learning will receive practical experience in the planning and utilization of a wide variety of DB2 facilities in a series of database scenarios you complete during lab exercises using DB2 Enterprise 9.7 for Linux. Course Objectives Describe the unique planning requirements for DB2 9 single partition and DPF multiple partition databases Explore the DB2 for Linux, UNIX and Windows 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 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 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 scenarios, including loss of DB2 log data using the DB2 log mirroring option, and configure a database for automatic backups Utilize the information in the DB2 history file to plan and execute various DB2 utilities Configure a DB2 database to automatically remove objects that are no longer needed, including backups and archived logs List the benefits and limitations of disaster alternatives including log shipping to a standby database or using DB2 replication Utilize the db2haicu command to select options for the integrated high availability cluster support for DB2 databases Explore the options for operation of DB2 databases in high availability environments including the use of a split mirror copy of the database

2 Plan, implement, and manage the Primary and Standby databases using the High Availability Disaster Recovery (HADR) facilities of DB2 9 for Linux, UNIX and Windows databases Implement Read-Only application access to the Standby database in a HADR environment Audience This advanced course is for experienced database administrators who plan and implement and high availability plans for DB2 9 for Linux, UNIX and Windows databases using single or multiple partition DPF databases. The lab exercises can be performed using a single partition or a multiple partition DPF database using DB2 Enterprise 9.7 for Linux. This course is appropriate for those using DB2 in a z/linux environment. Prerequisites DB2 9 Database Administration Workshop for Linux, UNIX, and Windows (CL2X2) Course Outline DB2 Database Recovery Review State the three types of support Explain the basic principles DB2 uses for database and restart Describe the capabilities and functional requirements of DB2 logging Select options for some of the DB2 database parameters that support DB2 Recovery Log Management Select the DB2 Database parameters that support the DB2 logs Configure the database options to automate archive log management Implement infinite active logging to support applications that require large amounts of logged database changes Describe the options provided by DB2 9 for Linux, UNIX, and Windows to reduce log volume, including the NOT LOGGED INITIALLY option DB2 Dropped Table Recovery Explain the DB2 facility to recover from an SQL DROP TABLE statement issued in error Implement dropped table for selected table spaces Use the DB2 LIST HISTORY command to gather the information needed to recover a dropped table Plan and invoke the DB2 utilities involved in recovering a dropped table Database Rebuild Support Review the considerations of using standard DB2 database options Explain the capabilities of the REBUILD option for the RESTORE command List the types of information included in each DB2 backup image and describe how it is used to support rebuilding a database Plan for supporting database and disaster scenarios using DB2 database and table space backups using the RESTORE command with a REBUILD option Utilize LIST UTILITIES SHOW DETAIL to monitor progress of a RESTORE Utility during database rebuilding Table Space Recovery Plan for point-in-time of a table spaces to support application processing errors

3 Explain how the minimum time for a table space may impact application point in time Use the ONLINE option for RESTORE and ROLLFORWARD commands to recover selected table spaces with an active database DB2 Incremental Backup and Recovery Plan a database strategy that includes both full and Incremental backups to reduce the duration and size of database backups Implement a physical database design to take advantage of Incremental backups of selected table spaces Utilize an Incremental restore to recover a DB2 database or table space from Incremental backup images Use the LIST UTILITIES command to track the processing of an Incremental backup or restore process DB2 Database Crash Recovery Describe the concepts and processing for DB2 database crash Select an appropriate value for SOFTMAX to reduce database crash time Configure DB2 database options to support crash for applications Describe the impact of a database crash and restart for DB2 Utilities like LOAD, REORG and IMPORT DB2 Database and Table Space Relocation Explain the facility of the DB2 RESTORE command to recover table spaces to different containers Use the SET TABLESPACE CONTAINERS command to define new containers during a redirected restore Utilize the RESTORE utility to change the database storage paths for AUTOMATIC STORAGE table spaces Plan the use of redirected restore as part of a disaster Describe two methods that can be used to convert a DMS table space to utilize automatic storage Use the GENERATE SCRIPT option of RESTORE to set up a command script for a redirected restore operation Copy schemas from one database to another using the TRANSPORT option of the RESTORE utility Use db2relocatedb when moving or copying DB2 databases with non-db2 utilities DB2 Additional Recovery Facilities Explain the LOAD Utility options COPY YES, COPY NO and NONRECOVERABLE impact on database Select the appropriate method for protecting the database from loss of log file Select the BACKUP Utility option to include the required logs in an online backup image Use the DB2 ARCHIVE LOG command to make the current DB2 log available for archival Implement the DB2 option for blocking update transactions when the log disk becomes full Implement the DB2 Utility Throttle using the UTIL_IMPACT_LIM Database Manager configuration option Configure a DB2 database for automatic backups Explain the self-optimizing features of the Backup Utility

4 DB2 Recovery History File Explain the information recorded in the Recovery History file Use the DB2 LIST HISTORY command to display selected information needed to plan database Retrieve information from the database history using SQL Configure a DB2 database for automatic removal of database objects including backups and archived logs Use the PRUNE HISTORY command to remove outdated information in the Recovery History Restore a damaged Recovery History file High Availability and Split Mirror Database Copy Describe various techniques for supporting High Availability of DB2 databases Explain the concepts involved when implementing the automated failover of a DB2 database Describe the integrated cluster configuration and management features of DB2 Discuss the concepts used by DB2 purescale to support High Availability for a DB2 database Plan for using split mirror copies to create a standby database, a database snapshot or a database mirror Utilize the SET WRITE SUSPEND and DBD2INIDB commands with split mirror database copies Use the AS SNAPSHOT option of the DB2 BACKUP and RESTORE utilities Basic Database Disaster Recovery Techniques Describe the benefits and limitations of several methods for supporting database disaster Explain setup for a Standby database at a remote location Plan for database disaster using remotely mirrored disks Describe the use of DB2 Replication to recover selected DB2 tables in a remote database DB2 High Availability Disaster Recovery (HADR) Describe the benefits and limitations of implementing High Availability Disaster Recovery (HADR) Implement HADR, including the setup of a Primary and Standby database Use the commands START HADR, STOP HADR, and TAKEOVER to manage an operational HADR system Plan for the use of the DB2 Utilities like LOAD, REORG, Backup and Restore in an HADR environment Select appropriate HADR database configuration options in order to meet the requirements of a specific application environment including the HADR_PEER_WINDOW Monitor the status of the Primary and Standby database using GET SNAPSHOT FOR DATABASE or db2pd - hadr Implement Read-only application access to the Standby Database of an HADR database environment DB2 DPF Partitioned Database Recovery Considerations Explain database facilities in a DB2 DPF partitioned database Describe the use of the Single System View options for Backup of a partitioned database Recover a partitioned database using the TO END OF LOGS option of the ROLLFORWARD command Create an online Backup of a DPF partitioned database that includes all of the required active logs Implement automated archival of DB2 logs in a DPF partitioned database Perform dropped table in a DPF partitioned database Use the REBUILD option of RESTORE to build a partial copy of a DPF Partitioned database

5 Describe the crash processing performed for a DPF partitioned database Explain the use of redirected restores and db2relocatedb with DPF partitioned databases Use db2inidb for split mirror copies with a DPF partitioned databases

Course 6231A: Maintaining a Microsoft SQL Server 2008 Database About this Course Elements of this syllabus are subject to change. This five-day instructor-led course provides students with the knowledge

DB2 for Linux, UNIX, and Windows Performance Tuning and Monitoring Workshop Duration: 4 Days What you will learn Learn how to tune for optimum performance the IBM DB2 9 for Linux, UNIX, and Windows relational

DB2 DB2 Version 9 for Linux, UNIX, and Windows Data Recovery and High Availability Guide and Reference SC10-4228-00 DB2 DB2 Version 9 for Linux, UNIX, and Windows Data Recovery and High Availability Guide

Key Data Product #: Course #: 6231A Number of Days: 5 Format: Certification Exams: 70-432, 70-433 Instructor-Led This course syllabus should be used to determine whether the course is appropriate for the

Course Syllabus Course 2788A: Designing High Availability Database Solutions Using Microsoft SQL Server 2005 About this Course Elements of this syllabus are subject to change. This three-day instructor-led

6231A - Maintaining a Microsoft SQL Server 2008 Database Course Number: 6231A Course Length: 5 Days Certification Exam This course will help you prepare for the following Microsoft Certified Professional

D12CBR Oracle Database 12c: Backup and Recovery Workshop NEW What you will learn This Oracle Database 12c: Backup and Recovery Workshop will teach you how to evaluate your own recovery requirements. You'll

Oracle Database 10g: Backup and Recovery 1-2 Oracle Database 10g: Backup and Recovery 1-3 What Is Backup and Recovery? The phrase backup and recovery refers to the strategies and techniques that are employed

SQL Server for Database Administrators Course Syllabus 1. Description This course teaches the administration and maintenance aspects of Microsoft SQL Server. It covers all the roles performed by administrative

A SURVEY OF POPULAR CLUSTERING TECHNOLOGIES By: Edward Whalen Performance Tuning Corporation INTRODUCTION There are a number of clustering products available on the market today, and clustering has become

This chapter includes the following sections: to Release 1.3, page 1 to Release 1.3 You can upgrade Cisco UCS Central release 1.1(2a) or 1.2 to 1.3 in either standalone or cluster mode. If you are already

PowerShell for SQL Server Administrators 55069 - PowerShell for SQL Server Administrators About this Course This two-day instructor-led course provides candidates with the knowledge and skills needed to

EMC NetWorker Module for Databases and Applications Version 8.2 and Service Packs Administration Guide 302-001-217 REV 06 Copyright 2009-2016 EMC Corporation. All rights reserved. Published in the USA.

SQL Server 2008 Designing, Optimizing, and Maintaining a Database Course The SQL Server 2008 Designing, Optimizing, and Maintaining a Database course will help you prepare for 70-450 exam from Microsoft.

Log shipping has been a mechanism for maintaining a warm standby server for years. Though SQL Server supported log shipping with SQL Server 2000 as a part of DB Maintenance Plan, it has become a built-in

HP LeftHand SAN Solutions Support Document Application Notes Oracle Backup Recovery Setup on LeftHand Networks IP SAN Legal Notices Warranty The only warranties for HP products and services are set forth

Course 20465: Designing a Data Solution with Microsoft SQL Server Overview About this course The focus of this five-day instructor-led course is on planning and implementing enterprise database infrastructure

This product is protected by U.S. and international copyright and intellectual property laws. This product is covered by one or more patents listed at http://www.vmware.com/download/patents.html. VMware

Module 14: Scalability and High Availability Overview Key high availability features available in Oracle and SQL Server Key scalability features available in Oracle and SQL Server High Availability High

20465C: Designing a Data Solution with Microsoft SQL Server Course Details Course Code: Duration: Notes: 20465C 5 days This course syllabus should be used to determine whether the course is appropriate

SharePoint 2010 Bootcamp This five-day course is designed to equip Systems Administrators, Integrators and Developers with a strong foundation for implementing solutions on Microsoft SharePoint 2010. Attendees

White Paper EMC DOCUMENTUM xplore 1.1 DISASTER RECOVERY USING EMC NETWORKER Abstract The objective of this white paper is to describe the architecture of and procedure for configuring EMC Documentum xplore

Description Course Summary This five-day instructor-led course teaches students how to install, configure, and administer Microsoft SharePoint and also how to manage and monitor sites and users by using

How Routine Data Center Operations Put Your HA/DR Plans at Risk Protect your business by closing gaps in your disaster recovery infrastructure Things alter for the worse spontaneously, if they be not altered