Author |
Message
|
fcho |
Posted: Wed Sep 18, 2002 10:50 pm Post subject: configure MQ Series in DB2 problem! |
|
|
Apprentice
Joined: 29 May 2002 Posts: 28
|
Hi,
When I configured MQ series to intergrate with DB2 using enable_MQFuntions in AIX box, I encountered below error :
/home/db2inst1/sqllib/cfg> enable_MQFunctions -n db1 -u db2inst1 -p db2inst1
*** Please wait: creating queue manager (DB2MQ_DEFAULT_MQM) ......
*** Please wait: starting the queue manager (DB2MQ_DEFAULT_MQM) ......
*** Error -- while connecting to DB2MQ_DEFAULT_MQM failed (reason code -- 2058)
crtmqm/strmqm has been issued
*** Problem -- while checking MQ
Please ensure that the user has permission to create/start start queue manager
Please ensure that the user has permission to create a queue
*** enable_MQFunctions Failed .....
Please ensure that MQSeries is installed properly
*** Please allow a few seconds to clean up the system ......
Any body know why? Fyi, I'm using db2inst1 to configure and my DB2 instance is belong to db2inst1 also.
Thanks
Regards,
fcho |
|
Back to top |
|
 |
dgolding |
Posted: Thu Sep 19, 2002 3:25 am Post subject: |
|
|
 Yatiri
Joined: 16 May 2001 Posts: 668 Location: Switzerland
|
Obvious question, but is your user ID in the "mqm" group? |
|
Back to top |
|
 |
fcho |
Posted: Thu Sep 19, 2002 3:34 am Post subject: |
|
|
Apprentice
Joined: 29 May 2002 Posts: 28
|
|
Back to top |
|
 |
dgolding |
Posted: Thu Sep 19, 2002 3:42 am Post subject: |
|
|
 Yatiri
Joined: 16 May 2001 Posts: 668 Location: Switzerland
|
Strange - what happens when you do the crtmqm and strmqm manually - what errors do you get?
crtmqm DB2MQ_DEFAULT_MQM
strmqm DB2MQ_DEFAULT_MQM |
|
Back to top |
|
 |
fcho |
Posted: Thu Sep 19, 2002 4:15 am Post subject: |
|
|
Apprentice
Joined: 29 May 2002 Posts: 28
|
Hit error below :
crtmqm DB2MQ_DEFAULT_MQM
AMQ8101: Unexpected error (893). |
|
Back to top |
|
 |
dgolding |
Posted: Thu Sep 19, 2002 4:19 am Post subject: |
|
|
 Yatiri
Joined: 16 May 2001 Posts: 668 Location: Switzerland
|
Any FDC files? Perhaps you could send the first 30 lines of an FDC file?
Another obvious question, have you changed your Kernel params AND REBOOTED? |
|
Back to top |
|
 |
fcho |
Posted: Thu Sep 19, 2002 4:30 am Post subject: |
|
|
Apprentice
Joined: 29 May 2002 Posts: 28
|
What is FDC files? Where is the file locate?
What Kernel params need to change? How to change it?
Sorry to say that I'm very new to AIX and MQ. Very thank you to you. |
|
Back to top |
|
 |
dgolding |
Posted: Thu Sep 19, 2002 4:44 am Post subject: |
|
|
 Yatiri
Joined: 16 May 2001 Posts: 668 Location: Switzerland
|
Ah - AIX. Don't think there are any necessary kernel params there, I'll look.
FDC files are to be found in /var/mqm/errors - the name of the files are :
AMQ<process num>.0.FDC
look at the one (if there is one) generated around the time you did the "crtmqm".
More later... |
|
Back to top |
|
 |
dgolding |
Posted: Thu Sep 19, 2002 5:33 am Post subject: |
|
|
 Yatiri
