I am inserting data into tables using ESQL coding.
But in one broker and DB2 in a system it is working fine for around 30000 rows and more upto 1 lack rows.
But the same flow in other broker and DB2 is only able to insert upto 30000 rows, above which it is throwing exception-
Recoverable Exception, Retry processing failed message.
Is this some Environment issue in DB2 or in the Message flow.

can you at least post the complete error message (sqlcode-sqlstate)

The SQL states and codes are not there.
It is just Retry,processing failed message.

please try to debug and add as much info/error as possible
without errorcode nobody knows what is going wrong and how to correct if you don't know what is the error..
I could say.. drop the db and all problems will be resolved..

If a heavy message file is sent it is not going into debug mode also.
Only for small files it is going in debug mode and inserting properly.
The problem comes in Heavy file and that to in one DB and broker it is working fine and giving the exceptions in other DB and broker with the same flows and inputs.
drop the db ???

If you do not have db2 specific information, posting on this forum is of little help.

Post in the broker support forums. You may find someone who has experienced this.


-

ok thank you, but the only thing that this issue is not the DB issue, I wanted to confirm that thing only.
Do we need to do some settings or changes so that 1 lac rows can be inserted into two inter-related tables.As it is working in one DB but in other DB is is giving exception.

how do you want us to give a hint/answer if we don't know what is the problem
otherwise it would be driving in the dark without any lights.. and see what we are hitting..

I don't think this is a DB2 error

Message Broker Help Home Documentation

You are getting a Recoverable error and not a database error.

As Guy says, it is not possible to provide any guidance without knowing anything about the error.