| Author |
Message
|
| Goodfellas |
 Posted: Wed Jul 11, 2012 7:17 am Post subject: connecting |
 |
|
Acolyte
Joined: 26 Feb 2009
Posts: 70
|
Hello,
Last edited by Goodfellas on Tue May 28, 2013 12:12 pm; edited 1 time in total |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Wed Jul 11, 2012 7:23 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| Yes, you need a DB2 client. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Jul 11, 2012 7:39 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
Not recommended to connect WMB to databases due to the way WMB manages DB connections. If you have high volume or low latency requirement, you should front-end your DB access with a Web Service.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jul 11, 2012 7:40 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| lancelotlinc wrote: |
| Not recommended to connect WMB to databases due to the way WMB manages DB connections. |
Not recommended by you.
I recommend it highly.
Provided a proper understanding of the requirements for the database access is achieved. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Jul 11, 2012 7:46 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| mqjeff wrote: |
| lancelotlinc wrote: |
| Not recommended to connect WMB to databases due to the way WMB manages DB connections. |
Not recommended by you.
I recommend it highly.
Provided a proper understanding of the requirements for the database access is achieved. |
Also not recommended by the IBM consultant.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jul 11, 2012 7:50 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| lancelotlinc wrote: |
| Also not recommended by the IBM consultant. |
Assuredly based on a proper understanding of your specific requirements for your specific implementation. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Jul 11, 2012 8:12 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| mqjeff wrote: |
| lancelotlinc wrote: |
| Also not recommended by the IBM consultant. |
Assuredly based on a proper understanding of your specific requirements for your specific implementation. |
I don't know how these would be different for any other user?
If I have one message flow that makes three database connections, and I run nine additional instances for a total of ten instances of that message flow, how many DB2 connections are required for that message flow? And if I have twenty other message flows of similar scope, then how many DB2 connections are required? hundreds upon hundreds.
Whereas if I replace my DB2 connections with SOAPRequest nodes, then how many DB2 connections are needed: only one.
Seems very simple. Hopefully WMB version 9 can address this inefficient use of database connections.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jul 11, 2012 8:31 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| lancelotlinc wrote: |
| Also not recommended by the IBM consultant. |
Provide a name, and also confirm if this person was:
- an IBM employee
- an IBM consultant provided by IBM Global Services
- an indepentant consultant who specialises in IBM products (which is a definition I've heard for "IBM consultant")
Please also provide the PMR number and/or IBM technote reference describes this WMB behaviour.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jul 11, 2012 8:57 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| lancelotlinc wrote: |
| mqjeff wrote: |
| lancelotlinc wrote: |
| Also not recommended by the IBM consultant. |
Assuredly based on a proper understanding of your specific requirements for your specific implementation. |
I don't know how these would be different for any other user? |
I agree that you have difficulty with this.
I agree that there are complications and difficulties with how Broker scales ODBC database connections.
I do not agree that these always mean that you should never ever use ODBC database connections.
I also encourage you to determine for yourself where, exactly, this thread made any requirement or discussion on ODBC connections. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Jul 11, 2012 10:08 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| mqjeff wrote: |
| lancelotlinc wrote: |
| mqjeff wrote: |
| lancelotlinc wrote: |
| Also not recommended by the IBM consultant. |
Assuredly based on a proper understanding of your specific requirements for your specific implementation. |
I don't know how these would be different for any other user? |
I agree that you have difficulty with this.
I agree that there are complications and difficulties with how Broker scales ODBC database connections.
I do not agree that these always mean that you should never ever use ODBC database connections.
I also encourage you to determine for yourself where, exactly, this thread made any requirement or discussion on ODBC connections. |
All of your statements are true.
I qualified my recommendation by saying if latency or volume were needed.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Jul 11, 2012 10:10 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Vitor wrote: |
| lancelotlinc wrote: |
| Also not recommended by the IBM consultant. |
Provide a name, and also confirm if this person was:
- an IBM employee
- an IBM consultant provided by IBM Global Services
- an indepentant consultant who specialises in IBM products (which is a definition I've heard for "IBM consultant")
Please also provide the PMR number and/or IBM technote reference describes this WMB behaviour. |
I don't know if he is IBM W-2 or contract. I suspect W-2. He was provided by IBM Global Services AFAIK.
According to his linkedin profile since 2001, "Senior WebSphere Integration Architect at IBM Raleigh-Durham, North Carolina Area "
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jul 11, 2012 10:34 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| lancelotlinc wrote: |
| According to his linkedin profile since 2001, "Senior WebSphere Integration Architect at IBM Raleigh-Durham, North Carolina Area " |
That's a short list of suspects. 
Is there a PMR and/or technote that backs this up? Because this isn't your recommendation it's his as well, and those of us with high volume, low latency flows involving databases will need supporting evidence for a fronting web service to be built.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Jul 11, 2012 10:47 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Vitor wrote: |
| lancelotlinc wrote: |
| According to his linkedin profile since 2001, "Senior WebSphere Integration Architect at IBM Raleigh-Durham, North Carolina Area " |
That's a short list of suspects.
Is there a PMR and/or technote that backs this up? Because this isn't your recommendation it's his as well, and those of us with high volume, low latency flows involving databases will need supporting evidence for a fronting web service to be built. |
If you really want me to, I will open a PMR on it. However, I think this would be so obvious a common requirement that the WMB product architect should already have it on the drawing board, no?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Jul 11, 2012 11:35 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| lancelotlinc wrote: |
| If you really want me to, I will open a PMR on it. However, I think this would be so obvious a common requirement that the WMB product architect should already have it on the drawing board, no? |
No, no, you misunderstand my direction. I'm not talking about future developments, better handling of database connections or how to make a fluffy pancake.
I'm focused entirely on the here and now, with the product we have now, and the situation that someone in good standing with IBM has recommended this course of action to you when faced with this circumstance.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Wed Jul 11, 2012 12:08 pm Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| Vitor wrote: |
| lancelotlinc wrote: |
| If you really want me to, I will open a PMR on it. However, I think this would be so obvious a common requirement that the WMB product architect should already have it on the drawing board, no? |
No, no, you misunderstand my direction. I'm not talking about future developments, better handling of database connections or how to make a fluffy pancake.
I'm focused entirely on the here and now, with the product we have now, and the situation that someone in good standing with IBM has recommended this course of action to you when faced with this circumstance. |
I'm still unclear of what your question is.
Our local requirement is to process online insurance policy purchases and online insurance policy claims. To do this, we have to support a reasonable latency (seven seconds is the goal). In a given day, we could process tens of thousands of new policy purchases or claims. Each one of these, a human is waiting for a response. Therefore, we have to have sufficient additional message flow instances to handle the peak load.
As identified above, a direct connection to DB2 is not possible due to the number of connections.
This seems like a pretty common business requirement, not unique to this client site. If other people have handled this differently, I'm open to suggestions.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
|
|
