MQSeries.net :: View topic - Accessing DB2 on mainframe from broker v6 on Solaris

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Accessing DB2 on mainframe from broker v6 on Solaris

Accessing DB2 on mainframe from broker v6 on Solaris

« View previous topic :: View next topic »

Author

Message

ydsk

Posted: Thu Jul 06, 2006 4:34 pm Post subject: Accessing DB2 on mainframe from broker v6 on Solaris

Chevalier

Joined: 23 May 2005
Posts: 410

There is a requirement to avoid using MQ altogether(cust costs) and have msgflows on a v6 broker ( on Solaris) GET input data from a DB2 database on mainframe and process it and send it to the other end application via HTTP.

I think broker needs a ODBC connection to access any database. But I am not sure if we can access a mainframe database using ODBC.

My question is: Can we access a DB2 database residing on a mainframe from a msgflow running on Solaris ?

If anyone has done this earlier please advise.

Please don't post what you think might work. I want to know if it works for sure.

Thanks in advance.

wschutz

Posted: Thu Jul 06, 2006 4:38 pm Post subject:

Jedi Knight

Joined: 02 Jun 2005
Posts: 3316
Location: IBM (retired)

How does doing that remove the requirement for MQ? The broker MUST have a local qmgr for its operation (deployment, control, local state storage &c...)
_________________
-wayne

ydsk

Posted: Thu Jul 06, 2006 4:40 pm Post subject:

Chevalier

Joined: 23 May 2005
Posts: 410

broker must use MQ...and I know it. The requirement is to avoid using MQ on the mainframe side.

thanks.

jefflowrey

Posted: Thu Jul 06, 2006 7:03 pm Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

You can use a DB2 client to access a mainframe database.

You will need assistance from your mainframe database administrator to get this client configured properly. Then once the mainframe database is catalogued into the client configuration, it will be available as an ODBC datasource.
_________________
I am *not* the model of the modern major general.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Accessing DB2 on mainframe from broker v6 on Solaris

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP