MQ Functions on DB2 for LUW V8.2 - 04-14-2005 , 02:52 PM
I'm wondering if anyone out there actually has a working implementation of
the MQ SQL functions, and if so if they can offer some advice to a poor
struggling MQ novice.
I've got MQ set up and working (I've used it to test DB2 II Q Rep).
I've installed the MQ AMI, as supplied in sqllib/cfg/mq. I've set the
recommended AMT path variable (AMT_DATA_PATH=/home/db2inst1/sqllib/cfg/mq),
and passed it through to DB2 using DB2ENVLIST (and remembered to start the
I already have a queue manager (lets call it MYQUEUE).
I've run -
enable_MQFunctions -n DBTST001 -u db2inst1 -p password -v 0pc -q MYQUEUE
This seemed to work.
When I call -
VALUES DB2MQ.MQSEND('Testing 123')
I get -
SQL0443N Routine "DB2MQ.MQSEND" (specific name "MQSND1") has returned an
error SQLSTATE with diagnostic text "rc=110:amSesOpen". SQLSTATE=38H01
Anyone tell me what I'm doing wrong ?
I suspect I need to set up some MQ queues manually, and then define them to
DB2 in the xml files in cfg/mq, but I don't know how.