MQSeries.net :: View topic - IIB and DB2 Integration / Setting up db (Configuring DSN)

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 » IIB and DB2 Integration / Setting up db (Configuring DSN)

IIB and DB2 Integration / Setting up db (Configuring DSN)

« View previous topic :: View next topic »

Author

Message

sijumohanmm

Posted: Sat Nov 19, 2016 10:44 pm Post subject: IIB and DB2 Integration / Setting up db (Configuring DSN)

Newbie

Joined: 22 Aug 2014
Posts: 3

I have been working with IIB development for a while. But since I am not involved with administrative tasks, I couldn't figure out how db2 is tied with IIB.

While creating a message flow, we specify only DSN (Data Source Name). How does the system identify DB2 from this DSN? Where is this configuration exists?

Hope my doubt is clear, let me know if it is not.

smdavies99

Posted: Sat Nov 19, 2016 11:14 pm Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

you need to define the ODBC connection to broker.

the

Code:

mqsisetdbparms

command is your friend here

as is the

Code:

mqsicvp

command.

There are plenty of posts here about setting up the connection as well as that thing that people don't seem to even consider these days, the documentation.

As this is DB2, you may well have to install the correct dB2 client software first but this is described.

It is all there (in one or other of the sources) so go take a look, do some experimentation and if you run into issues then come back and tell us what you did, and what went wrong including a full description of the errors you are seeing.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » IIB and DB2 Integration / Setting up db (Configuring DSN)

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