Synopses & Reviews
IBM's definitive guide to DB2 high availability
High availability is now crucial to virtually every enterprise and e-business application. Now, there's a start-to-finish guide to delivering high availability with DB2 Universal Database for Linux, UNIX and Windows. Two of IBM's leading DB2 high availability experts thoroughly review options related to both the database engine and the underlying platform. Along the way, they address the entire lifecycle, from planning and architecture through day-to-day administration. Coverage includes:
- Fundamental concepts, real-world challenges, and tradeoffs
- Choosing among today's diverse high availability alternatives
- Configuring highly available databases
- Disk-based availability, including split mirror copies and disk-based remote mirroring
- Multi-partition issues, including instance takeover and tuning parameters
- Clustering and failover: HACMP, Sun Cluster, HP Service Guard, MSCS, and Linux Steeleye
- Monitoring and tuning databases to maximize availability
- Backup and recovery in highly available environments
- DB2's advanced availability features: standby servers, shared disk configurations, and no-data-loss recovery
If you're a DBA, your #1 priority is to keep your database running. If you're an architect, your #1 priority is building databases that can keep running. This book solves both problems.
Synopsis
IBM's definitive guide to DB2 high availability
High availability is now crucial to virtually every enterprise and e-business application. Now, there's a start-to-finish guide to delivering high availability with DB2 Universal Database for Linux, UNIX and Windows. Two of IBM's leading DB2 high availability experts thoroughly review options related to both the database engine and the underlying platform. Along the way, they address the entire lifecycle, from planning and architecture through day-to-day administration. Coverage includes: Fundamental concepts, real-world challenges, and tradeoffsChoosing among today's diverse high availability alternativesConfiguring highly available databasesDisk-based availability, including split mirror copies and disk-based remote mirroringMulti-partition issues, including instance takeover and tuning parametersClustering and failover: HACMP, Sun Cluster, HP Service Guard, MSCS, and Linux SteeleyeMonitoring and tuning databases to maximize availabilityBackup and recovery in highly available environmentsDB2's advanced availability features: standby servers, shared disk configurations, and no-data-loss recovery
If you're a DBA, your #1 priority is to keep your database running. If you're an architect, your #1 priority is building databases that can keep running. This book solves both problems.
About the Author
CHRIS EATON is an IBM Product Manager for DB2, responsible for planning and strategy for DB2's future direction. He has worked with DB2 in roles ranging from customer service analyst to development manager, and now spends much of his time working with customers in high availability environments. ENZO CIALINI is responsible for managing the DB2 UDB System Verification Test Department, with a focus on High Availability. He has authored many papers on DB2 UDB high availability configurations. Eaton and Cialini have each worked with DB2 at IBM's Toronto Laboratory for over a decade.
Table of Contents
Preface.
1. Introduction.
Types of Outages. Cost of Outages. Types of Recovery Processes Covered in this Book.
2. Minimizing Unplanned Outages.
Recovery Processing. How Database Logging Works. Types of Logging. Crash Recovery. Backup Processing. Database Recovery. Summary.
3. Minimizing Unplanned Outages.
Increasing Availability During Planned Outages.
4. Setting Up a Standby Database.
What is a Standby Database? Recap of Log Archiving and Roll Forward Recovery. Log Shipping to a Standby Database. Other Considerations for Log Shipping. Replication as a Standby Database. Summarizing your Standby Database Options.
5. Disk-Based Availability Options.
Disk-Based Availability Options.
6. Setting up Failover Software.
Failover Software.
7.Using Shared-Disk for Greater Availability.
Using Shared Disks for Greater Availability.
Index.