| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Db2 file transfer throu WBIBroker2.1 |
« View previous topic :: View next topic » |
| Author |
Message
|
| maruthi_P2003 |
 Posted: Thu Jan 01, 2004 11:45 pm Post subject: Db2 file transfer throu WBIBroker2.1 |
 |
|
Acolyte
Joined: 09 Dec 2003
Posts: 63
|
HI,
I would like send the DB2 Database Backup files from different Client Locations to the
Central Db2 Database for upload at the end of the Business day through MQSeries.
(previously we are sending using some ftp tool)
env.WMQ5.3 +WBusiIntegrationBroker 2.1 on AIX Cluster Server.
My Question is whether WBIBroker 2.1 can support this format of the Db2 Backup files
(143436.001)..I have created a sample database in Db2 and taken Backup using the wizard.
The file is in ( .001) extension..
Since Broker 2.1 ,if it could not able to find the Supported parser , it will call the BLOB Parser..
I am not sure abt this. Plz suggest this is a good way or not.?
Regards,
maruthi |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Jan 02, 2004 5:29 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What are you trying to use Integrator for in this scenario?
If you're just trying to replace an FTP process, you can use a standard MQSeries application - preferrably using reference messages to ensure that you're not concerned about message size limits.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| maruthi_P2003 |
| Posted: Fri Jan 02, 2004 9:03 pm Post subject: |
|
|
Acolyte
Joined: 09 Dec 2003
Posts: 63
|
hi Jeff,
we are using MQseries for communication between two Systems using XML message format. Here we are planing to use (WMQ5.3+WBIBroker2.1).
In the Second senario, we have are sending Db2files from 30-40 locations to a Central Db2 Server machine & from Central Db2 machine aslo we need to send files(updates of some Db2 files to regional Db2 databases)
so thinking of using MQSeries for it.
Since its a Pub-sub senario.
What do u suggest? plz correct me.
Regards,
satya |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Sat Jan 03, 2004 7:12 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| maruthi_P2003 wrote: |
In the Second senario, we have are sending Db2files from 30-40 locations to a Central Db2 Server machine & from Central Db2 machine aslo we need to send files(updates of some Db2 files to regional Db2 databases)
so thinking of using MQSeries for it.
Since its a Pub-sub senario. |
What format are these DB2 files/updates in? What application is supposed to make use of them?
In order for WMQI to be any use, other than as a Pub/Sub broker (and even then, to take full advantage of it's functions as a pub/sub broker), WMQI needs to be able to parse the data in the messages.
This means that the messages must either be "self-defining", like XML, or have a logical model built that describes them.
If you have neither of these things, you shouldn't be using WMQI. It will act as a Pub/Sub broker, but you will not be able to take advantage of the content-based subscriptions. You will not be able to access the data as anything other than BLOB data - and you might as well be using a plain MQSeries application then.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| maruthi_P2003 |
| Posted: Sat Jan 03, 2004 7:27 am Post subject: |
|
|
Acolyte
Joined: 09 Dec 2003
Posts: 63
|
hi jeff,
i know that i am not going to take full advantage of WMQI it's functions as a pub/sub broker. You are right.i agree with You.
| Quote: |
| You will not be able to access the data as anything other than BLOB data |
Yes,its going to be BLOB data only.The file format will be (.001),i have taken a sample Db2 backup on my sys.
since i am going use it ,since my client want to develop on it.
regards
maruthi |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
