| Author |
Message
|
| javagate |
 Posted: Wed Mar 08, 2006 7:00 am Post subject: Bulk Data Transfers using MQSeries |
 |
|
Disciple
Joined: 15 Nov 2004
Posts: 159
|
In general do people use MQSeries to do a lot of bulk data transfers?
ex, using MQSeries when converting mainframe database to an AIX box.
_________________
WebSphere Application Server 7.0 z/OS &
MQ 6.0. I work with WebSphere in the real world not in some IBM lab. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Mar 08, 2006 7:05 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
There's a DB2 replication tool that uses MQSeries.
Well, okay. It's part of "WebSphere Information Integrator".
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| vennela |
| Posted: Wed Mar 08, 2006 10:58 am Post subject: Re: Bulk Data Transfers using MQSeries |
|
|
Jedi Knight
Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India
|
| javagate wrote: |
In general do people use MQSeries to do a lot of bulk data transfers?
ex, using MQSeries when converting mainframe database to an AIX box. |
I worked on a project where they used MQ to keep iSeries DB2 databases in sync with Oracle DBs on AIX and MQ was the data transportation piece. |
|
| Back to top |
|
|
| mvic |
| Posted: Wed Mar 08, 2006 12:38 pm Post subject: Re: Bulk Data Transfers using MQSeries |
|
|
Jedi
Joined: 09 Mar 2004
Posts: 2080
|
| javagate wrote: |
| In general do people use MQSeries to do a lot of bulk data transfers? |
What kind of numbers are you thinking of? |
|
| Back to top |
|
|
| javagate |
| Posted: Thu Mar 09, 2006 4:43 am Post subject: |
|
|
Disciple
Joined: 15 Nov 2004
Posts: 159
|
Total of 700,000 messages at a max record length of 12,000 bytes each.
I was wanting to know if MQ Admin folks in general would consider this acceptable means of data transfer for MQSeries. In this case this is not a permanent process.
As an MQ Admin myself I have no problems when Applications wants to use MQSeries. And as a System Programmer I naturally want/try to fix things. But there are those who will hammer MQ every chance they get when MQSeries is not used in a request/reply application. ... In their minds a message should only be on a queue for less then a second. I have many customers who store messages on queues and process later and store a backup message on a queue and delete with an expiry time. All this is an acceptable offline use of MQ as I see it. There is certain housekeeping that MQ will do for you and one does not have to learn.
_________________
WebSphere Application Server 7.0 z/OS &
MQ 6.0. I work with WebSphere in the real world not in some IBM lab. |
|
| Back to top |
|
|
| ashoon |
| Posted: Thu Mar 09, 2006 5:06 pm Post subject: mq as a transport mechanism |
|
|
Master
Joined: 26 Oct 2004
Posts: 235
|
I did a comparison once between FTP (typical method for bulk data transfer) to MQ.
MQ was WAY faster... the analogy I used is that FTP is like a sports car - can go very fast however it can only take two people. What hapens with bulk transfer is that you get many cars on the highway aka traffic jam. MQ channels are like buses - they take more people at a constant pace therefore when moving alot of data the buses don't clog the highway.
HTH |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Mar 09, 2006 5:23 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Also, CommerceQuest did well enough with writing bulk data/file transfer applications that a) you can buy PM4Data through IBM, and b) they are now owned by MetaStorm.
It's a perfectly valid, in my opinion, use of MQ. It's also a complicated enough problem at the enterprise level, that in my opinion it is better to BUY than to BUILD.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
|
|
