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 » Subscription Requests not available in BSUBSCRIPTIOS Table

Post new topic  Reply to topic
 Subscription Requests not available in BSUBSCRIPTIOS Table « View previous topic :: View next topic » 
Author Message
sarathmattam
PostPosted: Thu Nov 26, 2009 8:19 am    Post subject: Subscription Requests not available in BSUBSCRIPTIOS Table Reply with quote

Voyager

Joined: 05 Sep 2008
Posts: 94

Dear All,

I am working in Solaris environment with MB 6.1.0.2 & MQ 6. I have few pub sub flows and all are deployed in one particular broker. In TEST environment i can see all these subscription requests in BSUBSCRITPIONS table of BROKER DB.

But in my PROD environment, i am not able to find any subscription requests in the above table. But the flows are working perfectly. The only difference between the two environments are that my PROD is Clustered using the Sun Cluster. The flows are working perfectly until cluster switches. Once it is switched , i ahve to repost the subscription requests again. But still i will not be able to find those entries in the BSUBSCRITPIONS table.

Kindly Help if you guys have any idea. Please find the table screen shots in PROD


PROD :
----------------------------------------------------

+--------------------------------+----------------------------------+---------------------+---------------------+-------------+------------------------------------------------------------------+----------------------------------+----------------------------------+----------------------------------+
| SubscriptionId | ClientId | Expiration | Creation | Options | Topic | SubPoint | Filter | SubInfo |
+--------------------------------+----------------------------------+---------------------+---------------------+-------------+------------------------------------------------------------------+----------------------------------+----------------------------------+----------------------------------+
| 2008-11-17 18:17:4200000 | PRD1.CFG.QMGR:SYSTEM.BROKER.ADMIN.REPLY:4366674d677253756231 | *Unlimited Expiry * | 2008-11-17 15:17:42 | 4868 | $SYS/Broker/+/Status | | | applIdentityData mbid |
| 2008-11-17 18:17:4200001 | PRD1.CFG.QMGR:SYSTEM.BROKER.ADMIN.REPLY:4366674d677253756233 | *Unlimited Expiry * | 2008-11-17 15:17:43 | 4868 | $SYS/Broker/+/Status/ExecutionGroup/# | | | applIdentityData mbid |
| 2008-11-17 18:17:4200002 | PRD1.CFG.QMGR:SYSTEM.BROKER.ADMIN.REPLY:4366674d677253756234 | *Unlimited Expiry * | 2008-11-17 15:17:43 | 4868 | $SYS/Broker/+/Subscription/# | | | applIdentityData mbid |
| 2008-11-17 18:17:4200003 | PRD1.CFG.QMGR:SYSTEM.BROKER.ADMIN.REPLY:4366674d677253756236 | *Unlimited Expiry * | 2008-11-17 15:17:43 | 4868 | $SYS/Broker/+/warning/expiry/Subscription/# | | | applIdentityData mbid |
+--------------------------------+----------------------------------+---------------------+---------------------+-------------+------------------------------------------------------------------+----------------------------------+----------------------------------+----------------------------------+
BIP8071I: Successful command completion.


Regards,
Sarath
Back to top
View user's profile Send private message
AkankshA
PostPosted: Fri Nov 27, 2009 12:35 am    Post subject: Reply with quote

Grand Master

Joined: 12 Jan 2006
Posts: 1494
Location: Singapore

i feel collective OR cloning set up is widely used to have replicated subscriptions etc....

since your flows are working fine... i would say that WMB is fine


may be some cluster set up step was missed out.. just may be
_________________
Cheers
Back to top
View user's profile Send private message Visit poster's website
sarathmattam
PostPosted: Sat Nov 28, 2009 1:11 pm    Post subject: Reply with quote

Voyager

Joined: 05 Sep 2008
Posts: 94

Yes. Currently it is working fine ....

But am using DB2 9.5 as my application and broker database. And DB is also in cluster. When Broker switches, the application DB & Broker DB apart from BSUBSCRIPTIONS table are maintaining the records.

Also my concern is why the subscriptions are not available in the table?? Even with out this, how it works ??
Back to top
View user's profile Send private message
fjb_saper
PostPosted: Sat Nov 28, 2009 6:52 pm    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

You never specified whether your subscriptions are durable or not.
If your subscriptions are not durable it is working as defined... When the failover gets initiated you will have to renew the subscription on the failover broker.

If your subscriptions are durable open a PMR...
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
sarathmattam
PostPosted: Sun Dec 06, 2009 5:00 am    Post subject: Reply with quote

Voyager

Joined: 05 Sep 2008
Posts: 94

Thanks for you reply ..

I have configured PROD & TEST in the same way .. And the subscription in TEST remains even after the restart of the Box .. But PROD

I think its something to do with the cluster set up ..
Back to top
View user's profile Send private message
student
PostPosted: Mon Dec 07, 2009 6:49 am    Post subject: Reply with quote

Apprentice

Joined: 17 Mar 2009
Posts: 31
Location: UK

How many broker are there in the cluster. Could you provide more details regarding your design. It seems like database replication is not happening after cluster switching.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Subscription Requests not available in BSUBSCRIPTIOS Table
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.