| Author |
Message
|
| asajnani |
 Posted: Mon Sep 16, 2002 10:31 pm Post subject: Info needed for MQ server connecting to DB2 |
 |
|
Novice
Joined: 04 Mar 2002
Posts: 21
|
I have installed MQ Server V 5.2 on Windows NT 4.0 Server and also DB2 installed on the same machine. We want to connect MQ Server to DB2. The client should put messages( sql queries) on the queue and DB2 should pick it up from the queue, process it and return the recordset
on a reply queue. I understand that MQ Integrator can be used to accomplish this task. Please could someone point me to the appropriate documentation for this purpose.
 Anant |
|
| Back to top |
|
 |
| kirani |
| Posted: Tue Sep 17, 2002 3:57 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
You can use PASSTHRU ESQL function in WMQI to pass input message (sql query) to application database and retrieve resultset in a Compute node. You could then build your output message based on the return value.
For more info on PASSTHRU function pl. refer to WMQI ESQL reference manual
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| asajnani |
| Posted: Tue Sep 17, 2002 4:10 pm Post subject: DB2 Version 6.1 |
|
|
Novice
Joined: 04 Mar 2002
Posts: 21
|
I am currently using DB2 version 6.1. I hope this will be not be a problem.
Thanks Anant |
|
| Back to top |
|
|
| kirani |
| Posted: Tue Sep 17, 2002 4:16 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
DB2 6.1 is supported by MQSI so there will not be any problem!
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| asajnani |
| Posted: Tue Sep 17, 2002 4:37 pm Post subject: |
|
|
Novice
Joined: 04 Mar 2002
Posts: 21
|
Hey Kirani
I am using a model queue as a reply queue. I mention the dynamic queue name fromt the client. Will DB2 be able to put the message results on this dynamic queue using MQSI? |
|
| Back to top |
|
|
| kirani |
| Posted: Tue Sep 17, 2002 5:13 pm Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
DB2 is only processing your query and returning you the resultset. MQSI Primitive nodes manipulates your message.
MQOutput node (one of IBM Primitive node) is capable of writing messages to Dynamic queue.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
|
|
