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 IndexGeneral DiscussionAny tool to save Messages in DB with a nice Web GUI?

Post new topicReply to topic
Any tool to save Messages in DB with a nice Web GUI? View previous topic :: View next topic
Author Message
aerosteak
PostPosted: Sat Nov 20, 2010 7:50 pm Post subject: Any tool to save Messages in DB with a nice Web GUI? Reply with quote

Newbie

Joined: 16 Oct 2008
Posts: 9

Hello
Do you know a tool or an Application providing the following capabilities:
- Can read message from a queue and write it back to a DB including all headers, body etc
- Provide a nice Web UI to let us Resend any messages from this DB using some criteria’s like:
o Take all Messages with timestamp yyyy-mm-dd with Message ID from 0 to 200 and resend them into queue X.

We have some systems that communicates using MQ but are quite unreliable. For any reasons, a system owner can call us and say: I lost your messages Please send me back all today’s and yesterday’s messages.

We are about to build this Application in-house but it sound like a Basic feature for year 2010, so I am just asking.

Thank you.
Back to top
View user's profile Send private message
bruce2359
PostPosted: Sat Nov 20, 2010 10:48 pm Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.

No. Have you found anything like this in your research?
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live.
Back to top
View user's profile Send private message
aerosteak
PostPosted: Mon Nov 22, 2010 7:19 am Post subject: Reply with quote

Newbie

Joined: 16 Oct 2008
Posts: 9

Hello

I did not find any product beside the one made by Cressidia (a sponsor of this Forums).

I am surprise to see that a basic requirements (although outside of the scope of MQ) like 'resending messages' is not more wide spread.

In our case, we are lucky because our System allow duplicate messages.
This will prevent us from installing MQ Server on every machine and pay lots of licenses.
Back to top
View user's profile Send private message
mqjeff
PostPosted: Mon Nov 22, 2010 7:35 am Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447

I believe IBM Software Services for WebSphere has some assets in this area, a Message Replay server of some kind.

This would also be a fee-based solution, but you could discuss it with your IBM sales team.
Back to top
View user's profile Send private message
exerk
PostPosted: Mon Nov 22, 2010 7:40 am Post subject: Reply with quote

Jedi Council

Joined: 02 Nov 2006
Posts: 6339

aerosteak wrote:
...In our case, we are lucky because our System allow duplicate messages.
This will prevent us from installing MQ Server on every machine and pay lots of licenses.


Not quite sure I see the link between duplicate messages and number of queue managers...care to explain?
_________________
It's puzzling, I don't think I've ever seen anything quite like this before...and it's hard to soar like an eagle when you're surrounded by turkeys.
Back to top
View user's profile Send private message
bruce2359
PostPosted: Mon Nov 22, 2010 8:53 am Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.

Quote:
- Can read message from a queue and write it back to a DB including all headers, body etc
- Provide a nice Web UI to let us Resend any messages from this DB using some criteria’s like:
o Take all Messages with timestamp yyyy-mm-dd with Message ID from 0 to 200 and resend them into queue X.


You should think of WebSphere MQ as a pipe, a transport mechanism, through which messages flow - with the benefit of assured message delivery.

IBM, and ISV's market other products that make use of WMQ as the transport. These other products address application-oriented requirements, like those you mentioned.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live.
Back to top
View user's profile Send private message
aerosteak
PostPosted: Tue Nov 23, 2010 6:03 pm Post subject: Reply with quote

Newbie

Joined: 16 Oct 2008
Posts: 9

I realize comment was a bit confusing. There is no link between the message affinity and the number of Queue Manager.

Here is more detail on our challenges:

We have a System that will generate events. These events will go through different Application on different servers using MQ.

The talked a lot to Mq “SME’s” (between quotes) about having a fully guarantee delivery solution. The project is now looking at installing a MQ Server Instance on each server to have the auto-reconnection when the network is lost and the “fire-and-forget” feature.

Currently, most of our Application that uses MQ client have an hard time reconnecting ‘gracefully’ to our main MQ server after a connection failure.

By interconnecting each MQ Server together (and not using Client connections), MQ will manage the reconnection and will keep messages locally. This is nice but then you need buy a license for each server in your solution (plus you need to administer all these new instances…).

In our case, we decided that if a failure occurs (rarely), we will simply resend all messages during that period. This way, we only have on single high available MQ instance.

Let me know if this makes sense to you.
Back to top
View user's profile Send private message
manoj798
PostPosted: Tue Nov 23, 2010 7:07 pm Post subject: Reply with quote

Apprentice

Joined: 17 Nov 2009
Posts: 30

I think Websphere Message broker is useful in this situation...
Back to top
View user's profile Send private message
bruce2359
PostPosted: Tue Nov 23, 2010 7:11 pm Post subject: Reply with quote

Poobah

Joined: 05 Jan 2008
Posts: 9469
Location: US: west coast, almost. Otherwise, enroute.

Some points:

WMQ assures delivery of all messages, as described in the official IBM WMQ documentation, and as has been described here in many, many posts.

Fire-and-forget (not a term used in any official IBM WMQ documentation that I've encountered. It means that the application doesn't care if one, some or all messages, fail to get delivered. Are you sure your developers will be satisfied with this?

At MQ v7, client applications can re-connect in a variety of ways not previously available pre-v7.

I gather that saving $ is the most important issue under consideration.

There is an age-old conundrum that applies to all undertakings - including
IT projects. Draw a triangle. Label one point with a $ ($=cost). Label another point with Q (Q=quality). Label the last point with T (T=time).

In any undertaking, you (your organization) has the three pointed conundrum, where you (your organization) can only achieve 2 of the three points. It is not possible to achieve all three.

If you want to save $, then you will sacrifice one of the other points - quality or time. If you want quality, you will sacrifice time or $. If you want speed (time), you will sacrifice $ or quality.

So, WMQ clients are cheap, but suffer some reliability issues - as you have observed. Qmgr-to-qmgr point-to-point channels are more robust; but, as you have stated, qmgrs cost a license (negotiable with your IBM rep).

Are the messages valuable to your organization? If not, fire-and-forget.
_________________
I like deadlines. I like to wave as they pass by.
ב''ה
Lex Orandi, Lex Credendi, Lex Vivendi. As we Worship, So we Believe, So we Live.
Back to top
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexGeneral DiscussionAny tool to save Messages in DB with a nice Web GUI?
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.