DB2 9.7 HADR with TSA - Part11 - DB2 HADR useful references

In this artical, I will provide all useful reference i had refered for DB2 HADR configuration. You may also look at my twitter account for some useful DB2 links. My twitter reference
http://twitter.com/gilroygonsalves

Part 0 : DB2 9.7 HADR with TSA Part 00 - Introduction

Part 1 : Installing and configuring VMWare environment

Part 2 : Installing IBM tools for querying and monitoring purpose

Part 3 : Installing IBM DB2 9.7 database

Part 4 : Installing DB2 9.7 Fix-pack

Part 5 : Creating Instance and database

Part 6 : Configuring DB2 9.7 HADR between Primary and Standby

Part 7 : Configuring DB2 9.7 HADR to work with TSA

Part 8 : Performing some DB2 9.7 HADR failover and failback test

Part 9 : Converting DB2 9.7 HADR no-read-access standby to DB2 9.7 HADR read-only standby database

Part 10 : Configuring DB2 9.7 Automatic Client re-route  (ACR)




Below are some of my reference which i used for writing this artical. You may also look at my twitter account for more useful DB2 links.

My twitter references

http://twitter.com/gilroygonsalves



--  Cleaning up failed DB2 HADR with TSA configuration

Option 1 => db2haicu -delete
Option 2 =>
                   a) On any node, login as "root" user
                   b) Drop the domain by force
                         rmrpdomain -f 
                   c) Unset the DBM CFG parameter CLUSTER_MGR

1) HADR with DB2 Express 9.5 and DB2 Control Center

2) HADR Wiki (Best Practice)

3) HADR using db2haicu in DB2 9.5

4) Configure HADR using IBM Data Studio

5) HADR Simulator

6) HA database environment using WebSphere Middleware

7) Improving HA in WebSphere Commerce using DB2 HADR

8) Implement DB2 HADR in a TSA domain

9) DB2 HADR setup with TSA using db2haicu and Virtual IP

10) Configure DB2 Universal Database for UNIX to use OpenSSH

11) Redbook - HADR option for DB2 on LUW (pg 259)

12) Password less SSH configuration

12) IBM TSA for DB2 HA (Blog)

13) Enable database high availability using DB2 HADR and Tivoli SA MP in an SAP environment


14) IBM DB2 High Availability Solution: IBM Tivoli System Automation for Multiplatforms (03/2008)

15) IBM DB2 High Availability Solution: IBM Tivoli System Automation for Multiplatforms

16)  DB2 HADR - Case Study of Implementation

17) Build a highly available application platform for J2EE Part 5: Set up DB2 for HA using TSA

18) HA Configuration using IBM TSA with DB2 9.5 FP3 on IBM AIX v5.3

19) Integrating TSAMP with DB2 HADR v9.5

20) Restoring DB in a TSAMP automated DB2 HADR environment

21) DB2 HA configuration using TSA command - Page 113 - 118, Page 137 - 148

22) HA DB2 (Partitioned Database) using Tivoli System Automation

23) Introduction to Tivoli System Automation

24) DB2 Integrated Cluster Environment Deployment Guide Page 359 - 370

25) Clearing out IBM.RecoveryRM.log file

26)  Startup/Shutdown Procedure for DB2 9.5/9.7 HADR in TSAMP environment for maintenenace reason

27) DB2 HADR Performance Issue Monitoring

28) Setting up TSAMP cluster for maintenance, including node reboot 

29) db2stop but no failover in DB2 HADR in TSAMP environment 

30) No failover after db2_kill issued in DB2 HADR in TSAMP environment

31) DB2 HADR resource group remains locked after successful takeover 

32) SuspendedPropagated fro HADR group in TSAMP environment

33) ExcludedList for HADR resource group in TSAMP environment   


34) How to stop RSCT (TSAMP) from rebooting a node

35) Nominal State (Desired State) vs Operational State

36) The "resetrsrc" command - A brief how to guide

37) Service IP shows "Failed Offline" state when failover attempted

38) "2612-023" error code when attempting "resetrsrc" on "Failed Offline" standby resource

39) Using DB2 HADR with TSAMP