Book Summary : High Availability and Disaster Recovery Options for DB2 on Linux UNIX and Windows
As organizations strive to do more with less, IBM DB2 for Linux, UNIX, and Windows provides various built-in high availability features. DB2 further provides high availability solutions by leveraging enterprise system resources with broad support for clustering software such as HACMP, TSA, and Microsoft Windows Cluster Server.
This IBM Redbooks publication describes DB2's high availability functions and features, focusing on High Availability Disaster Recovery (HADR) in the OLTP environment. The book provides a detailed discussion of HADR, including setup, configuration. administration, monitoring, and best practices.
We explain how to configure cluster software HACMP, TSA, and MSCS with DB2 and show how to use these products to automate HADR takeover.
DB2 also provides unprecedented enterprise-class disaster recovery capability. This book covers single system view backup, backup and restore with snapshot backup, as well as the db2recovery command, in detail.
About the Authors
Whei-Jen Chen is a Project Leader at the International Technical Support Organization, San Jose Center. She has extensive experience in application development, database design and modeling, and DB2 system administration. Whei-Jen is an IBM Certified Solutions Expert in Database Administration and Application Development as well as an IBM Certified IT Specialist.
Masafumi Otsuki is an IT Specialist with IBM Systems Engineering Co., Ltd. in Japan. He has been working in DB2 technical support for two years focusing on DB2 high availability applications.
Paul Descovich works in a DB2 Systems Support role for IBM Global Services Australia, where most of his time is spent installing, configuring, and maintaining DB2 on midrange platforms. The rest of his time is spent interviewing architects to determine DB2 implementation standards, coordinating with UNIX sysadmins to get the necessary root authorities, and explaining how the DB2 System Support role is not the same as an Application DBA role. Paul started out application programming for DB2 v2r2 on MVS in 1991, then did DB2 System Support and DBA work from 1993, joining IBM in 1999.
Selvaprabhu Arumuggharaj is an Advisory Software Engineer. He has worked for IBM for eight years supporting Information Management products including DB2 and Informix database engines. He currently works on DB2 Down systems and Diagnostics (DSD) team supporting all DB2 customers, covering all engine components, and providing proactive support direction, diagnostic assistance, and solutions to one or more typically highly complex issues. He has solid knowledge of DB2 DPF and High Availability (HA) features.
Toshihiko Kubo is an IT Architect with DB2 for Linux, UNIX, and Windows. Currently, his key responsibility is in data service technical sales focusing on the areas of financial customers, high availability, Solid, and pureXML. He joined IBM in 1999. Toshihiko has experience in design of the mission-critical DBMS architectures and development of the clinical information system for hospitals.
Yong Jun Bi is a Senior IT Specialist currently working in Advanced Technical Support, IBM China. He focuses mainly on DB2 for LUW benchmark testing and High Availability and Disaster Recovery solutions. He also has rich experience in large scale database warehouse. Yong Jun is an IBM Certified Advanced Database Administrator.