Zach and Mark, thanks very much for your input. 
Plenty to think about

Regards
Paul 

-----Original Message-----
From: Linux on 390 Port [mailto:[email protected]] On Behalf Of
Zach Pratt
Sent: 22 July 2009 14:56
To: [email protected]
Subject: Re: WMB and DB2 Connect on z/Linux

Here's what we do:

Currently, we have a DB2 Connect Server (Application Server Edition
v9.5) running on one of our SLES guests which we use as a gateway to
each DB2 instance that we want to allow remote access to. If this is
what you're interested in, I recommend reading this: http://tr.im/tvfx

After you've got the DB2 Connect Server configured, then you'll want to
install either the Data Server Runtime Client or the Data Server Client
on each of your Linux guests or LPARS where you'll be hosting the WMB
server (or any other applications that need to connect to DB2 for z/OS).
Which client install depends on the needs of your applications. The main
difference for us is that the Data Server Client includes all the header
files, which are needed for compiling C and COBOL applications. I'm not
familiar with WMB, so I cannot give you a good recommendation.

After you've installed one of the Data Server Clients you can catalog
the tcp/ip node of the DB2 Connect Server and it's DB2 instance. This is
required if you need to use the type 2 jdbc drivers.

Once that's done your applications will each connect to the DB2 Connect
Server, which will forward requests to particular host database.

Hope that helps. I spent a great deal of time with this a couple years
ago when we first got started, so feel free to ask any other questions.

Zach

----- Original Message -----
From: "Mark Post" <[email protected]>
To: [email protected]
Sent: Tuesday, July 21, 2009 12:33:18 PM GMT -06:00 US/Canada Central
Subject: Re: WMB and DB2 Connect on z/Linux

>>> On 7/21/2009 at 10:11 AM, "Beesley, Paul"
<[email protected]> wrote:

> Hello
>
> We are installing WebSphere Message Broker on z/Linux to replace MQSI 
> on z/OS and have so far uploaded and installed WMB itself, MQ and DB2 
> We believe we need to install DB2 Connect to be able to run SQL 
> against
> DB2 files on the mainframe, but are confused as to what us actually 
> required.
> On IBM's download site ( Passport Advantage ) the options are :
> - IBM DB2 Connect Server 9.7 for Linux on System Z
> - IBM Data Server Runtime Client 9.7 for Linux on System Z
> - IBM Data Server Client 9.7 for Linux on System Z
>
> Has anyone already done this and can provide some advice ?

I've not done it, but I would suggest starting with DB2 Connect.


Mark Post

----------------------------------------------------------------------
For LINUX-390 subscribe / signoff / archive access instructions, send
email to [email protected] with the message: INFO LINUX-390 or
visit http://www.marist.edu/htbin/wlvindex?LINUX-390

----------------------------------------------------------------------
For LINUX-390 subscribe / signoff / archive access instructions, send
email to [email protected] with the message: INFO LINUX-390 or
visit http://www.marist.edu/htbin/wlvindex?LINUX-390


_______________________________________________________

Atos Origin and Atos Consulting are trading names used by the Atos Origin 
group.  The following trading entities are registered in England and Wales:  
Atos Origin IT Services UK Limited (registered number 01245534) and Atos 
Consulting Limited (registered number 04312380).  The registered office for 
each is at 4 Triton Square, Regents Place, London, NW1 3HG.The VAT No. for each 
is: GB232327983

This e-mail and the documents attached are confidential and intended solely for 
the addressee, and may contain confidential or privileged information.  If you 
receive this e-mail in error, you are not authorised to copy, disclose, use or 
retain it.  Please notify the sender immediately and delete this email from 
your systems.   As emails may be intercepted, amended or lost, they are not 
secure.  Atos Origin therefore can accept no liability for any errors or their 
content.  Although Atos Origin endeavours to maintain a virus-free network, we 
do not warrant that this transmission is virus-free and can accept no liability 
for any damages resulting from any virus transmitted.   The risks are deemed to 
be accepted by everyone who communicates with Atos Origin by email. 
_______________________________________________________

----------------------------------------------------------------------
For LINUX-390 subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO LINUX-390 or visit
http://www.marist.edu/htbin/wlvindex?LINUX-390

Reply via email to