473,725 Members | 1,801 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DB2/UDB 8.1 HA Failover


All,

I am doing some preliminary research on HA failover capabilities on
DB2/UDB 8.1. The docs are a little light on details so I thought I'd ask
this forum ...

Let say I have a two node cluster (NodeA and NodeB) with each node
running its own instance of DB2/UDB (InstanceA and InstanceB) servicing
completely different databases and applications. I understand one
supported configuration is a "mutual failover" where each node monitors
the other and fails over under the right fault conditions.

My question is ... When the NodeA fails, does the original instanceB on
NodeB simply "mount" InstanceA's databases and run rollforward recovery
on its logs. Or when failover occurs, must an entire startup of DB2
occur (including all the costs associated with it such as allocating
memory, setting up buffer pools, etc ...)?

Perhaps it depends on the HA software used (HACMP vs Veritas, etc.), but
I imagine DB2/UDB iteself needs some capabilities to support failover to
an already running instance.

Thanks in advance

Peter
--
Posted via http://dbforums.com
Nov 12 '05 #1
1 2476
The disks must be shared in a twin tailed configuration. Typically, the
instance is started on NodeB using the IP address of the instance of
NodeA (so the applications that were connected to NodeA can reconnect to
the same IP address). When starting, the instance on NodeB performs
crash recovery, rolling forward through the log records generated by the
Instance on NodeA.

pthawley wrote:
All,

I am doing some preliminary research on HA failover capabilities on
DB2/UDB 8.1. The docs are a little light on details so I thought I'd ask
this forum ...

Let say I have a two node cluster (NodeA and NodeB) with each node
running its own instance of DB2/UDB (InstanceA and InstanceB) servicing
completely different databases and applications. I understand one
supported configuration is a "mutual failover" where each node monitors
the other and fails over under the right fault conditions.

My question is ... When the NodeA fails, does the original instanceB on
NodeB simply "mount" InstanceA's databases and run rollforward recovery
on its logs. Or when failover occurs, must an entire startup of DB2
occur (including all the costs associated with it such as allocating
memory, setting up buffer pools, etc ...)?

Perhaps it depends on the HA software used (HACMP vs Veritas, etc.), but
I imagine DB2/UDB iteself needs some capabilities to support failover to
an already running instance.

Thanks in advance

Peter
--
Posted via http://dbforums.com


Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2292
by: Sue | last post by:
I'm having a problem understanding how TAF to a standby database in jdbc would work. I currently have a production database with a standby database. I understand that I need to set some failover settings in the tnsnames.ora file and use the thick java jar files. What I don't understand is exactly how this would work. Suppose I have database on machine A and standby on machine B with TAF set up in the tnsnames files on both machines. ...
1
5876
by: Nico de Groot | last post by:
I have a 2 node Microsoft 2000 cluster with a shared storage device. I want to create automatic failover for MS SQL 2000 server. I can do that wit the following options: 1. Active/Pasive (one instance installed) 2. Active/Active (More then one instance/virtual sql servers installed) I have a question about option 2.
1
4278
by: kumar | last post by:
Dear Friends, I wanted to configure Failover cluster for SQL Server 2000 on Windows 2000 advanced servers. I have only 2 no.s of windows 2000 advanced server m/cs. I dont have any shared disks and SCSI drives. Can I still configure the Failover clustering? I would like to know more about the need for the shared disks in the
1
3035
by: news.microsoft.com | last post by:
Is there an elegant way to clear out the ADO connection pool used by the SQL Server State Service following a cluster failover? We are using a SQL Cluster to store both the ASP Session State database and our application database. When the SQL Server cluster is failed-over, any "pointers" to the live connections stored in the connection pool are made invalid. When the application tries to reference these "damaged" connections, it throws...
5
3107
by: uspensky | last post by:
We are trying to setup a system to system failover cluster using two nodes (x346) which each have a single hba running to seperate controllers on the DS400. For full redundnancy, IBM recommends dual path from each node but we dont need that. The current setup has two completly seperate paths. hba on node 1 to controller A on DS400 and hba on node 2 to controller B. If i take a controller offline, failover works fine to jumo to other...
1
2555
by: theSpinel | last post by:
Is it possible to failover a single or a selected number of databases onto a standby server? We're currently log shipping about 12 databases to a standby and I was wondering if it was possible to randomly failover onto selected dbs. My understanding of log shipping is that when the primary server goes down, the standby takes over. But, does that mean that all of the db's on the standby server now become the primary? Or, can failover...
3
4581
by: afreema | last post by:
I am interested in failover for DB2 Version 9 on an AIX environment. Can you give me any recommendations?
0
8011
by: Vinod Sadanandan | last post by:
Fast-Start Failover An Overview In Dataguard Environment ============================================================================= This article describes the automatic fast start failover configuration and the conditions for trigerring a fast start failover in dataguard environment . In Faststart failover dataguard configuration if the primary database becomes unavailable, the...
8
2721
by: Guy Macon | last post by:
How to increase web server uptime with DNS failover: For illustration, let's start with some really bad hosting... Find four free web hosts that are each 90% reliable -- in other words they each are down on average one day out of ten. Use a failover DNS system with monitoring to switch servers if one fails. On average: One server will be down one day out of ten
0
8751
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9401
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9108
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8093
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6702
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6010
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4514
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4781
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3218
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.