473,406 Members | 2,217 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

Microsoft Cluster

FM
Hello:

Is it possible to have clustered two db2 instances?

Thanks in advance?

Oct 25 '06 #1
4 1413
it is fully supported.
use db2mscs.

FM wrote:
Hello:

Is it possible to have clustered two db2 instances?

Thanks in advance?
Oct 25 '06 #2
Not sure what you mean by "clustered two db2 instances". You can cluster
one instance using MSCS.

Larry Edelstein

FM wrote:
Hello:

Is it possible to have clustered two db2 instances?

Thanks in advance?
Oct 25 '06 #3
Ian
Larry wrote:
Not sure what you mean by "clustered two db2 instances". You can cluster
one instance using MSCS.
I'll bet the OP was asking if you have have 2 instances set up for
failover under MSCS. So, for example, both servers in a cluster are
active and acting as a failover for each other (as opposed to having
1 server just sitting idle).
And, as someone else pointed out, the answer to that question is yes.
Each instance appears as a separate group in the cluster adminisrator.

Oct 25 '06 #4
I don't believe DB2 supports this using MSCS if you mean active-active
.... same database ... without 3rd party sw. Now if the two databases are
different, that is a different story ... you can accomplish this using MSCS.

Larry Edelstein

Ian wrote:
Larry wrote:
>Not sure what you mean by "clustered two db2 instances". You can
cluster one instance using MSCS.

I'll bet the OP was asking if you have have 2 instances set up for
failover under MSCS. So, for example, both servers in a cluster are
active and acting as a failover for each other (as opposed to having
1 server just sitting idle).
And, as someone else pointed out, the answer to that question is yes.
Each instance appears as a separate group in the cluster adminisrator.
Oct 25 '06 #5

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

Similar topics

0
by: williams | last post by:
I am trying to encrypt data in a SQLServer 2000 Cluster using Microsoft EFS. I have successfully encrypted a standalone DB but we are having difficulty with the Cluster. I am only encrypting the...
2
by: richardshen | last post by:
Cluster Only supported in ESE?
1
by: richardshen | last post by:
DB2 V8 on windows 2003 cluster server. DB2MSCS -f:db2.cfg DB2 instance is in the cluster now. DB2MSCS -u:db2 DB2 instance is in the local node now. I want to cluster the instance again DB2MSCS...
0
by: Pankajdynamic | last post by:
Hi, I've gone through couple of articles on conguring the NLB cluster using NLB Manager.Below are my queries: 1. In NLB Manager, Cluster Parameter tab, - Can I give any IP address for Cluster...
4
by: ThunderMusic | last post by:
Hi, We have many servers setup as a cluster. When one server crashes, another one take the relay... We want to know if it's possible (I suppose it is) to make a Windows service developed with .NET...
2
by: dunleav1 | last post by:
I have a many row and many column table that is in a 16K page size. I have four indexes on the table. I am running row compression on the table. The table does not have a primary key. The table...
1
by: =?Utf-8?B?S2Vubnk=?= | last post by:
I have one bat file that contains a command to startup Java Program. Then, I would like to create a cluster job to call the bat file. In case of one computer is down, another computer can also call...
0
by: arichie | last post by:
Hi, We upgraded SQL 2005 instance on the Microsoft cluster. We have bunch of code which uses OSQL and BCP do not specify -S option since the code was running on the same server where sql was...
10
by: Ian | last post by:
Henry J. wrote: MDC *guarantees* clustering, whereas a table with a clustering index will eventually require maintenance (a.k.a. reorg) to maintain the cluster ratio. That's not to say that...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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...
0
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
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...

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.