| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Logging, in coming Messages |
« View previous topic :: View next topic » |
| Author |
Message
|
| kiran26 |
 Posted: Tue Jul 02, 2002 8:02 am Post subject: Logging, in coming Messages |
 |
|
Acolyte
Joined: 06 Feb 2002
Posts: 69
|
Hi all,
I have to log all XML message which are coming into my message flow. For that i am using database node to log into a DB2 table , but how to clear all the message which are 3 days old from my LOG table. One more question is how to save a very big xml message into a table column.If any one can reply me on this it will be a great help to me.
Thank's
Vishnu |
|
| Back to top |
|
 |
| kirani |
| Posted: Tue Jul 02, 2002 8:48 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Either you can use a database node (or DataDelete node) to delete records from DB2 log table within a message flow, or you can write a DB script, which runs every day to delete records.
To store large xml messages into a table, you can define the DB column as BLOB or CLOB. The size of the field can be decided by looking at your expected input message size.
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| Miriam Kaestner |
| Posted: Wed Jul 03, 2002 11:19 pm Post subject: |
|
|
Centurion
Joined: 26 Jun 2001
Posts: 103
Location: IBM IT Education Services, Germany
|
Another design idea: Instead of writing the incoming messages directly into a database, you could use Pub/Sub.
So, publish incoming messages as retained publications with an expiration time of 3 days. Retained publications are automatically stored in the broker DB. You don't have to clean up expired publications - this is done automatically by the broker. Plus, any "newcomer" applications that might want these messages in the future do simply have to subscribe. |
|
| Back to top |
|
|
| udaybho |
| Posted: Mon Jul 08, 2002 12:33 pm Post subject: |
|
|
Voyager
Joined: 09 May 2002
Posts: 94
Location: Chicago
|
How about using Warehouse Node ?
Uday Bhosle |
|
| 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
|
|
|
|
