| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MessageID |
« View previous topic :: View next topic » |
| Author |
Message
|
| krish |
 Posted: Thu Jun 13, 2002 7:35 am Post subject: MessageID |
 |
|
Apprentice
Joined: 20 Apr 2002
Posts: 27
|
I want to insert message id, as binary data in to Db2, which data types I can use in database, i need to update the table by reply message
Do I have to convert using cast, then what datatypes is best for db2 |
|
| Back to top |
|
 |
| kirani |
| Posted: Thu Jun 13, 2002 7:56 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Define your dB colum as BLOB. You don't have to do any CASTing while inserting into db because MQMD.MsgId is of BLOB datatype.
_________________
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 |
|
|
| krish |
| Posted: Thu Jun 13, 2002 8:02 am Post subject: |
|
|
Apprentice
Joined: 20 Apr 2002
Posts: 27
|
| Thanks, but what about the performance in db2 when i update the table on my reply message using it |
|
| Back to top |
|
|
| kirani |
| Posted: Thu Jun 13, 2002 8:18 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Indeed, database operations are expensive.
Alternatively you can store MsgId on a queue and use MQGET node to retrieve them. MQGET node allows you to retrieve message by MsgID or CorrelID.
_________________
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 |
|
|
| bduncan |
| Posted: Thu Jun 13, 2002 10:09 am Post subject: |
|
|
Padawan
Joined: 11 Apr 2001
Posts: 1554
Location: Silicon Valley
|
Why exactly do you need to store the message ID in the database, and then overwrite it with the message ID of the reply message? I'm curious because if you are doing this to ensure some sort of integrity (so you always know what's been processed, what's on the queue, etc.,) you can accomplish the same thing using syncpoint without having to bring a database into the mix...
_________________
Brandon Duncan
IBM Certified MQSeries Specialist
MQSeries.net forum moderator |
|
| 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
|
|
|
|
