Skip to main content


developerWorks  >  Information Management  >

Continuous availability databases with IBM DB2 9.5 and EMC SRDF

developerWorks

Level: Introductory

Aruna De Silva (adesilva@ca.ibm.com), Testing Support Specialist, IBM
Enzo Cialini (ecialini@ca.ibm.com), Senior Technical Staff, IBM Toronto
Aslam Nomani (aslam@ca.ibm.com), Quality Assurance Manager, IBM
Paul Pendle , Consulting Systems Integration Engineer, EMC Corporation
Roger E. Sanders (sanders_roger@emc.com), Consultant Corporate Systems Engineer, EMC Corporation

02 Jul 2009

Get the download

EMC Symmetrix Remote Data Facility (SRDF) software, suspend I/O features available in operating systems, and IBM® DB2® Version 9.5 for Linux®, UNIX®, and Windows® (DB2 9.5) software combine to provide highly available advanced database technical architectures to meet the most stringent demands for data availability. In this article, learn how to use these features to create a coherent copy of a continuously available DB2 9.5 database to meet the increasing availability requirements demanded in today's business environment.

In this article

  • Introduction -- The technical solution and basic concepts

  • System configuration

  • Usage scenarios

Today's highly competitive business marketplace leaves little room for error in terms of availability, continuous operations, or recovery in the event of an unplanned outage. In today's connected world, an event that makes business data unavailable, even for relatively short periods of time, has the potential to have a major impact.

Hence, today's mission-critical database systems must operate 24 x 7 with the highest degree of availability possible. As databases increase in size, and ad hoc queries place more demands on the continued availability of the system, the time and hardware resources required to back up and recover databases grows substantially while the maintenance windows are either drastically reduced or disappear completely.

EMC Symmetrix Remote Data Facility (SRDF) software, suspend I/O features in operating systems, and DB2 9.5 for Linux, UNIX, and Windows software combine to provide highly available advanced database technical architectures to meet those demands. In this paper, we demonstrate the use of these features to create a coherent copy of a continuously available DB2 9.5 database to meet the increasing availability requirements demanded in today's business environment.



Download

DescriptionNameSizeDownload method
Article in PDF formatcontinuous_availability.pdf489KBHTTP
Information about download methodsGet Adobe® Reader®


Resources

Learn

Get products and technologies

Discuss


About the authors

Aruna De Silva  photo

Aruna De Silva is a member of the QA team for DB2 on Linux, Unix, and Windows product at the IBM Toronto software laboratory. Aruna is an IBM Certified Advanced Database Administrator for DB2 9. In addition, he holds numerous IT certifications from IBM and other vendors in database, hardware and systems administration. Aruna is actively involved in DB2 product integration, implementing and testing complex product stacks, and designing and testing HA and DR solutions. He is also the key contact person for EMC Storage within DB2 QA team. He holds a Bachelor of Science degree in Computer Science from York University.


Enzo Cialini photo

Enzo Cialini is a Senior Technical Staff Member in the IBM Information Management Software division at the IBM Toronto Laboratory. He is currently the Chief Quality Assurance Architect responsible for management and technical test strategy for DB2 LUW Engine (Warehouse and OLTP), IM Solutions (InfoSphere Balanced Warehouse and McKesson Performance Advisor) and Customer Operational Profiling. Enzo joined IBM in 1991 and has been working on the DB2 development team since 1992. He has more than 18 years experience in software development, testing and support. Enzo established the DB2 Product Validation Program and has established testing, development, and marketing relationships with such storage vendors as EMC, Veritas, and Network Appliance. Enzo is actively engaged with customers and the field in OLTP and Warehouse deployments, has authored The High Availability Guide for DB2 and has published many papers on DB2 and Integration. He holds a Bachelor of Science degree in Computer Science from McMaster University.


Aslam Nomani photo

Aslam Nomani is a Quality Assurance Manger with the DB2 for Linux, Unix, and Windows product. He has worked for the IBM Toronto Lab for over 13 years. His focus area is high availability and he also works very closely with the IBM storage partners.


Paul Pendle photo

Paul Pendle is a Consulting Systems Integration Engineer with the EMC Corporation in Massachusetts. He is a 31 year veteran of the IT industry with a variety of experience in systems programming and database administration. Paul has worked with DB2 on z/OS (MVS) since DB2 V1.2 and speaks regularly at DB2 user conferences on both DB2 for z/OS and DB2 for Linux, UNIX and Windows. Paul is a published author on integration of EMC products with DB2.


Roger Sanders photo

Roger E. Sanders is consultant corporate systems engineer at EMC Corporation. He is the author of 18 books on DB2 for Linux, UNIX, and Windows and teaches classes at many DB2 conferences. He is currently working on a new book that outlines how to write technical magazine articles and books and get them published.




Rate this content


Please take a moment to complete this form to help us better serve you.



 


 


Not
useful
Extremely
useful
 


Back to top


Document options

Document options requiring JavaScript are not displayed

Discuss


My developerWorks needs you!

Connect to your technical community


Rate this content

Help us improve this content