| Author |
Message
|
| rkford11 |
 Posted: Thu Nov 11, 2004 3:17 pm Post subject: cluster and ODBC connection |
 |
|
Partisan
Joined: 06 Jun 2004
Posts: 316
|
When ever we have a cluster of brokers(broker on two different systems) do we have to have the ODBC connection for both
systems to access the database for insertion/deletion/update through the compute/database nodes in the message flow.
Thanks |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Nov 11, 2004 4:43 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What information have you seen that suggests that you wouldn't need to have both systems set up with an ODBC connection?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| vennela |
| Posted: Thu Nov 11, 2004 6:40 pm Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| rkford11 wrote: |
| When ever we have a cluster of brokers(broker on two different systems) |
Looks like he is talking about OS clustering like HACMP.
rkford11:
You should probably frame the question right. |
|
| Back to top |
|
|
| rkford11 |
| Posted: Thu Nov 11, 2004 7:05 pm Post subject: |
|
|
Partisan
Joined: 06 Jun 2004
Posts: 316
|
| vennela wrote: |
| rkford11 wrote: |
| When ever we have a cluster of brokers(broker on two different systems) |
Looks like he is talking about OS clustering like HACMP.
rkford11:
You should probably frame the question right. |
Thanks everybody.
Thanks vennela, yaa i am talking about high availability clustering. i will go on with odbc connection on both systems. |
|
| Back to top |
|
|
| vennela |
| Posted: Fri Nov 12, 2004 6:29 am Post subject: |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
I took a quick look at the support pac IC61. Here is what is says
| Quote: |
In AIX, a message broker makes use of the /var/mqsi/brokers/<broker> directory and the
/var/mqsi/registry/<broker> directory, so these directories need to be on shared disks in addition to
the directories used by the queue manager and broker database instance. |
So, looks like your /var/wmqi/odbc is local to each node.
Not sure of your OS, but you should read the documentation that comes along with the support pac alteast three times to understand what you are doing. |
|
| Back to top |
|
|
| rkford11 |
| Posted: Fri Nov 12, 2004 7:09 am Post subject: |
|
|
Partisan
Joined: 06 Jun 2004
Posts: 316
|
| vennela wrote: |
I took a quick look at the support pac IC61. Here is what is says
| Quote: |
In AIX, a message broker makes use of the /var/mqsi/brokers/<broker> directory and the
/var/mqsi/registry/<broker> directory, so these directories need to be on shared disks in addition to
the directories used by the queue manager and broker database instance. |
So, looks like your /var/wmqi/odbc is local to each node.
Not sure of your OS, but you should read the documentation that comes along with the support pac alteast three times to understand what you are doing. |
Thanks Vennela, But the OS we are using is windows. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Fri Nov 12, 2004 7:15 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| rkford11 wrote: |
| Thanks Vennela, But the OS we are using is windows. |
Does MSCS allow you to put an ODBC connection into a unit of failover?
If no, then you need to define it on both boxes.
If yes, then you don't.
Please consult your MSCS documentation, or your Windows System Administrator.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| kirani |
| Posted: Fri Nov 12, 2004 11:30 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
AFAIK MSCS does not fail-over your DSN names. So, you will have to define them on both the boxes.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
|
|
