| Author |
Message
|
| tleichen |
 Posted: Wed Feb 27, 2008 9:00 am Post subject: Pub/Sub orphaned subscription problem |
 |
|
Yatiri
Joined: 11 Apr 2005
Posts: 663
Location: Center of the USA
|
We have the same symptom that was outlined by Paul Titherage in his report on Removing orphan JMS subscriptions with WebSphere MQ. We are particularly concerned with a symptom that is not covered in the report. Mainly, that there is a very high OpenInput count on SYSTEM.JMS.REPORT.QUEUE.
Also, every description I have found of the IH03 support pack (RFHUTIL) says it is for version 6.0 and we are using 5.3. Even if we could use this utility, the procedure he suggested is too tedious to be practical in our situation, as you must go through each orphaned subscription manually and “deregister” it. The utility is not automated; at least that’s my impression.
I have two main questions (keep in mind this is version 5.3 basic pub/sub, not full broker):
What are these open handles from and how do I get rid of them (they appear to be orphaned as well, as they are from a PID that does not exist)?
What is the solution for the orphaned subscriptions with version 5.3?
_________________
IBM Certified MQSeries Specialist
IBM Certified MQSeries Developer |
|
| Back to top |
|
 |
| bower5932 |
| Posted: Wed Feb 27, 2008 10:57 am Post subject: |
|
|
Jedi Knight
Joined: 27 Aug 2001
Posts: 3023
Location: Dallas, TX, USA
|
For starters, I'd suggest moving forward to v6.0.
As far as removing orphaned subscribers, there are a couple of java programs at:
http://www-304.ibm.com/jct09002c/isv/tech/sampmq.html
One of them is dumpbroker. It dumps all of the subscriptions. You can then edit this file and pipe it into unsubscribe.
Not sure what to do about your handles.... |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Feb 27, 2008 11:03 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
amqspsd comes with MQ v5.3, too. You don't need the dumpbroker sample.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| tleichen |
| Posted: Wed Feb 27, 2008 11:15 am Post subject: |
|
|
Yatiri
Joined: 11 Apr 2005
Posts: 663
Location: Center of the USA
|
I've run amqspsd and gotten the report. Yes, it does show all the publications/subcriptions. But, what are all these orphaned handles I mentioned and what can be done about them? Is there a way to clear these without bouncing the queue manager? 
_________________
IBM Certified MQSeries Specialist
IBM Certified MQSeries Developer |
|
| Back to top |
|
|
| tleichen |
| Posted: Wed Feb 27, 2008 2:37 pm Post subject: |
|
|
Yatiri
Joined: 11 Apr 2005
Posts: 663
Location: Center of the USA
|
or even booting the whole box? 
_________________
IBM Certified MQSeries Specialist
IBM Certified MQSeries Developer |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Feb 27, 2008 2:41 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Once you've identified an orphaned subscriber, you need to create a DesubscribeRequest message.
This can be done programatically - it's just another type of pub/sub message.
The other sample that bower5932 pointed you at will also do this for you...
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| tleichen |
| Posted: Wed Feb 27, 2008 3:05 pm Post subject: |
|
|
Yatiri
Joined: 11 Apr 2005
Posts: 663
Location: Center of the USA
|
The dumpbroker and unsubscribe routines sound promising, but will that get rid of the handles to the report queue, as well? If so, does that basically mean those handles exist until the subscription is consumed? 
_________________
IBM Certified MQSeries Specialist
IBM Certified MQSeries Developer |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Feb 27, 2008 3:08 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
... If you were running v6, I'd suggest you use DIS CONN to confirm that those open handles are what you think they are.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| tleichen |
| Posted: Thu Feb 28, 2008 10:09 am Post subject: |
|
|
Yatiri
Joined: 11 Apr 2005
Posts: 663
Location: Center of the USA
|
The dumpbroker program that bower5932 uses two jar files, com.ibm.mq.jar and com.ibm.mq.pcf.jar. I see the first one in my installation, but cannot find the second one. I also don't see it in the list of items on the webpage where the utility source is contained. Any thoughts? 
_________________
IBM Certified MQSeries Specialist
IBM Certified MQSeries Developer |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Feb 28, 2008 10:12 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| PeterPotkay |
| Posted: Thu Feb 28, 2008 4:01 pm Post subject: |
|
|
Poobah
Joined: 15 May 2001
Posts: 7722
|
MO71 allows you to admin Pub Sub stuff. I have used it to deregister dozens of orphaned subscriptions with one click.
_________________
Peter Potkay
Keep Calm and MQ On |
|
| Back to top |
|
|
| tleichen |
| Posted: Fri Feb 29, 2008 11:37 am Post subject: |
|
|
Yatiri
Joined: 11 Apr 2005
Posts: 663
Location: Center of the USA
|
I tried the java programs dumpbroker and unsubscribe, as bower5932 recommended. I'm getting an error 3073 MQRCCF_NOT_REGISTERED when I pipe my edited input into the unsubcribe program and I was wondering if maybe this is a userid problem.
There is no other security message in the logs, that I can see. I noticed that the userid on the registrations in question is MUSR_MQADMIN.
I tried specifically coding this in the userid in MQEnvironment.userID and it still gives the same result. Any thoughts on this?
_________________
IBM Certified MQSeries Specialist
IBM Certified MQSeries Developer |
|
| Back to top |
|
|
| bower5932 |
| Posted: Mon Mar 03, 2008 7:55 am Post subject: |
|
|
Jedi Knight
Joined: 27 Aug 2001
Posts: 3023
Location: Dallas, TX, USA
|
| tleichen wrote: |
| There is no other security message in the logs, that I can see. I noticed that the userid on the registrations in question is MUSR_MQADMIN. |
This looks like a system type of subscription rather than an orphaned, user subscription. What is the topic associated with this subscription? |
|
| Back to top |
|
|
| tleichen |
| Posted: Wed Mar 05, 2008 10:17 am Post subject: |
|
|
Yatiri
Joined: 11 Apr 2005
Posts: 663
Location: Center of the USA
|
I noticed some others that had a RegistrationUserid of SYSTEM. All the subscriptions I'm referencing seem to have userid MUSR_MQADMIN, I'm surmising because they were made via JMS. They are under a user topic. Here's the item that I got out of dumpbroker and am piping into unsubscribe :
Topic: TEST_TOPIC_DYNAMIC_A
BrokerCount: 0
ApplCount: 1
AnonymousCount: 0
RegistrationQMgrName: QM8
RegistrationQName: SYSTEM.JMS.D.SUBSCRIBER.QUEUE
RegistrationCorrellId: 414D51204B432E4653412E464C4453562C1B1D4620019503
RegistrationUserIdentifier: MUSR_MQADMIN
RegistrationOptions: 1048577 : MQREGO_CORREL_ID_AS_IDENTITY MQREGO_VARIABLE_USER_ID
RegistrationTime: 2007041118215892
SubscriptionName: JMS:QM8:TCF_TEST_CLID:TCF_TEST_CLID
_________________
IBM Certified MQSeries Specialist
IBM Certified MQSeries Developer
Last edited by tleichen on Wed Mar 05, 2008 11:59 am; edited 4 times in total |
|
| Back to top |
|
|
| tleichen |
| Posted: Wed Mar 05, 2008 11:04 am Post subject: |
|
|
Yatiri
Joined: 11 Apr 2005
Posts: 663
Location: Center of the USA
|
Why is unsubscribe saying this is unregistered?  |
|
| Back to top |
|
|
|
|
