| Author |
Message
|
| sarathmattam |
 Posted: Thu Nov 26, 2009 8:19 am Post subject: Subscription Requests not available in BSUBSCRIPTIOS Table |
 |
|
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 |
|
 |
| AkankshA |
| Posted: Fri Nov 27, 2009 12:35 am Post subject: |
|
|
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 |
|
|
| sarathmattam |
| Posted: Sat Nov 28, 2009 1:11 pm Post subject: |
|
|
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 |
|
|
| fjb_saper |
| Posted: Sat Nov 28, 2009 6:52 pm Post subject: |
|
|
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 |
|
|
| sarathmattam |
| Posted: Sun Dec 06, 2009 5:00 am Post subject: |
|
|
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 |
|
|
| student |
| Posted: Mon Dec 07, 2009 6:49 am Post subject: |
|
|
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 |
|
|
|
|
