| Author |
Message
|
| Sam99 |
 Posted: Thu Jul 19, 2012 9:40 am Post subject: ODBC Driver FailOver capability |
 |
|
Apprentice
Joined: 19 Jul 2012
Posts: 43
|
Hello Guys,
I have a requirement to have the failover capability at ODBCdriver level while connectiong to SQL Database 2008. We use message broker version v6.1.0.3.
I have following queries,
1) Do we just need to do some configuration settings ?
2) Does it have any dependency on MB version. I heard that we got updated ODBC driver with MB v8 which automatically support this failover. I tried searching on it but couldnt get imuch nformation online.
Please help.. |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Thu Jul 19, 2012 9:48 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
1. IBM does not provide ODBC drivers for Microsoft products.
2. IBM does provide a product called solidDb which buffers database writes and can overcome a database outage condition.
3. WMB 6.1.0.3 is way out of date. You should be at least on 6.1.0.10 or greater.
4. WMB 6.1 will be end-of-life soon. Better to start planning your V8 migration now.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Sam99 |
| Posted: Fri Jul 20, 2012 2:03 am Post subject: |
|
|
Apprentice
Joined: 19 Jul 2012
Posts: 43
|
Thanks lanc..
Still wondering..
1) Does it need to be some kind configuration settings at the driver level to achieve this
2)If we plan to migrate to v8, do we have a solution for this ?
Currently we are working on AIX (6.1 TL6) |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Jul 20, 2012 4:53 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| Sam99 wrote: |
| 1) Does it need to be some kind configuration settings at the driver level to achieve this |
As previously stated, IBM does not provide ODBC drivers for SQL Server. Check with the ODBC driver's documentation and/or the vendor who provided them.
| Sam99 wrote: |
| 2)If we plan to migrate to v8, do we have a solution for this ? |
Yes. Whatever solution you find for v6.1 will still work for v8, because the ODBC position does not change for SQL Server between the 2 IBM versions.
In summary:
- WMBvAnything uses ODBC drivers but doesn't control them. Fail over or other activity is the province of the driver code not WMB
- Without knowing what SQL Server ODBC you're using no-one here can comment on what the code does or does not do
- I've never encountered an ODBC that fails over as you describe. This does not mean one does not exist.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Jul 20, 2012 5:17 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Sam99 wrote: |
Thanks lanc..
Still wondering..
1) Does it need to be some kind configuration settings at the driver level to achieve this
2)If we plan to migrate to v8, do we have a solution for this ?
Currently we are working on AIX (6.1 TL6) |
The solution is solidDb, which buffers database writes in an intermediate in-memory database.
Why do you keep asking the same question when a solution was provided? Did you not like to use solidDb?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Jul 20, 2012 5:26 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| lancelotlinc wrote: |
| [ Did you not like to use solidDb? |
I suspect the OP's client / employer doesn't like either the cost of solidDb and/or the introduction of another component.
The wisdom of either view can be challenged, especially as they want ODBC-level failover which is an interesting & unusual thing to want.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Sam99 |
| Posted: Fri Jul 20, 2012 6:39 am Post subject: |
|
|
Apprentice
Joined: 19 Jul 2012
Posts: 43
|
Thanks Lanc and Vitor..
@Vitor
Yes you are right.. as of now they are not OK with both i.e. intordcution of new component and cost..
is this the info you were asking for
/opt/IBM/mqsi/6.1/ODBC32/V5.3
/opt/IBM/mqsi/6.1/ODBC64/V5.3
@Lanc
Sorry if you felt I ask the same question again but because of the above two points I was thinking whether there is something which can be done at the driver level to support this failover. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Fri Jul 20, 2012 7:01 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Its ok Sam. Challenge your organization to use off-the-shelf components, like solidDb. Best wishes...
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Jul 20, 2012 8:08 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| Sam99 wrote: |
| whether there is something which can be done at the driver level to support this failover. |
Let's say there isn't. Why do you need to? What is the requirement this meets that more conventional failover strategies do not?
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| Vitor |
| Posted: Fri Jul 20, 2012 8:32 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| lancelotlinc wrote: |
| Challenge your organization to use off-the-shelf components, like solidDb. |
Does rather assume it's his organization, not an organization that's just bought his time.
One could legitimately say that there's no difference between the 2 cases, but experience teaches that, counter-intutively, organizations are more resistent to ideas coming from the "hired help".
Maybe I've just had bad experiences.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| rekarm01 |
| Posted: Fri Jul 27, 2012 2:12 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 1415
|
| lancelotlinc wrote: |
| 1. IBM does not provide ODBC drivers for Microsoft products. |
That's not entirely true:
| Quote: |
| ODBC drivers ... for SQL Server on Linux and UNIX systems are supplied with WebSphere Message Broker. Alternative drivers are not supported on these systems. |
But that probably won't help the OP either. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri Jul 27, 2012 4:32 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Well I'm thinking here about HA support of DB's ... So you have a DB that is made highly available and you want WMB to take advantage of that.
Case in point Oracle RAC...
I believe this all depends on the version of the ODBC driver, and as time goes on and versions move up you will get better support for these features...
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Sam99 |
| Posted: Mon Jul 30, 2012 8:07 am Post subject: |
|
|
Apprentice
Joined: 19 Jul 2012
Posts: 43
|
Thanks all for the all the help provided..
@fjb_saper,
We are connecting to Microsoft SQL server 2008. Do you know any Microsoft ODBC driver version which can provide this failover functionality ? |
|
| Back to top |
|
|
|
|
