Folks,

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
instance).

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.

Thanks

Phil