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 » General IBM MQ Support » Design question about File to Queue process

Post new topic  Reply to topic
 Design question about File to Queue process « View previous topic :: View next topic » 
Author Message
Scooter
PostPosted: Thu Jun 09, 2005 11:19 am    Post subject: Design question about File to Queue process Reply with quote

Apprentice

Joined: 01 May 2003
Posts: 35
Location: Dallas, Tx

We have been using Websphere MQ for over a year to process message on a transactional base. That is we put a message on a remote queue that triggers a mainframe transactions to process it. I have now been asked to come up with a design that will transfer a file from location to the next by using Websphere MQ. Basically design an alterative to FTP. It sounds simple to them but I’m having a nightmare determining the best approach for this. I hope someone can help point me in the direction for the best approach to this issue. Good news is that the design only needs to work within a Unix (AIX) environment on both ends.

One of the approaches I have come up with would be to read the file and put each record into its own message. To handle large files I would group the message into Units of work and commit each unit of work as it completes. These units of work would be put on a remote queue that would transfer the units of work to a local queue on mainframe. With this approach I would need a way to trigger the mainframe program to start processing the units of work before all the units of work are in the local queue. This would be needed because we have to indicate the message limit on the local queue and since the file being transferred could be larger then the queue limit. This is where things start to get fuzzy for me. If the sending program has any problems and doesn’t completely convert the file to units of work and needs to be restarted then the receiving program will need to stop looking for more units of work until sender is restarted. Would this be a spot to use a secondary queue to relay control messages like restarts and new files messages?

The second approach would be the same as the first with the exception of using dynamic local queues that could be created to hold the size of the file that is being transferred. Each file would have its own queue. Problem with this is I’m not sure I can create dynamic local queues when using a remote queue to send the messages to another server. This approach is a lot more foreign to me but if it is a better approach then I will learn.

I know this is an odd post but I’m completely lost and not even sure either of these is the best approach to the problem. Heck, I may be so far off base that it can’t even be done. I appreciate any input you guys have.
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Thu Jun 09, 2005 11:29 am    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Just buy CommerceQuest's PM4Data.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
Scooter
PostPosted: Thu Jun 09, 2005 11:32 am    Post subject: Reply with quote

Apprentice

Joined: 01 May 2003
Posts: 35
Location: Dallas, Tx

Do you you have a URL to this product by chance? No since in building it again if it has been done.
Back to top
View user's profile Send private message
Scooter
PostPosted: Thu Jun 09, 2005 11:59 am    Post subject: Reply with quote

Apprentice

Joined: 01 May 2003
Posts: 35
Location: Dallas, Tx

Thanks, I found the site.

But let's say management doesn't want to spend the money for a third party package and I'm forced to come up with a home made solution. Would you have any suggestions or comments on the design of this component?
Back to top
View user's profile Send private message
zpat
PostPosted: Thu Jun 09, 2005 12:01 pm    Post subject: Reply with quote

Jedi Council

Joined: 19 May 2001
Posts: 5866
Location: UK

Between two distributed platforms, you can use reference messages to perform file transfer. No need to read the file/write the file - let the queue managers do that for you.
Back to top
View user's profile Send private message
jefflowrey
PostPosted: Thu Jun 09, 2005 12:56 pm    Post subject: Reply with quote

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Scooter wrote:
But let's say management doesn't want to spend the money for a third party package and I'm forced to come up with a home made solution. Would you have any suggestions or comments on the design of this component?


There's a, well probably a rant, I just posted in the Java/JMS forum about writing file to queue adapters.

If nothing else, it will give you a good list of justifications for buying PM4Data.

PM4Data also has an IBM part number, so you can buy it from IBM and get whatever volume discount you already get.
_________________
I am *not* the model of the modern major general.
Back to top
View user's profile Send private message
Scooter
PostPosted: Thu Jun 09, 2005 1:28 pm    Post subject: Reply with quote

Apprentice

Joined: 01 May 2003
Posts: 35
Location: Dallas, Tx

Thanks guys as always you have helped me greatly. I will push for the PM4Data but using reference message is a very good option and provided to be some enlighten reading.
Back to top
View user's profile Send private message
PeterPotkay
PostPosted: Thu Jun 09, 2005 1:40 pm    Post subject: Reply with quote

Poobah

Joined: 15 May 2001
Posts: 7722

Check out MQSoftware's solution to the problem also, QDataLink:
http://www.mqsoftware.com/product/studioTools.jsp
Quote:

This is the Data Transformation tool, which converts files to WebSphere MQ messages and WebSphere MQ messages to files. Q DataLink enables file-based applications to utilize the assured, once-only delivery of WebSphere MQ.

QLinear may also do what you want:
Quote:

As the Data Transport piece Q Liner offers message and file based transfers, multiple-platform support and assured accurate data flow. Q Liner helps organizations achieve quality application integration by providing the accuracy and integrity needed for movement of crucial corporate assets - data.

_________________
Peter Potkay
Keep Calm and MQ On
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 » General IBM MQ Support » Design question about File to Queue process
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.