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.

Chapter 1. DB2 high availability and disaster recovery options
Chapter 2. HADR introduction
Chapter 3. HADR setup
Chapter 4. HADR administration and monitoring
Chapter 5. Automatic client reroute
Chapter 7. DB2 and system upgrades
Chapter 8. DB2 with TSA
Chapter 9. DB2 and HACMP
Chapter 10. DB2 with Microsoft Windows Server Cluster
Chapter 11. HADR with clustering software
Chapter 12. Configuring cluster using DB2 9.5 high availability feature
Chapter 13. Q replication
Chapter 14. Backup and Recovery
Appendix A. HACMP application server
Appendix B. DB2 and TSA configuration for ssh
Appendix C. TSA scripts

• Introduction to the New Mainframe: z/OS Basics, SG24-6366-01
• PowerVM Virtualization on IBM System p: Introduction and Configuration Fourth Edition, SG24-7940-03
• WebSphere Application Server V6.1: System Management and Configuration, SG24-7304-00

Publish Date
08 February 2009

Last Update
20 April 2009

Rating:
(based on 3 reviews)

Rate this book

Author(s)

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.

• Whei-Jen Chen

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.

• Masafumi Otsuki

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.

• Paul Descovich

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.

• Selvaprabhu Arumuggharaj

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.

• Toshihiko Kubo

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.

• Yong Jun Bi

ISBN

0738431389

IBM Form Number
SG24-7363-01

Number of pages
878