MQSeries.net :: View topic - DB value change alert

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » DB value change alert

DB value change alert

« View previous topic :: View next topic »

Author

Message

deepak_paul

Posted: Tue May 04, 2010 9:41 am Post subject: DB value change alert

Centurion

Joined: 04 Oct 2008
Posts: 147
Location: US

We are using a Shared Row variable to dump all the database table values(around 1500 records). First time messages flow hits the database and fills up shared row. Next time onwards, message flows retrieves from Shared row.

Now we need to know how we have to handle when there is a change in table values.

A few suggestions:
1. DB owner has to create an application which drops a message to a MQ whenever the DB is updated.
2. A message flow can be set to be running all the times(24/7) which hits the Database and checks the DB values with Shared Row variable.

I would like to know which would be the best approach to go ahead.
_________________
Regards
Paul

fatherjack

Posted: Tue May 04, 2010 11:34 pm Post subject:

Knight

Joined: 14 Apr 2010
Posts: 522
Location: Craggy Island

If the database is volatile then you probably don't want to put the data in shared rows. If it updaed only occassionally and the changes are under your control then restart the flows at the same time the database is updated.

Rgds

Fr. Jack.
_________________
Never let the facts get in the way of a good theory.

mqjeff

Posted: Wed May 05, 2010 2:24 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

If you have some reasonable, fixed interval in which it is "legal" to use the old values, then use a Timeout node to refresh the shared rows.

Or look at the Cache SupportPac.

deepak_paul

Posted: Sat May 08, 2010 7:54 am Post subject:

Centurion

Joined: 04 Oct 2008
Posts: 147
Location: US

fatherjack wrote:

Is there any way to automate the process of restating the message flows possibly using any scripts/commands?
_________________
Regards
Paul

harish_td

Posted: Sat May 08, 2010 9:32 pm Post subject:

Master

Joined: 13 Feb 2006
Posts: 236

http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r1m0/index.jsp?topic=/com.ibm.etools.mft.doc/an26100_.htm

http://publib.boulder.ibm.com/infocenter/wmbhelp/v7r0m0/index.jsp?topic=/com.ibm.etools.mft.doc/bb45000_.htm

fatherjack

Posted: Mon May 10, 2010 12:10 am Post subject:

Knight

Joined: 14 Apr 2010
Posts: 522
Location: Craggy Island

deepak_paul wrote:

Is there any way to automate the process of restating the message flows possibly using any scripts/commands?

You just answered your own question - write a script to execute the appropriate stop and start commands.

Fr. Jack
_________________
Never let the facts get in the way of a good theory.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » DB value change alert

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