| Author |
Message
|
| wbintegrator |
 Posted: Mon Dec 24, 2007 2:42 am Post subject: Pl/Sql MQ API(mqpack-ma0i)-can be used for mq client as is? |
 |
|
Voyager
Joined: 08 Feb 2006
Posts: 83
|
Hi,
we've been successfully using it on unix and linux for over two years now.
recently we had the need to run the db on one server and the qmgr on the other (the servers are in cluster) and then we realized that we couldn't as the
wrapping package we are using, uses the pl/sql API with server connection (MQCONN) and it requires db and qmgr to be on the same server.
I wanted to change it to use client connection (MQCONNX) but then I noticed that the MQCD structure is missing(not defined) in MQPACK. Another way is to set the env var MQSERVER instead of using MQCD but it doesn't seem to be applicable in this case.
Has anyone managed to use client connection somehow?
MQCONNX requires the MQCNO which needs the missing MQCD...
Any help would be great. Thanks! |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Mon Dec 24, 2007 8:44 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Well if you want to switch from server to client you will need at least to relink the app with the appropriate libraries... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| wbintegrator |
| Posted: Tue Dec 25, 2007 3:26 am Post subject: |
|
|
Voyager
Joined: 08 Feb 2006
Posts: 83
|
Hey, thanks for reply.
That's correct, but that's the easiest part... The main problem is that the corresponding records and functions in pl/sql are not defined. That's quite a pain to "go back" to C now. Hoped somebody already got it working somehow. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Dec 25, 2007 4:47 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| wbintegrator wrote: |
Hey, thanks for reply.
That's correct, but that's the easiest part... The main problem is that the corresponding records and functions in pl/sql are not defined. That's quite a pain to "go back" to C now. Hoped somebody already got it working somehow. |
I don't expect that you would have anything to change in PL/SQL
Just make sure the PL/SQL pack is linked to the client libraries...
Use as well either the MQSeries environment variable or a client table to ensure you get a connection...
Have fun... 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| dcjs |
| Posted: Fri Aug 15, 2008 9:38 am Post subject: |
|
|
Acolyte
Joined: 10 Nov 2006
Posts: 53
Location: IBM Bangalore
|
Guys,
recently we had a requirement like we need to pull the records from Oracle database and dump the records on the queue.
Could someone explain what are the prerequisites for installing(ma0i) it.
Do we need to install MQ client on Database server.We ran into issues when running the script file provided by the support pac.
_________________
TRY TRY UNTIL U SUCCEED |
|
| Back to top |
|
|
|
|
