| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| configure MQ Series in DB2 problem! |
« View previous topic :: View next topic » |
| Author |
Message
|
| TonyD |
 Posted: Mon Sep 30, 2002 7:48 pm Post subject: |
 |
|
Knight
Joined: 15 May 2001
Posts: 540
Location: New Zealand
|
Do you have a queue DB2MQ_DEFAULT_Q defined to a queue manager DB2MQ_DEFAULT_QM.....
You say that you are configuring for a second database? Does that mean you have already configured 'enable_MQ' for a database and have successfully tested the functions? If so, did you alter the settings for the default service and/or policy?
Check p533 on the manual...it suggests that rc 49 usually indicates an error when trying to open a queue, either becuase it does not exist or because of a mismatch in the 'amt.xml' file. |
|
| Back to top |
|
 |
| fcho |
| Posted: Tue Oct 01, 2002 2:32 am Post subject: |
|
|
Apprentice
Joined: 29 May 2002
Posts: 28
|
Yes, all the Q ,services and Policy are correct and I'ved tried the same amt.xml & amthost.xml with the supplied sample program amtsosnd.c (just change the policy & service in the program) and its work fine. Only DB2 don't know what is the problem.
I tried a few time to disable_MQFunctions and enable_MQFunctions again but still the same, now even my previous workabled Database also failed after I disabled and enabled it. I really don't know how to solve this, can any body help on this?
_________________
Regards,
fcho |
|
| Back to top |
|
|
| TonyD |
| Posted: Tue Oct 01, 2002 2:40 pm Post subject: |
|
|
Knight
Joined: 15 May 2001
Posts: 540
Location: New Zealand
|
Well, I still stick to my earlier reply...there is probably something wrong in the MQ side of things.
I have just applied DB2 7.2 FP7 so have rebuilt my environment and run 'enable_MQFunctions' against TDTESTDB. This worked correctly. I then executed a 'db2mq.mqsend' exactly as you did, which worked. I then deleted 'DB2MQ_DEFAULT_Q' and ran the command again. This time I got:
SQL0443N Routine"DB2MQ.MQSEND" (specific name "MQSND1") has returned an error SQLSTATE with diagnostic text "rc=49:amSndOpen". SQLSTATE 38H01.
This is the same message that you got. Finally I recreated the queue and ran the command again; this time it was successful.
Any chance of sending me copies of your amt.xml and amthost.xml files? |
|
| Back to top |
|
|
| fcho |
| Posted: Tue Oct 01, 2002 5:51 pm Post subject: |
|
|
Apprentice
Joined: 29 May 2002
Posts: 28
|
Hi TonyD,
I found something, I found that my DB2ENVLIST always changed by other peoples where my AMT_DATA_PATH always missing. So after I put back the AMT_DATA_PATH and restart DB2, I'm able to use db2mq.mqsend with my own create amt.xml & amthost.xml. But I'm still getting error when I execute enable_MQFunctions as below :
/home/db2inst1/sqllib/cfg >> enable_MQFunctions -n TSTDB -u dbabc -p dbabc
(0) db2mq UDFs were found
-- Create MQ Functions ...
Validate MQ Functions ...
*** Error -- while validating DB2MQ functions
Please check that:
1. repository files and amt.dtd file are present in directory AMT_DATA_PATH
2. 'DB2.DEFAULT.SERVICE' is pointing to
queue_manager: DB2MQ_DEFAULT_MQM
queue: DB2MQ_DEFAULT_Q
3. 'DB2.DEFAULT.POLICY' is pointing to
connection name: connectionDB2MQ
4. amthost.xml contains 'connectionDB2MQ = DB2MQ_DEFAULT_MQM'
*** enable_MQFunction finished with error
*** Please allow a few seconds to clean up the system ......
/home/db2inst1/sqllib/cfg >> db2set
DB2LIBPATH=/usr/lib:/lib:/home/db2inst1/sqllib/lib
DB2ENVLIST=EXTSHM AMT_DATA_PATH
/home/db2inst1/sqllib/cfg >> env |grep AMT
AMT_DATA_PATH=/home/db2inst1
/home/db2inst1/sqllib/cfg >> ls -l /home/db2inst1/amt*
-rw-r--r-- 1 db2inst1 db2iadm1 41202 Oct 01 21:18 /home/db2inst1/amt.dtd
-rw-r--r-- 1 db2inst1 db2iadm1 20281 Oct 01 21:18 /home/db2inst1/amt.xml
-rw-r--r-- 1 db2inst1 db2iadm1 231 Oct 01 21:18 /home/db2inst1/amthost.xml
Trying using DB2 with original amt.xml:
db2 => values db2mq.mqsend('A TEST');
1
-
SQL0443N Routine "DB2MQ.MQSEND" (specific name "MQSND1") has returned an
error SQLSTATE with diagnostic text "rc=406:amSesCreateSender".
SQLSTATE=38H01
After that I changed the AMT_DATA_PATH to different amt.xml, its successful :
/home/db2inst1/sqllib/cfg >> export AMT_DATA_PATH=/home/mqm
/home/db2inst1/sqllib/cfg >> ls -l $AMT_DATA_PATH/amt*
-r--r--r-- 1 mqm mqm 47388 Aug 12 15:30 /home/mqm/amt.dtd
-rwxr--r-- 1 mqm mqm 60923 Oct 01 19:27 /home/mqm/amt.xml
-rw-r--r-- 1 mqm mqm 2699 Oct 01 19:28 /home/mqm/amthost.xml
db2 => values db2mq.mqsend('QUEUE1.SRV', 'QUEUE1.POL', 'A TEST');
1
-
1
1 record(s) selected.
Did you facing any problem when execute enable_MQFunctions? Try to send amt.xml and amthost.xml to your tdevit3@attglobal.net eamil but undeliverabled. How can I send over the files?
Thanks.
Regards,
fcho[/img][/list]
_________________
Regards,
fcho |
|
| Back to top |
|
|
| TonyD |
| Posted: Tue Oct 01, 2002 7:41 pm Post subject: |
|
|
Knight
Joined: 15 May 2001
Posts: 540
Location: New Zealand
|
Sorry...will update my profile...try 'tony_devitt@cgu.com.au'. I see you are on Unix whereas all my testing has been on NT...still, should not make a difference.
You certainly must have the environment variable set and pointing to a directory that contains amt.dtd, amthost.xml, amt.xml. It looks as if you might have been running against an invalid amt.xml. I assume that you put QUEUE1.SRV and QUEUE1.SRV into an amt.xml file which is in the /home/mqm path. Does that file also have the default service and policy defined in it?
I don't think the warning messages in 'enable_MQFunctions' are necessarily a problem.....so long as you validate the checks in the messages re files, definitions etc. |
|
| Back to top |
|
|
| fcho |
| Posted: Tue Oct 01, 2002 10:22 pm Post subject: |
|
|
Apprentice
Joined: 29 May 2002
Posts: 28
|
Hi TonyD,
I know why I encountered *** Error -- while validating DB2MQ functions when enable_MQFunctions, this is because of my default settting for EXTSHM=ON, this suppose to EXTSHM=OFF which bower5932 mentioned before. Any where thanks for your help.
_________________
Regards,
fcho |
|
| Back to top |
|
|
|
|
|
|
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
|
|
|
|
