| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Enabling MQ on db2 |
« View previous topic :: View next topic » |
| Author |
Message
|
| Edrick |
 Posted: Mon Jun 25, 2007 10:53 am Post subject: Enabling MQ on db2 |
 |
|
Novice
Joined: 23 Apr 2007
Posts: 10
|
I'm trying to install and use the MQ Functions on DB2 (enable_MQFunctions) on a linux zSeries (64-bit) server that has Websphere MQ 6.0.2 and DB2 9.1.2, but for some unknown reason the enable_MQFunctions call won't complete successfully giving me an error of a missing library.
The error is:
The Specified library "libdb2qgmq.so" could not be loaded.
I checked the LD_LIBRARY_PATH pointed folders to see if the file is missing, but it isn't missing. I even tried to export the LD_LIBRARY_PATH; adding more paths to where the 64-bit library could be found, but it didn't help. I have being trying for a couple of days to solve this before asking for your guidance. Any help will be appreciated.
BTW, i have used the same steps and similar configuration approach on a Windows only environment and in a linux x86 pc environment without any problems. I don't know why it doesn't work on a linux zSeries system!  |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Mon Jun 25, 2007 12:35 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Did you review the section on "Implications of a 64-bit queue manager" in the linux Quick Beginnings guide?
Setting LD_LIBRARY_PATH may be causing problems, rather than solving them.
Are you seeing FDCs as well as the failure message in AMQERR0x.LOG?
You might try configuring the mqm user as if it was going to be doing XA with the DB2 instance - in terms of libraries and paths and etc - even if you don't end up configuring the qmgr itself to do XA.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Edrick |
| Posted: Wed Jun 27, 2007 4:22 am Post subject: |
|
|
Novice
Joined: 23 Apr 2007
Posts: 10
|
I followed your suggestions and researched more on things to know when you are using a 64-bit MQ Server. I managed to surpass my previous problem by unsetting LD_LIBRARY_PATH. The command didn't work at first because it was looking for the libmqm libraries so I ran the command specifying only LD_LIBRARY_PATH to be /opt/mqm/lib64, like this:
LD_LIBRARY_PATH=/opt/mqm/lib64 enable_MQFunctions -n SMS -u db2inst1 -p mypassword -v 0pc -q mqqmgr -force -novalidate
and it went successfully. So basically the MQ UDFs where installed. But now my final problem is that when I use any of those UDFs (with all parameters and definitions correctly done and created) it won't find the Queue. The test I did was a simple:
values db2mq.mqsend('MYSERVICENAME','MYPOLICYNAME','mymessage') ;
and will always give me the same error:
SQL0443N Routine "DB2MQ.MQSEND" (specific name "MQSEND3") has returned an error SQLSTATE with diagnostic text "rc=49=amSesOpen"). SQLSTATE=38H01
I have stumbled on this error before and on previous ocassions it was always a misspelled query name when defining it on the DB2MQ.MQSERVICE table. But now it's not (since i have checked several times all the system). I have ran this system (including my db2 functions and SPs) on Windows and Linux x86 as I said before. But now I am at a dead end on the last step of communication.
BTW I even reinstalled everything on another machine (only difference is that it is a linux x86) with the same installation scripts (db2 definitions and MQ definitions) and it ran as expected. But reinstalling my system on a linux zSeries 64-bit for a 4th time won't work.
Any comment or suggestion will be appreciated.
Thanks,
Edrick |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
