| Author |
Message
|
| Amitha |
 Posted: Wed Sep 29, 2010 5:45 am Post subject: DB2 Licensing question |
 |
|
Voyager
Joined: 20 Nov 2009
Posts: 80
Location: Newyork
|
Hi Folks,
If we need to connect to DB2 application database from WMB v7.0 Message flow, do we need pay any license fee for installing DB2 Client on WMB Box.
Actually, this is an question to IBM sales Rep, but I wanted to ask the experts here fearing sales rep might come back and say yes you would have to pay  |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Wed Sep 29, 2010 5:52 am Post subject: Re: DB2 Licensing question |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
| Amitha wrote: |
Hi Folks,
If we need to connect to DB2 application database from WMB v7.0 Message flow, do we need pay any license fee for installing DB2 Client on WMB Box.
Actually, this is an question to IBM sales Rep, but I wanted to ask the experts here fearing sales rep might come back and say yes you would have to pay |
usually the DB2 client is free licenced to all. I guess the same applicable for you as well
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| zpat |
| Posted: Wed Sep 29, 2010 5:59 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
| Quote: |
The broker makes connections via ODBC and, in the case of DB2, the ODBC driver always connects to the database, be it local or remote, via the DB2 client.
So, first a DB2 client definition (i.e. an 'alias') for the remote database must be made and then an ODBC definition made which points to the database alias.
There is no charge required for client interconnection amongst distributed platforms (UNIX, Linux, Windows) but IBM charges for, and enforces by license, connections from distributed client to host databases, i.e. DB2 servers on zOS or iSeries. Up to DB2 v8.2 this host connection functionality was provided by the DB2 Connect product. From DB2 9, the clients were re-architected to be capable of host connection but a chargeable license is still required to use it to connect to host databases.
In summary, DB2 Connect function and license is required only if connecting from distributed broker to a host database; distributed broker to distributed DB2 works out of the box for no additional charge. |
Last edited by zpat on Wed Sep 29, 2010 6:00 am; edited 1 time in total |
|
| Back to top |
|
|
| Amitha |
| Posted: Wed Sep 29, 2010 5:59 am Post subject: |
|
|
Voyager
Joined: 20 Nov 2009
Posts: 80
Location: Newyork
|
Thanks Gayathri for quick reply.
Sorry I forgot to mention DB2 is on Mainframe z/OS. |
|
| Back to top |
|
|
| zpat |
| Posted: Wed Sep 29, 2010 6:01 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
Yes, you have to pay for that option.
Generally a better design to send z/OS a MQ message, and have something on the mainframe (e.g. a CICS transaction) perform the database access and return the result in another MQ message.
This is more decoupled and avoids the license issue. |
|
| Back to top |
|
|
| Amitha |
| Posted: Wed Sep 29, 2010 6:18 am Post subject: |
|
|
Voyager
Joined: 20 Nov 2009
Posts: 80
Location: Newyork
|
| Quote: |
| Generally a better design to send z/OS a MQ message, and have something on the mainframe (e.g. a CICS transaction) perform the database access and return the result in another MQ message. |
Hi zpat,
Thanks for your reply. Actually we are migrating from WMB v6.1 to v7.0.
In v6.1, we have broker and application database on remote Mainframe server, and accessed DB2 through DB2 client catalog from WMB box. We didn't have to purchase any license to do this(may be because DB2 comes with WMB, I am not sure).
Now, since we are migrating to WMB v7,DB2 no longer comes with WMB, we still need to connect to mainframe application DB(which actually stores dynamic routing info, some other states required by WMB). Do we still to purchase license for DB2 client? |
|
| Back to top |
|
|
| zpat |
| Posted: Wed Sep 29, 2010 8:07 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
Hmm, read my above post - you should have paid IBM a license fee to connect from WMB 6.1 to DB2 on z/OS.
So you still should pay a license fee to install DB2 connect on WMB 7. This might be an expensive way of having a database. Perhaps you can port it to another platform.
Contact your IBM account rep for clarification, I asked the same question (about WMB 6.1) and the answer I received was the one I quoted above. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Sep 29, 2010 8:21 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| Amitha wrote: |
| We didn't have to purchase any license to do this(may be because DB2 comes with WMB, I am not sure). |
I'm not sure either, but AFAIK the DB2 that come bundled with WMB is on a limited license that only allows it's use with WMB to support WMB functions.
As before, only your IBM rep can accurately answer your license questions.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| mqmatt |
| Posted: Wed Sep 29, 2010 9:26 am Post subject: |
|
|
Grand Master
Joined: 04 Aug 2004
Posts: 1213
Location: Hursley, UK
|
As Vitor says, chat to your IBM account rep. You need a DB2 license to store your own data in DB2.
| http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=877&letternum=ENUSZP07-0437 wrote: |
3. IBM DB2 Restricted Enterprise Edition
Limited use license DB2 Restricted Enterprise Edition: DB2 Restricted Enterprise Edition includes portions of DB2 Enterprise Server Edition V9.1. You are authorized to install and use one copy of this Program only in association with Your licensed use of WebSphere Message Broker for the storage and management of data used and generated by the other IBM program, and not for other data management purposes. DB2 Restricted Enterprise Edition is to be used only by the internal components of the program. For example, DB2 Restricted Enterprise Edition can be used as a repository for configuration information generated by WebSphere Message Broker and cannot be used to build or extend custom applications that store business data; this license does not permit inbound connections to the database from other applications for queries or report generation. You are not authorized to install any separately purchasable features that are available for DB2 unless You purchase a fully licensed version of DB2. |
|
|
| Back to top |
|
|
| zpat |
| Posted: Wed Sep 29, 2010 10:48 am Post subject: Re: DB2 Licensing question |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
| Gaya3 wrote: |
| Amitha wrote: |
Hi Folks,
If we need to connect to DB2 application database from WMB v7.0 Message flow, do we need pay any license fee for installing DB2 Client on WMB Box.
Actually, this is an question to IBM sales Rep, but I wanted to ask the experts here fearing sales rep might come back and say yes you would have to pay |
usually the DB2 client is free licenced to all. I guess the same applicable for you as well |
Not free when used to connect to i-Series or z-Series databases. But not necessary that expensive. |
|
| Back to top |
|
|
|
|
