High Availability and Disaster Recovery for …

1 Information Management Software high Availability and Disaster Recovery for Temenos T24 with IBM DB2 and AIXMike BarrieModitha Sanjay De CostaGowrimani GopalakrishnanMurali NerallaT24 R11 on AIX with IBM WebSphere Application Server and WebSphere MQHigh Availability and Disaster Recovery implementationT24 R11 with DB2 9 and DB2 pureScaleFront coverHigh Availability and Disaster Recovery for Temenos T24 with IBM DB2 and AIXO ctober 2012 International Technical Support OrganizationREDP-4794-00 Copyright International Business Machines Corporation 2012. All rights to Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADPS chedule Contract with IBM Edition (October 2012)This edition applies to IBM DB2 for Linux, UNIX, and Windows Version and and Temenos T24 R11 with TAFC R11.

2 Note: Before using this information and the product it supports, read the information in Notices on page vii. Copyright IBM Corp. 2012. All rights .. viiTrademarks .. viiiPreface .. ixThe team who wrote this paper .. xNow you can become a published author, too! .. xiComments welcome .. xiStay connected to IBM Redbooks .. xiiChapter 1. Scope of the test project .. Software levels used for the project .. Scope of the project and aspects considered out of scope .. 2 Chapter 2. Introduction to Temenos T24.. T24 in context .. T24 layered application architecture .. Technical component view .. Typical message flows .. Component descriptions .. 12 Chapter 3. IBM high Availability and Disaster Recovery options.

3 WebSphere Application Server Network Deployment .. Cluster configuration .. Session management .. IBM HTTP Server .. WebSphere MQ server .. Multi-instance queue managers .. WebSphere MQ cluster managed by PowerHA .. DB2 Enterprise Server .. Hardware solutions .. Cluster management .. DB2 high Availability Disaster Recovery .. HADR usage with PowerHA .. DB2 pureScale feature .. 30 Chapter 4. T24 reference configurations for high Availability and Disaster Recovery .. Reference configuration by using DB2 with PowerHA and DB2 Reference configuration with DB2 pureScale .. 40iv high Availability and Disaster Recovery for Temenos T24 with IBM DB2 and AIXC hapter 5. T24 high Availability and Disaster Recovery scenarios.

4 Scenario 1: high Availability test by using DB2 pureScale with an active-active configuration .. Read tests .. Write tests .. COB tests .. Scenario 2: high Availability test with DB2 in active-passive mode .. Read test .. Write test .. COB test .. Scenario 3: Disaster Recovery test with DB2 with an active-active configuration .. Read test .. Write test .. COB test .. Scenario 4: Disaster Recovery test with DB2 pureScale .. 54 Chapter 6. Test configuration setup .. Hardware and network configuration of the test system .. Configuring and setting up the test systems .. WebSphere Application Server .. HTTP server .. Deployment manager and application server .. WebSphere MQ Server.

5 T24 application .. DB2 .. 69 Chapter 7. Testing processes and results .. Creating a failover initiation mechanism .. Test results .. high Availability test with DB2 pureScale: Active-active mode .. high Availability test with DB2 : Active-passive mode .. Disaster Recovery test with DB2 : Active-active mode .. Summary .. 85 Appendix A. Configuration and testing details .. 87 Issues and resolutions .. 88 Situation 1 .. 88 Situation 2 .. 89 Situation 3 .. 89 Situation 4 .. 90 Database manager and database configuration .. 90DB2 pureScale high Availability .. 90DB2 high Availability .. 97 Contents vDB2 Disaster Recovery .. 103 Results of the tests .. 109 high Availability test with DB2 pureScale in the active-active mode.

6 109 high Availability test with DB2 using the active-passive database .. 117 Disaster Recovery test with DB2 in active-active mode .. 119 Abbreviations and acronyms .. 123 Related publications .. 125 IBM Redbooks .. 125 Online resources .. 125 Help from IBM .. 127vi high Availability and Disaster Recovery for Temenos T24 with IBM DB2 and AIX Copyright IBM Corp. 2012. All rights information was developed for products and services offered in the IBM may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used.

7 Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service. IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not give you any license to these patents. You can send license inquiries, in writing, to: IBM Director of Licensing, IBM Corporation, North Castle Drive, Armonk, NY 10504-1785 following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE.

8 Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you. This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice. Any references in this information to non-IBM websites are provided for convenience only and do not in any manner serve as an endorsement of those websites. The materials at those websites are not part of the materials for this IBM product and use of those websites is at your own risk.

9 IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those information contains examples of data and reports used in daily business operations. To illustrate them as completely as possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental.

10 COPYRIGHT LICENSE:This information contains sample application programs in source language, which illustrate programming techniques on various operating platforms. You may copy, modify, and distribute these sample programs in any form without payment to IBM, for the purposes of developing, using, marketing or distributing application programs conforming to the application programming interface for the operating platform for which the sample programs are written. These examples have not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of these programs. viii high Availability and Disaster Recovery for Temenos T24 with IBM DB2 and AIXT rademarksIBM, the IBM logo, and are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both.