MQSeries.net :: View topic - Problems with database when num of records exceed 650

Deepika · Posted: Tue Feb 11, 2003 11:21 pm Post subject:

We have a message flow that writes data into the database on it way to the backend and on the way back retrieves the original message to output the response message concatenated with the original message.Now till the time we have some 600-700 records the flow works fine but once the number of records in the database exceed this limit of 600-700 records the insertion into the database is successful, however the select from the database returns a NULL value.We have tried reading the SQLCA and found that both the SQLCODE and the SQLSTATE return ZERO (0) everytime.To get rid of the problem we need to stop and restart the broker and also purge the database and it starts functioning normally.But the same problem returns onece the records exceed 600-700.It may be noted that we are inserting BLOB data into the database and the selection of record from the database is based on a BLOB field (which is the MsgId and the CorrelId)Dont know if that would anyway make any difference.
Any help insolving this problem is appreciated.