Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Db2, Oracle, SQL Server
Noons wrote:
> Serge Rielau wrote:
>
>
>>I don't kno whwat the latter means, and I have in detail talked about
>>the first point. It is irrelevant whether DB2 requires all the nodes
>>or not as long as a node can fail over similarly quick as it takes
>>RAC to evict a node (which is not free!)
> And what happens in a cluster if the partition you wanted
> is on the node that you just offlined?
> Last time I looked,
> RAC keeps operating blissfully smooth.
Is that what you call the complete outage while remastering the
ownership of pages?
> I can't say the same
> for a SELECT statement that has as a parameter the partition
> you want to access...
> Transparency is completely out the window ages ago, anyways.
Just presuming you were right with the select (which I challenge)
Why would the node stay offline? This is exactly what I was talking
about. You have to kiss goodbye to the notion that nodes go down and
stay down. We have customers doing node failover in < 20 sec.
Evicting a node in RAC is in the same ballpark.
Different approach same outcome.
If it's a software problem db2start on the same physical node. If the
machien is dead. db2start on a different machine. HACMP does that just fine.
Cheers
Serge
-- Serge Rielau DB2 SQL Compiler Development IBM Toronto LabReceived on Fri Feb 11 2005 - 07:03:20 CST