ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WQMI Orphan Subscriptions

Post new topic  Reply to topic
 WQMI Orphan Subscriptions « View previous topic :: View next topic » 
Author Message
Deeko
PostPosted: Thu Sep 25, 2003 1:00 am    Post subject: WQMI Orphan Subscriptions Reply with quote

Acolyte

Joined: 16 May 2001
Posts: 72
Location: Edinburgh, UK
Hi,

I've done a search for this problem but I can't find anything.

We're using JMS PubSub (in WAS4.02) in a number of Servlets and EJBs. The subscriptions are managed by a WMQI 2.1 broker.

Unfortunately, our operations people stop WAS abnormally now and again (a bit too frequently for my liking!) and this results in the JMS cleanup steps for non-durable subscribers not being performed. The result is a lot of orphan entries in BSUBSCRIPTIONS and BCLIENTUSER tables (as a reulst of this our Broker Database exceeded its 50Mb limit!). We're using a single subscriber queue solution (which also utilises CorrelId)

Anyone got any idea how we can clean these up? We've looked at issuing SQL against the tables but IBM have their "timestamp" in a CHAR column and some of the other columns seem to have null delimiters in them!

We could move to a multiple queue solution but I'm worried WAS might not let the temporary dynamic queues go and we could end up with loads of them!

Regards,

Derek.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
jefflowrey
PostPosted: Thu Sep 25, 2003 6:28 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981
Can't you delete the bad subscriptions from the Control Center?
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
Deeko
PostPosted: Thu Sep 25, 2003 6:43 am    Post subject: Reply with quote

Acolyte

Joined: 16 May 2001
Posts: 72
Location: Edinburgh, UK
JeffLowrey wrote:
Can't you delete the bad subscriptions from the Control Center?


Ermm.....you can but there are around 7000 of them and the good ones (around 200) are interspersed in amongst the bad ones! No easy way to sort them either as the dates are really of no great use!

Regards,

Derek.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » WQMI Orphan Subscriptions
Jump to:  



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
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.