Joined: 16 May 2001 Posts: 668 Location: Switzerland
|
...got your FDC file, the problem relates to getting some shared memory. As far as I can see there are no relevant kernel parms on AIX, so it's not that, BUT it seems you need the command EXTSHM=ON (this sets an environment variable to tell MQ to use extended shared memory) before you use MQ. Could you try this and recreate?
EXTSHM=ON
crtmqm DB2MQ_DEFAULT_MQM
strmqm DB2MQ_DEFAULT_MQM
Don't forget, the CASE of commands (upper/lower) is important in Unix!
Anyway, I've attached a snippet, my AIX is a bit rusty, maybe somebody else would like to comment?
+-----------------------------------------------------------------------------+
| |
| MQSeries First Failure Symptom Report |
| ===================================== |
| |
| Date/Time :- Thursday September 19 20:43:09 THAIDT 2002 |
| Host Name :- localhost (AIX 4.3) |
| PIDS :- 5765B73 |
| LVLS :- 520 |
| Product Long Name :- MQSeries for AIX |
| Vendor :- IBM |
| Probe Id :- XC149026 |
| Application Name :- MQM |
| Component :- xstIncreaseSegment |
| Build Date :- Nov 7 2000 |
| CMVC level :- p000-L001106 |
| Build Type :- IKAP - (Production) |
| UserID :- 00000007 (db2inst1) |
| Program Name :- crtmqm |
| Process :- 00084720 |
| Thread :- 00000001 |
| QueueManager :- DB2MQ_DE |
| Major Errorcode :- xecF_E_UNEXPECTED_SYSTEM_RC |
| Minor Errorcode :- OK |
| Probe Type :- MSGAMQ6119 |
| Probe Severity :- 2 |
| Probe Description :- AMQ6119: An internal MQSeries error has occurred ('A |
| system call received a parameter that is not val' from shmctl.) |
| Arith1 :- 22 16 |
| Comment1 :- 'A system call received a parameter that is not val' |
| from shmct |
| |
+-----------------------------------------------------------------------------+
MQM Function Stack
zsqSPICreateQM
kpiCreateQM
apiConfigure
aocStartDAP
xcsCreateSharedMemSet2
xstCreateSharedMemSet
xstGetMemInSegment
xstIncreaseSegment
xcsFFST |
|
Back to top |
|
 |
fcho |
Posted: Thu Sep 19, 2002 4:06 pm Post subject: |
|
|
Apprentice
Joined: 29 May 2002 Posts: 28
|
Hi,
I'am still getting the same error, don't know what to do already. _________________ Regards,
fcho |
|
Back to top |
|
 |
dgolding |
Posted: Thu Sep 19, 2002 10:46 pm Post subject: |
|
|
 Yatiri
Joined: 16 May 2001 Posts: 668 Location: Switzerland
|
I must admit I'm a bit stuck as well, I'll throw in my $0.02 until somebody with more AIX than I have can help....
Ae there any other queue managers running on this system? Check with a ps -ef|grep zxma. Maybe a good idea to do a "ps -fu mqm" as well to see if anything is hanging around.
Post the file /var/mqm/mqs.ini - maybe a clue there.
IF THERE ARE NO OTHER QUEUE MANAGERS ON THE SYSTEM, clear out old shared memory stuff using:
#!/bin/sh
# zapmq - clear out IPCS stuff for ALL queue managers
#
temp=/tmp/zapmq.$$
ipcs|grep mqm|awk '{print "ipcrm -"$1" "$2}'>$temp
. $temp
rm $temp
WARNING: If you run this when a queue manager is running, YOU WILL CORRUPT IT.
Getting desperate here, but did the installation of MQ go okay? Has anybody used MQ successfully on this box?
And really desperate, have you rebooted? This fixes everything!
 |
|
Back to top |
|
 |
fcho |
Posted: Thu Sep 19, 2002 11:51 pm Post subject: |
|
|
Apprentice
Joined: 29 May 2002 Posts: 28
|
Hi,
My AIX got few Q mgr and all are running. I still don't know what happen but I'm able to solve this with execute other user .profile first before perform enable_MQFunctions. So I think the problem is on .profile but don't know what is the root cause.
Anywhere thanks a lot. _________________ Regards,
fcho |
|
Back to top |
|
 |
bower5932 |
Posted: Wed Sep 25, 2002 9:58 am Post subject: |
|
|
 Jedi Knight
Joined: 27 Aug 2001 Posts: 3023 Location: Dallas, TX, USA
|
I thought that you might be interested in knowing what your problem was in case you (or somebody else) sees it again. This is another variation of the segment 8 problem. MQSeries doesn't use extended shared memory. You have an EXTSHM=ON in the failing profile and don't have one in the one that works. If you'll move to WebSphere MQ 5.3, MQSeries will use the EXTSHM and you shouldn't see this problem. |
|
Back to top |
|
 |
fcho |
Posted: Fri Sep 27, 2002 1:38 am Post subject: |
|
|
Apprentice
Joined: 29 May 2002 Posts: 28
|
Noted and tested ok. Thank you bower5932. _________________ Regards,
fcho |
|
Back to top |
|
 |
fcho |
Posted: Sun Sep 29, 2002 5:19 pm Post subject: |
|
|
Apprentice
Joined: 29 May 2002 Posts: 28
|
Hi bower5932,
I facing another problem when try to configure for MQ for second database as below :
enable_MQFunctions -n testDB -u testdb -p testdb
*** Please wait: creating queue manager (DB2MQ_DEFAULT_MQM) ......
*** Please wait: starting the queue manager (DB2MQ_DEFAULT_MQM) ......
(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 ......
I've check AMT_DATA_PATH, DB2.DEFAULT.SERVICE, DB2.DEFAULT.POLICY and amthost.xml, all are ok and I also try to use a sending program which point to the same amt.xml, this is no problem.
When I try to use db2 to send, problem also, refer to below :
db2 => values db2mq.mqsend('a test');
1
-
SQL0443N Routine "DB2MQ.MQSEND" (specific name "MQSND1") has returned an
error SQLSTATE with diagnostic text "rc=49:amSndOpen". SQLSTATE=38H01
I've tried to disable and enable agains MQ function but still the same, do you know why? _________________ Regards,
fcho |
|
Back to top |
|
 |
|