| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| DB2 data insert problem |
« View previous topic :: View next topic » |
| Author |
Message
|
| kiran |
 Posted: Mon Feb 10, 2003 11:25 am Post subject: DB2 data insert problem |
 |
|
Newbie
Joined: 05 Feb 2002
Posts: 3
|
Hi all,
I have a messageflow which will call a SP to store the incoming BLOB msg into a table. I have a batch with which i am trying to test and store all the 1000 BLOB msgs into the table. When i look into the table after running the batch, from 640 records same data is getting inserted into the table.The record which is getting replicated is the 639 record......all the msgs in batch are different with different loannos, which i am inserting the loanno as a PK into the table with BLOB msg.When i look into loano's in the table they r getting inserted correctly,problem is with BLOB msg only. The table is defined with loanno as varchar(20, PK) and mastermsg as BLOB(3000Bytes).I am not able to find wht's making the database to cpoy the same msgs after 639 record, is it a MQSI application memory problem or DB2 table space problem.
If any one can point me out the problem it will be a great help to me.
thanks
kiran |
|
| Back to top |
|
 |
| kirani |
| Posted: Sat Feb 15, 2003 11:44 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Is it possible to post your ESQL statement here? Are you getting these BLOB messages as single MQ message? What parser are you applying on your input message in MQInput node?
_________________
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 |
|
|
|
|
|
| |
|
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
|
|
|
|
